Unofficial Access Stuff

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Friday, September 24, 2010 – Permalink –

Define Relationships by Keyboard

It's not a drag

If you've played with Access, you know that you can create relationships by dragging fields from one table to another.

There is another way to do it using just the keyboard.

I don't know why you would do it this way, but let's assume you lent your mouse to your brother-in-law for the week-end. (?)

Close any open tables.

Use F11 to switch to the Database window.

Press ALT+T to select the Tools menu, and then press R to open the Relationships window.

If the Show Table dialog box does not appear, press ALT+R to select the Relationships menu, and then press T to open the Show Table dialog box.

In the Show Table dialog box, select the first table that you want to relate, and then press ENTER to add it to the Relationships window.

Repeat step 5 for any other tables you want to relate, and then press ALT+C to close the Show Table dialog box.

Press ALT+R to select the Relationships menu, and then press R to open the Edit Relationships dialog box.

Press ALT+N to open the Create New dialog box.

In the Left Table Name box, select the name of the table that contains the primary key.

In the Right Table Name box, select the name of the table that contains the foreign key.

In the Left Column Name box, select the primary key field, and in the Right Column Name box, select the foreign key field.

Press ENTER.

In the Edit Relationships dialog box, use the arrow keys to make sure that the two columns contain the field names you want.

Press ALT+C to create the relationship.

MSDN.Microsoft.com:
Define relationships by using the keyboard

See all Topics access
Labels: Relationships, Tips

<Doug Klippert@ 3:04 AM

Comments: Post a Comment

Thursday, September 23, 2010 – Permalink –

Font Properties Plus

Everything you need to know

To embed a font in a document or slide show so it can be displayed on any other machine, the font must support that action. The standard Windows properties statement does not show all the needed information.

The bottom of this illustration shows the standard information shown when you right-click a font file, and choose properties. The two views at the top are what appear when the Microsoft Font properties extension is installed.

If you right click on a font file in Windows its basic properties are displayed. The Font properties extension adds several new property tabs to this properties dialog box. These include information relating to font origination and copyright, the type sizes to which hinting and smoothing are applied, and the code pages supported by extended character sets.

It also will tell you if the font can be embeddedand/or edited in a document.

Protected

The font may not be embedded, copied, or modified. If you use a protected font in a document and if the document is opened on a computer that does not have the font installed on it, a font substitution occurs. Word substitutes the closest font available on the computer for the missing protected font.

Print/Preview

The font is embedded and temporarily loaded on the target computer. Documents that contain print/preview fonts must be opened read-only, and no edits are stored in the document. Embedding a font of this nature has the least impact on file size increase.

Editable

The font behaves just like the print/preview fonts, except that you may also apply the font to other text in the same document.

Installable

The font is installed on the target computer permanently when you open the document. This allows you to use the new fonts as if you installed the fonts directly into Windows yourself. This type of embedded font has the greatest impact on file size because the entire font or fonts are included with the document.

Versionand Features tabs

The Version tab includes version and date information. The Features tab describes the font in terms of number of glyphs, number of kerning pairs, the possible existence of a euro symbol and the presence of embedded bitmaps within the font.

Linkstab

If a font doesn't include a Web site URL, but does include a 'vendor ID code' a link will be provided to Microsoft's font vendor database.

The latest version is 2.3 as of December, 2006.
Font properties extension, version 2.3
(32-bit only)

See all Topics access
Labels: Fonts, Properties, Tips

<Doug Klippert@ 3:46 AM

Comments: Post a Comment

Friday, September 17, 2010 – Permalink –

Search the Way You Want

It's your choice

Using Find in Access can be frustrating when you forget to change the search options.

You can change the defaults to something closer to your personal search preferences.

To do so, select Tools>Options from the menu bar (the Office Logo in 2007).

Then, click on the Edit>Find tab (under Advanced in 2007) and select the option button you want from Default Find>Replace Behavior.

Fast Search is the default, and causes Access to search the current field for an exact match to your criteria.

General Search, searches all fields and matches any part of the field.

Start Of Field Search, searches the current field for matches between your search string and the beginning characters in the field.

When you've made your selection, click OK.
See all Topics access
Labels: Customize, General, Tips

<Doug Klippert@ 3:12 AM

Comments: Post a Comment

Friday, September 10, 2010 – Permalink –

View Related Fields

The whole thing

When designing a query, you'll often find the need to temporarily view fields beyond the ones you want shown in the final result.

To do so, you probably drag the relevant fields to the design grid and then delete them when you're done. However, there's an easier way to view the data that you typically want excluded in the query.

To do so:

Open the query in Design view.

Display the query's Properties sheet

Set the Output All Fields property setting to Yes

Run the query

Data from all of the underlying tables' fields will be displayed in addition to the fields you specified in the QBE grid. To change the query so that it only displays the fields explicitly selected in the QBE grid, simply
reset the Output All Fields property to No.

See all Topics access
Labels: General, Properties, Relationships, Tips, Tutorials

<Doug Klippert@ 3:22 AM

Comments: Post a Comment

Thursday, September 02, 2010 – Permalink –

Progress Bar for Forms

Show movement

You can display computer time by using the Microsoft Progress Bar Control. In earlier versions of Access, it can be found by using the "More Controls icon in the Toolbox. In Access 2007 it's under "Insert Active X Control".

Here are the instructions from FunctionX.com
Progress Clock

See all Topics access
Labels: Customize, Forms, General, Macros, Progress, Tips, Tutorials

<Doug Klippert@ 3:05 AM

Comments: Post a Comment