Home

Doctor Access is a specialist in:
	l Microsoft^® Access^® Support
	l Application Development
	l Database Design Development
	l VBA Programming
	l One-on-one, On-Line Access^® Training

"Doctor Access" can diagnose, and provide relief from PADS (Personal Access Deficiency Syndrome)!

Welcome to the Doctor's file download page ...

Below you will find a few of my custom/demo databases. I have developed these databases to assist others in utilizing some of the features of Access which they have expressed an interest in. All of the downloadable files here are in Access 2002 format. I have converted all of my old Access 97 stuff to 2002. You can try to convert these files back to 97 if you need them in that format.

Keyboard, Key Pad and Calculator Demo (designed for touch screen monitor)

KeyboardNumberPadAndCalculator.zip

The forms (the Keyboard, the Key Pad and the Calculator) in this database file were designed for use with a touch screen monitor and therefore have a larger that usual appearance. If you want to use these forms with a standard screen and application, you could change the size of all of the controls and the form to suit your needs.

Just follow the prompts on the initial form to see how I have designed these special forms to work in an application.

KeyPad Only Demo

KeyPadDemo.zip

This download contains the same KeyPad form as is found in the Keybaord, KeyPad and Calculator download. However, this is a smaller download and it only has the demo of the KeyPad in it. Just thought someone might need just this one demo.

Cue Prompting Demo

CuePromptingDemo.zip

This demo is my modified version of MVP, Doug Steele's Cue Prompting download.

In Doug's version, when the cursor enters any text box where Cue Prompting is being used, the prompt disappears. In this version, the prompt will remain displayed in the filed, even when the cursor is placed in the field, until the user starts to type another value.

Also, in Doug's version, the value that you want displayed in the text box control is held in the code. and is written to the "Tag" property of the control during the use of the Cue Prompting. In this version, you simply enter the value you want displayed in the text box control in the "Tag" property of that control. The "Cue Promptiing" module will pickup this value and use it as the prompt.

I have also added one more feature. If you have specific fields that are "required" for data entry, you could really use some way to notify your users that certain fields are required. If you use the word "required" in the "Cue Prompt" text that you place in the "Tag" property of the text box control, the "Cue Prompt" will be displayed slightly darker in that field. You could actually use or specify an entirely different color for that field's prompt if you really wanted to.

While it does take a little work to implement the "Cue Prompting" feature, in some cases where users need special notifications, it can prove to be quite helpful.

Moving Between Text Boxes like in Excel

ExcelTypeMovement.zip

This example database file demonstrates how to have multiple text boxes on a form and have users be able to move between the text boxes using the arrow keys just like being in and Excel spreadsheet.

There are two types of movements created. I have two forms that demo each type. In one the text boxes are numbered from left to right (across) and in the other the text boxes are numbered from top to bottom (vertically). The code is a little different based on the type of numbering that is used.

There is also a form with information like a "How to" for creating this type of movement.

Cities and Zip Codes

Cities and Zip Codes. Zip

This is a one table database that contains just over 15,000 zip codes and the cities that are associated with them. This list is not totally complete, but is a good starting point.

Demo Cascading Combo Boxes

DemoCascadeComboBoxes.zip

This is a one table database that contains Customer Names and Job Names. This demonstrates the use of cascading combo boxes where the second combo box is filtered by a selection made from the first combo box.

Demo Cascading Combo Boxes Plus Adding Personalized and Dated Notes

DemoAddingMultipleDatedNotes.zip

This is a one table database that contains Customer Names and Job Names. This demonstrates the use of cascading combo boxes where the second combo box is filtered by a selection made from the first combo box. This version also demonstrates the ability of using a Popup form to add multiple Notes to the selected record. Each note is personalized with the current user's name and the Date and time when the record was created. In this version, no provision has been made for editing existing note records.

Demo Find and Filter Using Combo Boxes

DemoFindAndFilterUsingComboBoxes.zip

This is a one table database that contains Customer Names. This demonstrates the use of multiple combo boxes to either Find a specific customer record or to filter the form for a specific value selected from a combo box. A command button to clear filters and or selections in the combo boxes is also included along with a label that describes each filter as the filter is applied.

Demo of Conditional Formatting Usage Issue

ConditionalFormatIssueTesting.zip (Access 2007 format)

This is an Access 2007, one table database that contains Client Names. This demo shows the use of Conditional formatting. The issue with Conditional Formatting is that if you want users to be unable to even select the value in a specific field you can set the Locked property of the control to No and the Enabled property to No. With these settings, the control will appear grayed out but also will not allow users to select the value in the control. JamesJ recently posted a question on the Microsoft Newsgroups because he had found that if you used Conditional Formatting on the control where you wanted to restrict the user from selected a value, when the condition was met the value was again selectable and that the other changes defined in the Conditional Formatting did not take place. After testing this issue, I found that if you have the Conditional Formatting criteria to again set the Enable property to No as the first criteria, then set a color change or other formatting change, then the field would remain in a non-selectable mode and the other change would also be applied. The Enabled property must be the first condition to be met.