June 21, 2008

Make it easy for users to change entries made to Access forms

Date: June 16th, 2008

Author: Mary Ann Richardson

You can make it easier for users to update records by adding an Undo button to a form. The Undo button will allow them to cancel changes made to a record without is generic propecia just as good having to go back and retype or delete entries made to a field. Follow these steps to add an Undo button to a form:

  1. Open the form in Design view.
  2. Right-click any toolbar and click Toolbox. Click to activate the Control Wizards button, if necessary, and then click the Command button tool. (In Word 2007, in the Form Design Tools tab, click to activate the Use Control Wizards button in the Controls group, if necessary, and click the Command button.
  3. Click and drag in the form where you want to locate the command button.
  4. Under Categories, click Record Operations.
  5. Under Actions, click Undo Record.

  1. Click Next.
  2. Click Next.
  3. Enter cmdUndoRecord.
  4. Click Finish.
Permalink • Print • Comment

Use Excel’s Lookup functions to search a database

Date: June 16th, 2008

Author: Mary Ann Richardson

You can use Excel’s Lookup functions to build a worksheet that can be used to search a database table. For example, say you’ve imported the following table from your Access database to Sheet2 of your Excel workbook:

To build a worksheet that can be used to look up an intern’s pay rate by entering the intern’s ID, follow these steps:

  1. Open the workbook, click the Sheet2 tab, and select the range A2:H5.
  2. Click in the Name box, type Interndata, and then press [Enter].
  3. Click on the Sheet1 tab.
  4. Click cell D6 and enter Employee ID.
  5. Click cell D8 and enter Name.
  6. Click cell E8 and enter the following function:

=VLOOKUP(E6,Interndata,3,FALSE)&" "&VLOOKUP(E6,Interndata,2,FALSE)

  1. Click in D10 and enter Pay Rate.
  2. Click in E10 and enter the following function:

=VLOOKUP(E6,Interndata,8,FALSE)

  1. Change the cell format of E6, E8, and E10 to match the data type of the data in the table.
  2. Add a header and formatting as shown here.


how much does propecia cost width=”100%” size=”2″ />

Permalink • Print • Comment

Use Word fields to customize your form letters

Date: June 16th, 2008

Author: Mary Ann Richardson

At the end of the month, you send out a statement for each customer’s account. You would like to send one statement to customers with outstanding balances and a second one to those with a $0 balance. You do not have to create two different mail merge documents. You can use the same mail merge document for both types of customers. Follow these steps:

  1. Open how effective is propecia a blank document.
  2. In Word 2002/2003, right-click any toolbar and select Mail Merge. In Word 2007, click the Mailings tab.
  3. In Word 2002/2003, click the Select Data Source button. In Word 2007, click Select Recipients and then click Use Existing List.
  4. Navigate to the Customer database and click Open.
  5. Select the Customer table and then click OK.
  6. Click in the document. The figure below shows inserted fields after toggling field codes.

  1. Click the Insert Merge Field button.
  2. Select Customer_Number.
  3. Press Enter.
  4. Click the Insert Merge Field button and select Name.
  5. Press Enter.
  6. Click the Insert Merge Field button and select City. Press Enter.
  7. Click the Insert Merge Field button and select State. Press Enter.
  8. Click the Insert Merge Field button and select Zip Code. Press Enter twice.
  9. Type “The balance for the
  10. Click the Insert Merge field button and select Customer_Number.
  11. Type “account is “.
  12. Click the Insert Merge Field button and select Balance.
  13. In Word 2002/2003, click the Insert Word Fields button in the Mail Merge toolbar. In Word 2007, click Rules, then click If …Then…Else.
  14. Enter the fields as shown below and click OK.

  1. Save the Mail Merge Main document as Monthly_statements. (To check your work, select the text in the document, right-click, and select Toggle Field Codes, as we did in the first figure.)

To produce the statements:

  1. Open the Monthly_statements document.
  2. In Word 2002/2003, click the Merge To New Document button on the Mail Merge toolbar. In Word 2007, click Finish And Merge and then select Edit Individual Documents. Click OK.


Permalink • Print • Comment

June 19, 2008

Dreamweaver 8 Keyboard Shortcuts

Quick Keys for Dreamweaver

how does propecia work

Keyboard Shortcut Action
Alt+F File
Open the file menu.
Ctrl+N / Cmd+N New document
Open a new document for editing.
Ctrl+O / Cmd+O Open
Open an existing document for editing.
Ctrl+Shift+O / Cmd+Shift+O Open in Frame
Open an existing document into the selected frame for editing.
Ctrl+W / Cmd+W Close
Close the current document. If it has not been saved, you will be prompted to save.
Ctrl+Shift+W / Cmd+Shift+W Close All
Close every open document. If some have not been saved, you will be prompted to save each one.
Ctrl+S / Cmd+S Save
Save the current document. If it has never been saved, you will be prompted for a file name.
Ctrl+Shift+S / Cmd+Shift+S Save As…
Save the current document with a new file name.
Ctrl+P / Cmd+P Print
Print the HTML for the current document.
F12 View in Browser
View the page in your primary Web browser.
Ctrl+F12 / Cmd+F12 View in Alternate Browser
View the page in your alternate Web browser.
Shift+F8 Check Links
Validate the links in the current document.
Shift+F6 Validate Markup
Validate the HTML in the current document.
Ctrl+Q / Cmd+Q Exit
Quit the program and exit.
Alt+E Edit
Open the edit menu.
Ctrl+Z / Cmd+Z Undo
Undo the last change.
Ctrl+Shift+Z / Cmd+Shift+Z Redo
Redo the last undo.
Ctrl+X / Cmd+X Cut
Cut the selected text and put it on the clipboard.
Ctrl+C / Cmd+C Copy
Copy the selected text and put it on the clipboard.
Ctrl+V / Cmd+V Paste
Paste the text on the clipboard at the cursor location.
Ctrl+Shift+C / Cmd+Shift+C Copy HTML
Copy the selected HTML and put it on the clipboard.
Ctrl+Shift+V / Cmd+Shift+V Paste HTML
Paste the HTML on the clipboard at the cursor location.
Ctrl+A / Cmd+A Select All
Select all the text in the window.
Ctrl+[ / Cmd+[ Select Parent Tag
Select the containing tag.
Ctrl+] / Cmd+] Select Child Tag
Select the contained tag.
Ctrl+F / Cmd+F Find and Replace
Search within the current document for text and replace it with other text if you choose.
Shift+F3 / Cmd+G Find Selection
Search within the current document for the selected text.
F3 Find Next
Go to the next instance of the searched for string.
Ctrl+G / ? Go to
Go to the line number or character position you specify.
Ctrl+Space / Cmd+Space Show Code Hints
Display any information available on the tag at the cursor.
Ctrl+Shift+> / Cmd+Shift+> Indent
Indent the selected line(s) one tab space.
Ctrl+Shift+< / Cmd+Shift+<< Outdent
Outdent the selected line(s) one tab space.
Ctrl+Shift+' / Cmd+Shift+' Balance Braces
Align the braces.
Ctrl+U / Cmd+U Preferences
Change your preferences for Dreamweaver.
Alt+V View
Open the View menu.
Ctrl+` / Cmd+` Switch Views
Switch between code, design, and code & design views.
F5 Refresh Design View
Reload the markup displayed in the design view.
Ctrl+Shift+H / Cmd+Shift+H Head Content
Display the header content while in design view.
F6 Expanded Tables Mode
View tables expanded.
Ctrl+F6 / Cmd+F6 Layout Mode
View tables in layout mode.
Ctrl+Shift+I / Cmd+Shift+I Hide All Visual Aids
Turn off all visual aids.
Ctrl+Alt+R / Cmd+Opt+R Show All Rulers
Display all rulers on the screen.
Ctrl+Alt+G / Cmd+Opt+G Show Grid
Display grid in design view.
Ctrl+Alt+Shift+G / Cmd+Opt+Shift+G Snap to Grid
Snap elements to grid.
Ctrl+Alt+P / Cmd+Opt+P Play Plugin
Play plugin at cursor.
Ctrl+Alt+X / Cmd+Opt+X Stop Plugin
Stop plugin at cursor.
Ctrl+Alt+Shift+P / Cmd+Opt+Shift+P Play All Plugins
Play all plugins.
Ctrl+Alt+Shift+X / Cmd+Opt+Shift+X Stop All Plugins
Stop all plugins.
F4 Hide Panels
Hide all open panels.
Alt+I Insert
Open the insert menu.
Ctrl+E / Cmd+E Insert Tag
Insert markup tag at cursor.
Ctrl+Alt+I / Cmd+Opt+I Insert Image
Insert image at cursor.
Ctrl+Alt+F / Cmd+Opt+F Insert Flash
Insert Flash animation at cursor.
Ctrl+Alt+D / Cmd+Opt+D Insert Shockwave
Insert Shockwave object at cursor.
Ctrl+Alt+T / Cmd+Opt+T Insert Table
Insert table at cursor.
Ctrl+Alt+A / Cmd+Opt+A Insert Named Anchor
Insert named anchor at cursor.
Shift+Return / Shift+Return Insert Line Break
Insert line break (<br />) at cursor.
Ctrl+Shift+Space / Cmd+Shift+Space or Option+Space in Design View Non-breaking space
Insert a non-breaking space (&nbsp;) at cursor.
Ctrl+Alt+V / Cmd+Opt+V Insert Editable Region
Insert editable region for a template at cursor.
Alt+M Modify
Open the modify menu.
Ctrl+J / Cmd+J Page Properties
Modify the properties for the page.
Ctrl+T / Cmd+T Quick Tag Editor
Add a tag quickly in the design view.
Ctrl+L / Cmd+L Make Link
Make the highlighted object a link.
Ctrl+Shift+L / Cmd+Shift+L Remove Link
Remove link from highlighted object.
Ctrl+Shift+1 / Cmd+Shift+1 Align Left
Align object left.
Ctrl+Shift+3 / Cmd+Shift+3 Align Right
Align object right.
Ctrl+Shift+4 / Cmd+Shift+4 Align Top
Align object at top.
Ctrl+Shift+6 / Cmd+Shift+6 Align Bottom
Align object at bottom.
Ctrl+Alt+Shift+T / Cmd+Opt+Shift+T Add Object to Timeline
Add element to timeline.
Alt+T Text
Open text menu.
Shift+F7 Check Spelling
Check spelling in document.
Alt+C Commands
Open commands menu.
Ctrl+Shift+X / Cmd+Shift+X Start Recording
Record all commands.
Alt+S Site
Open the site menu.
Ctrl+Shift+D / Cmd+Shift+D Get
Get all files on remote site and bring them to local drive.
Ctrl+Alt+Shift+D / Cmd+Opt+Shift+D Check Out
Check out all files on remote site and bring them to local drive.
Ctrl+Shift+U / Cmd+Shift+U Put
Put all files on remote site from local drive.
Ctrl+Alt+Shift+U / Cmd+Opt+Shift+U Check In
Check in all files on local drive and put them on remote site.
Ctrl+F8 / Cmd+F8 Check Links Sitewide
Validate all links on the site.
Alt+W Window
Open the window menu.
Ctrl+F2 / Cmd+F2 Insert Menu
Toggle insert window.
Ctrl+F3 / Cmd+F3 Properties Menu
Toggle properties window.
Shift+F11 CSS Styles
Toggle CSS styles window.
F2 Layers Menu
Toggle layers window.
Shift+F4 Behaviors Menu
Toggle behaviors window.
Shift+F9 Snippets Menu
Toggle snippets window.
Shift+F1 Reference Menu
Toggle reference window.
Ctrl+Shift+F10 / Cmd+Shift+F10 Databases Menu
Toggle databases window.
Ctrl+F10 / Cmd+F10 Bindings Menu
Toggle bindings window.
Ctrl+F9 / Cmd+F9 Server Behavior Menu
Toggle server behavior window.
Ctrl+F7 / Cmd+F7 Components Menu
Toggle components window.
F8 Files Menu
Toggle files window.
F11 Assets Menu
Toggle assets window.
F9 Tag Inspector Menu
Toggle tag inspector window.
F7 Results Menu
Toggle results window.
Shift+F10 History Menu
Toggle history window.
Shift+F2 Frames Menu
Toggle frames window.
F10 Code Inspector Menu
Toggle code inspector window.
Alt+F9 Timelines Menu
Toggle timelines window.
Alt+H Help
Open the help menu.
F1 Using Dreamweaver
Help with using Dreamweaver.
Ctrl+F1 / Cmd+F1 Using ColdFusion
Help with using ColdFusion.
Shift+F1 Reference
Reference help for Dreamweaver.
Permalink • Print • Comment

June 17, 2008

Wildlife Photography

As you can probably figure out, photographing the wild comes with many challenges. Yep, capturing wildlife on your camera is a completely different type of photography. It requires tremendous patience, it's a little daring and most of all, you need finely tuned instincts. So, without further ado, below are a few things you can do to get beautiful wildlife photos with ease!

Start Early

Most insects are late risers, which means they can't fly until they're warmed up enough. Because of that, you have the advantage of capturing them in their sleepy state before they fly away. That also means you can get much closer to them to take better photos.

Hide Yourself

It’s best to hide yourself while you wait for your subject to arrive. That way, you won’t disturb its natural habitat just for the sake of photography. It also helps with your own security, especially when you're in the middle of a large national park where potentially dangerous animals live.

Be Stealth

You also need to be very stealth. Move at a slow pace and stay close to the ground. A sudden movement could frighten your subject and you could miss a once in a lifetime shot. Also, make sure you don’t move in too close. You just need to be close enough to fill your frame with the subject. Similarly, when you're done taking your pictures, move back out with the same motions. After all, animals do deserve their privacy and you have no right to alarm them once you're done.

Keep Your Distance

It's agreed that you can get the best detail when your camera is as close to the subject as possible. Yes, that's great, but if you get too close, you're putting your own safety at risk. Wild animals are masters of surprise and you never know what could trigger them to attack. You can still get great photos from a safe distance!

Nesting Principle

If you find a bird nesting in a thick cover, do not try to uncover it! The best thing to do is wait until the bird emerges from the nest. Of course, that demands patience, but you already know that's a requirement of wildlife photography. You can’t make things happen. You just have to wait for them to occur. Wildlife photography gives you the chance to observe and learn. Yes, it may take awhile for you to get the photo you're looking for, but if you're patient and you simply slow down, you'll get what you want.

Rules of Composition

You should also strive for balance in your images. Try to incorporate different elements into your picture that have equal weight. For example, something at the edge of your picture will have more appeal than something in the center. Similarly, an element in the foreground has less weight than one in the background. Elements with higher contrast to their surroundings also have greater attraction. Colors play an important part as well, so while you're composing your image, always make the most of compositional lines. They could be a row of trees, a shoreline or a rocky hillside in the background. Special effects like that can really make a photo.

See Better and Think Faster

Wildlife photography requires you to think on your feet and be far more observant than ever before. Some of the things you need to keep in mind include: the direction of light and its effect on your picture, the colors you can balance in your frame and the textures in the scene that could form your foreground/background or the subject itself. You should also think about the animal's direction in the frame. For example, while most photographers are happy with a bird in the center of the frame, it might be even better to capture the bird leaving the frame so that you can convey dynamism and movement.

Focusing Principles

No wildlife photograph is good if you can't capture the eye of your subject. Therefore, it’s important to do that with precision, care and skill. You should use either the manual or auto focus on the eye and then use the focus lock to recompose your image. If the eye isn’t sharp, your photo will be lifeless. For instance, when a bird is in flight, focus on its head and you'll get one of the best images you've ever taken.

Time of Day

Photographers will tell you it's not wise to go on wildlife shoots in midday when the sun is directly over you. During that time of day, the sun has a nasty habit of forming harsh shadows over your subjects. The best time to go is either early in the morning or past 4 p.m.

Catch the Light

Light is essential in bringing life to your wildlife pictures. If you use flash without forming shadows of your subjects, you are on your way to creating a "catch light" in the final image, which is a localized edge contrast boost that gives a perceived increase in image sharpness. It can also be used to balance the exposure of a back-lit subject.

Watch Your Shadow

It’s very easy to get close to an insect, but you should also bear in mind that your shadow how can i get propecia can easily fall on the subject. If that happens, your picture will look a little odd and you won't be happy with the result.

Eye Level

Wildlife photography is just like taking pictures of people. Therefore, the same principle of shooting at eye level applies here as well. Not only will it connect with the viewer, but the subject will look far more down to earth and less intimidating. Now, go out there and take some wild photos!

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