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.

When entering formulas, you select a cell and start typing. To edit an existing formula, you probably make changes in the Formula bar. Recently, I noticed several Excel students reaching for the mouse and clicking the Formula bar to edit formulas. That method’s Okay, but some people find it easier to work from the keyboard as much as possible. If that describes you, press [F2] instead of reaching for the mouse the next time you want to edit an existing formula.To me, it hardly seemed worth mentioning. Admittedly, substituting a single keystroke for a mouse click doesn’t seem like a big deal, unless you prefer the keyboard (at least most of the time). The keyboard approach isn’t more efficient, it’s just different.

If pressing [F2] positions the cursor in the cell instead of the Formula bar, do the following:

propecia generic

If you’re using Excel 2007, do the following:

1. Click the Office button and then click Excel Options (at the bottom right).
2. Select Advanced in the left pane.
3. Uncheck the Allow Editing Directly In Cell option.
4. Click OK.