Fonts are a luxury that we often take for granted. But the fonts that are available on the system you use to create a PowerPoint presentation might not be available propecia instructions on the system you actually use to share the presentation. At best, the system will substitute a font that works well enough. At worst, the system will substitute a font that makes a mess. Don’t leave such an important visual tool up to chance.

The good news is that you can save the fonts you use in your presentation with your presentation. It won’t matter if the presentation system doesn’t have your fonts of choice because you’ll have them. Simply tell PowerPoint to save the fonts as follows:

The main reason I’m mentioning this feature is because it’s so hard to find in PowerPoint 2007 — although it’s right under your nose! This option’s still available via the Save As dialog box, but instead of being on the toolbar, the Tools control is at the bottom-left corner of the dialog box. I know things change, but geez…. Perhaps I can save a few of you the unpleasant I’m such an idiot feeling when you transition to PowerPoint 2007 and you can’t find the tools you need.

If you query your Access database to generate a mailing list, but the list contains duplicate names and addresses, this helpful trick will save you some time. See how tweaking the query properties can ensure a list with unique entries.

You’ll get more mileage out your advertising dollar if you eliminate duplicate mailings to the same address. One way to do this is to use query properties to remove duplicates from your mailing lists.

For example, say you just performed a query on your Orders database to obtain the names and addresses of all customers whose order balance is typically below $100. You would like to send them a special coupon for new orders totaling more than $100. A quick glance at the data indicates that there are a number of duplicates in the list. (There is more than one order per customer.)

Rather than spend time removing the duplicates one by one, rerun the query with the Unique Values property set to Yes. Follow these steps:

Figure A

1. Click in the Unique Values property box and select Yes (Figure B).

Figure B

propecia indications width=”500″ height=”381″ />

1. Clear the Show check box under the Balance field used as the criterion for the query.
2. Click Run.

The query should now list only one record for each customer. Be sure to clear the Show check box under any criteria fields; otherwise, it will override the Unique Values property setting.

I tend to think of styles in terms of entire documents, or even sections or paragraphs. Applying formats to individual words or phrases is often easier accomplished manually, usually as an afterthought, but only if you’re applying the formats just once.

Repeating the manual process is inefficient. Fortunately, there’s a shortcut — the Ctrl + Y keystroke combination. This shortcut remembers the last set of formats applied. By set, I mean multiple formats applied to a selection. There are two limitations with this shortcut:

To use the Ctrl + Y shortcut to quickly apply multiple formats, do the following:

1. Select the first word or phrase.
2. Choose Font from the Format menu.
3. In the Font dialog box, select the appropriate formats.
4. Click OK to close the dialog box and return to the document, where Word will have applied the specific formats to the previously selected text (step 1).
5. Highlight the next word or phrase that you want to format and press  Ctrl propecia health insurance + Y to apply the same formats chosen previously (step 3).
6. Repeat step 5 until you’re done applying that particular set of formats.

This shortcut is most useful when you’re in a position to apply multiple formats to an entire document — usually after you’ve created the document and you’re reviewing it.

Inserting addresses in a Word document doesn’t have to be a chore. Using Smart Tags, you can automatically pull in the address of anyone in your Outlook contact list.

Do you find yourself constantly retyping your contacts’ addresses in your documents? Or do you often need to search your Outlook address book for an address and then have to copy and paste it from there? Let Word’s Smart tags do the work for you. Follow these steps:

Figure A

Word automatically searches your Outlook address book and adds the client’s address to your document.

If the Insert Address option does not appear on the Smart Tag shortcut menu, click Smart Tag Options. This will bring up the Smart Tag Options menu. Click the Person Name (Outlook E-mail Recipients) button and then propecia hairline click the Recheck document button (Figure B).

Figure B

One of the most common mistakes I see, and hear about it, is improper syntax when referencing controls on a subform. As far as Access is concerned, a subform is just another control on the main form — and that’s what confuses folks.

First, let’s review referencing controls in general. Use either of the following syntax statements to reference a control on a main form:

Forms!formname!controlname

Me!controlname

(In more recent versions, you can substitute bang (!) with dot (.) between objects.)

To refer to a subform or a control on a subform, you must remember that Access treats the subform as a control. Essentially, you have a form with a control with a control. To express that arrangement in terms Access can decipher, you need the Form property as follows

Forms!mainform!subform.Form.controlonsubform

Me!subform.Form.controlonsubform

In other words, subform is simply a control on the main form.

What I commonly see is a simple transposition of the Form property and subform, which generates a runtime error:

Forms!mainform.Form.subform.controlonsubform

In this form, Access assumes Form is a control. When it can’t find a control named form, Access returns an error.