Access Tips CCC

Access Tricks & Tips
These files provide solutions to common Access issues. They are available in Access Version 97 and 2003. They are free, and there are no restrictions on their use. If you find these files helpful, take a moment to let me know. Thanks...

Record Statistics (Forms)
Displays useful information about the record being viewed.

DOC - Date of Creation.
DOLE - Date of Last Edit.
Recordset Information...
- The number of the current record.
- Number of records in the current recordset.
- Number of records in the entire recordset.
Filter Status/Filter Removal

Download: RecordStatisticsV97.zip or RecordStatisticsV2003.zip

ShortCut Keys (General)
A complete indexed and categorized listing of alll Access Shortcut keys.
Download: AccessShortCutKeysV97.zip

Synched Combo Boxes (Forms)
How to use the value of one combobox to limit the choices available in another combobox.
Download: SynchedCombosV97.zip or SynchedCombosV2003.zip

Parameter Report (Reports)
How to use a Parameter Query to limit the records returned by a Report.
Download: ParameterReportV97.zip or ParameterReportV2003.zip

Not In List Combobox (Forms)
How to use the Not In List event too Add a New Selection to a Combobox when Limit to List = Yes.
Download: NotInListComboV97.zip or NotInListComboV2003.zip

Combo Quick Find (Forms)
How to use a Combo box to "Quick Find" a Record in a Recordset.
Download: ComboQuickFindV97.zip or ComboQuickFindV2003.zip

Conditional Formatting On Reports (Reports)
How to Conditionally Format Control Appearance and Values on Reports.
Download: CondFormatInReportsV97.zip or CondFormatInReportsV2003.zip

Combo Populates Multiple Fields (Forms)
Using a Combobox to populate multiple informational display fields on a form. The combo allows users to select a Customer Name, displays that Customer Name, but stores the relevant key field CustomerID.
Various multiple fields on the form automatically display ancillary Customer information such as Address, City, State, Zip, and Phone.
Download: ComboPopulatesMultipleFieldsV97.zip or ComboPopulatesMultipleFieldsV2003.zip

Alternately Shaded Rows (Reports)
Lightly shades every other line on a report to provide visual separation on large or landscaped reports.
Download: AlternateShadingV97.zip or AlternateShadingV2003.zip

Fix for Blank Linked Table Manger (Access 2003) (Updated 11/7/06)
How to fix the Linked Table Manager "Blank" File List Problem.
(Word97-2003 file)
Download: A2003LinkMgrFix.zip

Multiple Duplicate Labels
Print any Quantity of Copies of the same Label.
Download: MultipleDuplicateLabelsV97.zip or MultipleDuplicateLabelsV2003.zip

Calculate Number of Workdays (Updated 3/15/08)
Calculate the number of workdays between two dates.
Download: CalculateWorkdaysV97.zip or CalculateWorkdaysV2003.zip

"(Continued)" Report Group Headers (Updated 6/6/08)
Display "(Continued)" with a Report Group Header when that group's Detail Records span multiple pages.
Download: ReportHeaderContinuedV97.zip or ReportHeaderContinuedV2003.zip

Custom Tool Tips (Updated 6/6/08)
Using the Mouse Move event to display/hide a Custom Tool Tip.
Download: CustomToolTipsV97.zip or CustomToolTipsV2003.zip