Archive for January, 2006

Date Calculations in Access

January 10th, 2006

There are a number of ways to calculate the time between two dates in Access. You can use a calculated field in a query, a calculated control in a form or report, or you can use a VBA procedure to perform the calculation.
If you need to calculate the number of days between two dates, […]

Keyboard Shortcuts in Access

January 10th, 2006

Here are some useful shortcuts for Microsoft Access:

Undo typing: CTRL+Z or ALT+BACKSPACE
Undo changes: Press ESC once for current field, ESC twice for current record
Insert the current date: CTRL+SEMICOLON (;)
Insert the current time: CTRL+COLON (:)
Insert the default value for a field: CTRL+ALT+SPACEBAR
Insert the value from the […]

Save Searches in Outlook

January 9th, 2006

If you find yourself repeating the same searches in Outlook, you can create a custom search, save it, and execute it again by simply re-opening the saved search.
Here’s how:

Open the Advanced Find dialog box (Control+Shift+F, or click the Find button, then selection Advanced Find… from the Options menu.)
Enter your search options (for example, all […]

Speed Up E-mail in Outlook

January 9th, 2006

If you find that it takes too long to switch from one email message to another, try turning off the Outlook “feature” that displays a Name Smart Tag in the message header and checks the user’s Instant (Windows) Messenger status.
To do so:

Select Tools | Options.
Click the Other tab.
Remove the check from Enable the Person Names […]