April 9, 2008

Use hyperlinks to open an Access database object without programming

Date: April 8th, 2008

Author: Mary Ann Richardson

Rather than add a command button to your form to open another object in your database, you can use a hyperlink. Using images, labels and command buttons as hyperlinks is an easy way to add a control that allows users to open and display an object without programming.

To create a hyperlink that opens the Product Categories List table from an unbound form in your database, follow these steps:

  1. Open a blank form in Design view.
  2. Place a Label control on the form.
  3. Type Click to display the Product Categories List to change the label’s caption, then press Enter.
  4. Right-click Label and select Properties.
  5. Click order online viagra in the Hyperlink SubAddress property in the Label property sheet.
  6. Click the Build button.
  7. Click the Object In This Database button.
  8. Click Tables.
  9. Click the Products Categories List, then click OK.

Note that instead of a label, you could also use a command button or image; just change its SubAddress property to the object’s address.

Unlike command buttons, hyperlinks only allow you to open an object and move to a location within it. Any programming is limited to the control’s on-click event.

Permalink • Print • Comment

Use Excel’s conditional formatting to mark values that meet your target goals

Date: April 8th, 2008

Author: Mary Ann Richardson

Excel 2007’s data visualization feature automatically gives every cell in a range a color, icon, or data bar according to its value. If you are analyzing a small number of values, this makes it easy to see which ones met your target goals. But what if you are examining a list with 100 rows of data? In this case, you will want to use Excel’s conditional formatting feature to build rules for marking only the cells outside your target range of values.

For example, say you want to mark only those cells that have a value greater than 100 with an X. Follow these steps:

  1. Select the range of data.
  2. On the Home tab, in the Styles group, click Conditional Formatting, then click Icon Sets.
  3. Click 3 Symbols (Uncircled).
  4. Click Conditional Formatting, then click Highlight Cell Rules | Less Than.
  5. In the Less Than dialog, enter 100.
  6. Click the arrow in the With drop-down box and select Custom Format, then click OK twice.
  7. Click Conditional Formatting, then click Manage Rules.
  8. Click the Stop If True check order generic viagra box for the rule Cell Value < 100.
  9. Click the Icon Set rule, then click the Edit Rule button.
  10. In the Edit Formatting Rule dialog, click the Reverse Icon Order check box at the bottom of the dialog window.
  11. Click the >= drop-down arrow of the first Value list and select >.
  12. Click the Type drop-down arrow of the first Value list and select Number.
  13. Click in the first Value text box and enter 100.
  14. Click the Type drop-down arrow of the second Value list and select Number.
  15. Click OK twice.

Now, an orange X denotes all values above 100. An exclamation point denotes values equal to 100, and values below 100 remain unformatted.

Permalink • Print • Comment

Move your Outlook data file to another location

Applies to

Microsoft Office Outlook® 2003
Microsoft Outlook® 2000 and 2002

If you use a Microsoft Exchange Server e-mail account, typically your e-mail messages, calendar, contacts, and other items are delivered to and stored in your mailbox on the server. When you install Outlook on a new computer and select an Exchange Server e-mail account in the E-mail Account Wizard, all your items on the server are again available to you. The remaining information in this article does not apply to you, unless you created archive or local data files or specified that your Exchange messages be delivered to a local data file.

If you use a POP3 (POP3: A common protocol that is used to retrieve e-mail messages from an Internet e-mail server.) e-mail account, which is one of the more common types of personal e-mail accounts, your e-mail messages are downloaded from your POP3 e-mail server at your Internet service provider (ISP) (ISP: A business that provides access to the Internet for such things as electronic mail, chat rooms, or use of the World Wide Web. Some ISPs are multinational, offering access in many locations, while others are limited to a specific region.) to your computer and delivered to and stored locally in a Personal Folders file (.pst) (Personal Folders file (.pst): Data file that stores your messages and other items on your computer. You can assign a .pst file to be the default delivery location for e-mail messages. You can use a .pst to organize and back up items for safekeeping.) named Outlook.pst (the default data file name). Outlook.pst is stored in the <drive>:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Outlook folder.

Note The default location is a hidden folder. To use Windows Explorer to navigate to this folder, you must first turn on the display of hidden folders. In Windows Explorer, on the Tools menu, click Folder Options. On the View tab, under Advanced Settings, under Files and Folders, under Hidden files and folders, click Show hidden files and folders. If you want to see all file name extensions, clear the Hide extensions for known file types check box under Files and Folders. Hidden folders appear dimmed to indicate they are not typical folders.

order cheap viagra align=”justify”>You can move any Outlook .pst file to any location on your computer. For example, some people like to keep their Outlook data files on drive D or under My Documents, so that creating backup files is easier.

Before you start

Before you start, you might want to consider changing the display name of your .pst file from Personal Folders to something more meaningful to you. Changing the name helps you to distinguish different Outlook data files when you work with more than one .pst file.

In the Navigation Pane (Navigation Pane: The column on the left side of the Outlook window that includes panes such as Shortcuts or Mail and the shortcuts or folders within each pane. Click a folder to show the items in the folder.), right-click Personal Folders, and then click Properties for Personal Folders. Note This folder will always be a top-level folder in the Navigation Pane, in Mail.

Click Advanced.

In the Name text box, type a name that is meaningful to you, such as Pat's Mail.

Click OK twice.

Move the .pst file to another location

You are now ready to begin moving Outlook data files.

In Outlook, make a note of the file location and name. How?

In the Navigation Pane, right-click Personal Folders or the name that appears for your .pst file, and then click Properties for folder name. Note This folder will always be a top-level folder in the Navigation Pane, in Mail.

Click Advanced.

In the Filename text box, make a note of the complete path and file name of the .pst file.

Close Outlook.

Move the file. How?

Use Windows Explorer to copy each .pst file from its default location of the <drive>:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Outlook folder to any folder on your computer that you want.

Note The default location is a hidden folder. To use Windows Explorer to navigate to this folder, you must first turn on the display of hidden folders. In Windows Explorer, on the Tools menu, click Folder Options. On the View tab, under Advanced Settings, under Files and Folders, under Hidden files and folders, click Show hidden files and folders. If you want to see all file name extensions, clear the Hide extensions for known file types check box under Files and Folders. Hidden folders appear dimmed to indicate they are not typical folders.

In Control Panel, open Mail. Do one of the following:

Microsoft Windows® XP or Microsoft Windows Server™ 2003

In Control Panel, click User Accounts, and then click Mail. Note If you are using Classic view in Control Panel, double-click Mail.

Microsoft Windows 2000

In Control Panel, double-click Mail.

Click Show Profiles, and then select the profile that contains the .pst file.

Click Properties, and then click Data Files.

Select the data file from the list, and then click Settings.

When an error dialog box appears notifying you that the data file could not be found at the old location, click OK.

Browse to the new folder location, select the data file, and then click Open.

Click OK, and then click Close twice.

Click OK.

Restart Outlook.

Work with multiple data files in one profile

If you have multiple .pst files in your Outlook profile, make sure that your default delivery location is still correct after you complete the preceding steps. The default delivery location is the data file where new messages will appear in the Inbox.

On the Tools menu, click E-mail Accounts.

Click View or change existing e-mail accounts, and then click Next.

In the Deliver new e-mail to the following location list, make sure that the correct data file is selected.

If you need to change the selection, make sure to click Finish, and then quit and restart Outlook for the changes to take effect.

Permalink • Print • Comment

Outlook Data Files Locations

Note: It is important to back up e-mail files on a regular basis. Here is some backup information that may be helpful to you.

Viewing hidden files and folders:

Microsoft Outlook provides a Personal Folders Backup download. It backs up Outlook 2003 .pst files, which store everything for Outlook.

Microsoft Outlook 2003 may contain the following data store and configuration files that need to be backed up. Some of these files might be hidden folders.

To view hidden files and folders:

Click Start, and then click My Computer.

From the Tools menu, click Folder Options, click the View tab, and then click the Show hidden files and folder option.

For Windows 2000/XP:

Double-click My Computer on your desktop.

From the Tools menu, click Folder Options, click the View tab, and then click the Show hidden files and folder option.

Note: Your Outlook configuration may not include all of the following files. Some files are created only when you customize Outlook features.

File

Drive

Outlook data files (.pst)

drive:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Outlook

Offline Folders file (.ost)

drive:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Outlook

Personal Address Book (.pab)

drive:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Outlook

Offline Address Books (.oab)

drive:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Outlook

Command bar and menu

customizations (.dat)

drive:\Documents and Settings\<user>\Application Data\Microsoft\Outlook

Navigation Pane settings (.xml)

This file includes Shortcuts,

Calendar, and Contact links.

drive:\Documents and Settings\<user>\Application Data\Microsoft\Outlook\Outlook.xml

Registered Microsoft Exchange

extensions (.dat)

drive:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Outlook

Outlook contacts nicknames (.nk2)

drive:\Documents and Settings\<user>\Application Data\Microsoft\Outlook

Rules (.rwz)

drive:\Documents and Settings\<user>\Application Data\Microsoft\Outlook

Note: If you upgraded from a version of Outlook prior to Outlook 2002, you may have a .rwz file on your computer hard disk drive. The file is no longer needed and the rules information is now kept on the server for Microsoft Exchange e-mail accounts, and within the personal folders file (.pst) for POP3 and IMAP e-mail accounts. You can delete the file.

If you use the rules import or export feature, the default location for .rwz files is:

drive:\Documents and Settings\<user>\My Documents.

Print styles (Outlprnt with no extension)

drive:\Documents and Settings\<user>\Application Data\Microsoft\Outlook

Signatures (.rtf, .txt, .htm)

drive:\Documents and Settings\<user>\Application Data\Microsoft\Signatures

Stationary (.htm)

drive:\Documents and Settings\<user>\Application Data\Microsoft\Stationary

Custom forms

drive:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Forms

Dictionary (.dic)

drive:\Documents and Settings\<user>\Application Data\Microsoft\Proof

Templates (.oft)

drive:\Documents and Settings\<user>\Application Data\Microsoft\Templates

Send/Receive settings (.srs)

drive:\Documents and Settings\<user>\Application Data\Microsoft\Outlook

Message (.msg, .htm, .rtf)

drive:\Documents and Settings\<user>\My Doc

Permalink • Print • Comment

April 8, 2008

Digital Photography Times Two

It's your lucky day! I have two brand new digital photography tips for you today and I think you're really going to enjoy them. The two topics really have nothing to do with each other, but I figured they were both something you all might be interested in. Let's take a look!

Tip #1 – Photographing Your Pets

People love to take pictures of their pets, but this is how the photos usually turn out:

As you can see, that picture definitely requires a lot of help. Luckily, if you just follow the simple tips below, you can fix up your pet photos in no time at all!

Get Down and Dirty – You usually see your pet from above, but that's not the best angle for a portrait. Instead, flop down on the floor and meet them at eye level. Shooting from their height presents them as an equal in the photo, which will help bring out their personality.

Light it Right – Direct on-camera flash will give your pet a killer case of green, yellow or blue eyes. Try to avoid any direct flash if possible. If you can, bounce the flash off the ceiling or a wall. Or, you can just ditch the flash and use the light around you, both indoors and out.

Fill the Frame – I'm sure you've heard of this one before. It's important to fill your camera's frame with your subject in order to make the subject prominent in the photo. You can then crop out any distractions later on.

It's All in the Eyes – You might find yourself shooting with a shallow depth of field, so no matter what else you do, make sure your pet's eyes are in focus. The eyes are the window to the soul and they must be kept clear.

Ahh, that's a much better picture, don't you think?!

Tip #2 – Shooting Water

When drinking, some like their water icy, while others like it tepid. It's simply a matter of taste. In photography, moving water can be recorded with various appearances, depending on the shutter speed. Some like it frozen in an instant of time and some like it blurred with a long exposure. There's no right or wrong. How you like to photograph water is also just a matter of taste. Here are three other approaches you may like as well.

Glass Sculpture – Fast shutter speeds like 1/500" or 1/1000" will depict moving water as frozen solid. Splashes and droplets will hang suspended in online viagra australia the air.

Minor Blur – Intermediate shutter speeds like 1/15" or 1/30" give some motion blur to the water, but individual ripples and splashes are still discernible. You'll probably need a tripod or other camera support when using such slow shutter speeds.

Silky Smooth – Shutter speeds of 1/2" or longer will smear the water out to a smooth, cottony, smoky look. You'll definitely need a tripod to achieve this look when photographing water.

Now, go on and take some great shots of your pets and of water. Or, your pets in water. You decide. Have fun!

Permalink • Print • Comment
« Previous PageNext Page »
Made with WordPress and an easy to customize WordPress theme • Sky Gold skin by Denis de Bernardy