Welcome to Doctor Access files download page ...

Below you will find a few of my custom/demo databases and Code Modules. I have developed these databases to assist others in utilizing some of the features of Access®

Modified version of Stewart McCall's "FTP Client" module. This download is a zip file containing a .cls file that can be imported into your project and used to upload files to an FTP site. To implement this, I suggest that you do an search for "Stewart McCall FTPClient" and follow the instructions.

Manage the Visibility, Enablerd and/or Locked Status of Multiple Controls Using the "Tag" Property

This is a one table database that contains a Contacts table and demonstrates the use of the "Tag" property to provide the ability to manage the properties of multiple controls on multiple forms.

Demo Cascading Combo Boxes Plus Adding Personalized and Dated Notes

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

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 Cascading Combo Boxes

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

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

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

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.

Site Map