October 7, 2004: Fix for RFil and FFil in Access 2003.
A number of users reported problems in the value dropdown lists in RFil 5 and
FFil 2 in Access 2003. When clicking on the dropdown to show values to choose
from, Access would return an error:
"There was an error in the ..FillPicklist function: There is an invalid use of
the . (dot) or ! operator or invalid parentheses."
There was some change in Access 2003 that now causes this error to occur.
To manually fix this bug:
Open the frmCustom form in design mode. Locate the bottom row with small hidden
red-text boxes. For the right-most control, called "CurrentPage", change its
ControlSource property to:
=Chr(MainTabControl.Value + 65)
Access may add extra brackets, and that is ok. Save the change to the form. The
value dropdown list will now function normally.
The original property setting of
"=MainTabControl.Pages(MainTabControl.Value).[Name]" would return the correct
A,B,C, or D for the current selected tab in versions of Access before 2003. The
new setting will be more reliable.
Email me if you have any questions (my email address is at the bottom of this
page)
July 12, 2003: Bug with RFil 5 in Access 2000.
A user reported a compile problem with RFil 5.025 in Access 2000. A fix for
this is the following:
In the main module, search for "Reports(strReportName)", or look in two places:
rf5SetupReportInfo and rf5SetupGetRS
Add "Application." in front of the word Reports, to make it:
Application.Reports(strReportName)
For an unknown reason, some recent change in Access, Office, MDAC, DAO, or who
knows what else MAY have altered how the Reports collection can be referenced.
The current downloadable version of RFil 5.025 DOES NOT have this fix, because
I'm not convinced the fix will work for a user with the old setup or service
packs. Email me if you have any questions (my email address is at the bottom of
this page)
Update October 21, 2002: Fix to RFil 5 and FFil 2
There is a new fix for a bug in RFil 5 and FFil 2 (for Access 2000/XP, not 97).
When you filter by a numeric field, then change the same row to filter by a
text field, you receive an error about invalid formats and cannot run the
filter. This fix is a simple form you import into your application, click a
button, and it will fix all of the value dropdowns to correct this bug.
Download fix for this bug (Access
2000/XP, not 97)
See FFil and RFil pages to download the full fixed version 2.025 and 5.025.
FRC - Fast Record Counter: FRC is a free utility for previewing groupings and counts of data in Access databases. From a simple menu, you can quickly see the count of records in your tables and queries, using different grouping options.
FileCat - Access File Catalog Manager:
FileCat is free Access 97/2000 database for making file catalogs of CD-R, Zip,
or other media. It stores file names, paths, sizes, and more, plus you can
enter in custom file and catalog descriptions to search for later. There are
also options for printing and exporting the information. (This database
requires Microsoft Office as well as Access).
RFil - Access Report Filtering: Version
5.025
RFil is a report filtering utility for Access databases. With RFil, it's easy
to create, run, and manage filters for your reports.
FFil - Access Form Filtering:
Version 2.025
FFil is used to filter forms in your database. There's no easy, built-in way to
create, save, and manage form filters in Access, but FFil gives you a powerful
yet easy-to-use technique.
P-Track Security Permissions Tracker:
P-Track is an Access 97 utility for reviewing and documenting the security
permissions of your application. If you have a large, multi-user database, you
know how difficult it is to manage object permissions. This free utility can
help.
Password Changer:January 10, 2003.
Updated version available (with bug fixes!)
This utility includes two forms that are useful for administrators of secure
Access databases. One lets the administrator set or clear every user's
password. The other is a simple form for the user to change their own password.
SeeLinks - Linked Table Information:
This is another small Access utility with a single purpose - to show all
information on the linked tables in your application. This is especially useful
if you find the Access linked table manager window to be too narrow.
Links to Access Links:
The Access
Web - Resources
American Info
Components
Tony Toews' Access
Site
Winsite
Access Downloads
Trisha the
Access Freak
Trevor's
Access FAQ/Resources
Access Yahoo Webring List
ACG Soft Links
A3 Access
Links
Microsoft's
Support FAQ for Access 2000
