Welcome to Doctor Access files 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® 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 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 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 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. |