Enter your email address:

Delivered by FeedBurner


Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Friday, August 28, 2009 – Permalink –

Parameter v. Form

You have a choice



There are a couple of ways to limit the data that is displayed in a Query or in a report.
One is a Parameter Query
  1. Create a query to use as the RecordSource of your report.
  2. In query design view, in the Criteria row under your date field, enter:

    Between [StartDate] And [EndDate]
The other is to create a specific form. The unbound form has the following advantages:
  • Flexible: user does not have to limit report to from and to dates.
  • Better interface: allows defaults and other mechanisms for choosing dates.
  • Validation: can verify the date entries.
Allen Browne has supplied a clear explanation along with some typical code.

Also see FontStuff.com:
Using Parameter Queries




See all Topics

Labels: , , ,


<Doug Klippert@ 3:02 AM

Comments: Post a Comment

  Saturday, August 22, 2009 – Permalink –

Self Help

Get started in the right direction


The Office of Technology Services of Towson University, located in Towson, Md., provides Self-Help Training Documents for many applications.

They are available for many levels of knowledge. They’re clean, clear, and concise.
  • Access

  • Adobe Acrobat

  • Dreamweaver

  • Excel

  • FrontPage

  • Microsoft Office Tools

  • Outlook

  • Outlook Web Access

  • PowerPoint

  • Publisher

  • Visio

  • Windows

  • Word Art

  • Word
Tech Docs




See all Topics

Labels:


<Doug Klippert@ 7:28 AM

Comments: Post a Comment

  Sunday, August 16, 2009 – Permalink –

Change Keyboard Navigation

It's your choice


You, probably. take for granted how your direction arrow and Enter keys behave in Access.

When you press Enter the focus moves to the next field and the contents of the field are selected. Likewise, when you press the direction arrow keys, the focus moves to the next field in the appropriate direction. You aren't locked into these behaviors.

If you'd like, you can set up the arrow keys to move from one character to the next in the current field, rather than moving focus to the next field.

You can also configure the Enter key to move to the next record when it's pressed or configure it to do nothing at all.

When you do move focus to another field, you have the option to place the insertion point at the beginning or end of the field, rather than selecting the field's entire contents.

To modify these settings, choose Tools>Options from the menu bar and click on the Keyboard tab. Then, simply make the selections you want and click OK.



In 2007 it's under Access Options>Advanced when you click the Logo in the upper left corner.






See all Topics

Labels: , ,


<Doug Klippert@ 6:55 AM

Comments: Post a Comment

  Monday, August 10, 2009 – Permalink –

Military Clipart

Thousands of items


If you find the need for Armed Forces photos and art, here is the place to look.
Regardless of your opinion about their present mission, the military does present a spectacular visage.



"06/17/06 - An F/A-18E Super Hornet aircraft sits at the ready as storm clouds pass overhead aboard the Nimitz-class aircraft carrier USS Ronald Reagan (CVN 76) in the Philippine Sea June 17, 2006.
(U.S. Navy photo by Photographer's Mate 2nd Class Aaron Burden)

All of these files are in the public domain unless otherwise indicated. However, we request you credit the photographer/videographer as indicated or simply "Department of Defense."


HqDA.Army.Mil - Clipart




See all Topics

Labels:


<Doug Klippert@ 3:01 AM

Comments: Post a Comment

  Saturday, August 08, 2009 – Permalink –

Reduce Entry Mistakes

Disable AutoExpand


When you type an entry in a combobox control Access will typically attempt to complete the entry based on the control's lookup list.

This is controlled by the AutoExpand property, which is set to Yes (-1) by default.

Although such behavior is helpful, it can cause problems if your value list contains several items that are close in spelling, since it's easy for users to accidentally let Access choose the wrong item.

You can avoid errors by setting the control's AutoExpand property to No (0) in Design view or using VBA to set the property equal to 0.

Once you've made the change users are forced to type the entire entry or select an item using the combobox control's dropdown list.

(Works the same in Access 2007)






See all Topics

Labels: , ,


<Doug Klippert@ 3:06 AM

Comments: Post a Comment

  Saturday, August 01, 2009 – Permalink –

Data Security

Access style


With all the news about database spying, here's some information about protecting your own Access db.
Don't tell the New York Times.

This is Margaret Blauvelt's TOC from Mendoclick.com:
  • General Protection from Unauthorized Users
  • Protect your Logon Identity
  • How to Change your Password in Access
  • User Logon, Security and Data Integrity
  • The Access Workgroup Security File
  • Object Permissions and User Logon
  • Access Sessions and the Workgroup File
  • Joining to another Workgroup Security File from within Access
  • Opening a Database from the Command Line
  • Opening a Database from a Shortcut
  • Backup
  • Compact and Repair
Mendoclick.com
Access Security for End Users

Support.microsoft.com:
Frequently asked questions about Access security warnings

For Access 2007:
Data Security in Microsoft Access 2007




See all Topics

Labels: ,


<Doug Klippert@ 3:11 AM

Comments: Post a Comment