Rick Fisher Consulting - Support home
Note: Versions 2.07h and later are year 2000 compliant.
Known bugs in version 2.07n
Currently, there are no known bugs in this version.
Other Problems
- Out of memory while searching forms or reports. This is
an Access resource problem. Only load the add-ins you
absolutely need. Also, you can try to limit the search to
a range of forms/reports via the search documents like
box (e.g. enter "frm[A-D]*" to search forms
starting with frmA through forms starting with frmD). If
you have a database with this problem and can ship it to
me (on a ZIP disk or whatever) I would appreciate it. I
have a workaround I would like to test.
Frequently Asked Questions
- Q: How do I ...
A: See the help file (Replace2.hlp). Most features and
many issues are covered here.
- Q: I have a table in which I store form names and other
object names. Can Find and Replace also search the
contents of this table?
A: Yes (registered version only). See the help file under
"Custom Properties".
- Q: I have a table with existing field names and what I
want to change them to. Can I get Find and Replace to get
the Find/Replace Specs from this table rather than
manually entering them?
A: Yes (registered version only). See the help file under
"Sourcing Find/Replace Specs from a Table or
Query"
- Q: Sometimes when I select "Replace Without
Asking" it still prompts me if I want to do the
change in modules.
A: This is discussed in the Notes section in the help
file.
- Q: Instead of the regular log report I would like a
report that looked more like the cross-reference report.
How about it?
A: After any search with logging enabled, you can go to
the cross-reference form, and click on the
"Report" button (don't click on the
"Generate" button). This will give you a
report, in the cross-reference style, of the last search
you did.
Note: Versions 7.00e and later are year 2000
compliant.
Current known problems in version 7.00f
- Using Windows NT 3.51, module replaces can lock up.
Status: If this happens make the following entry in your
repl7.ini file:
[SendKeys]
CloseWindow=^{F4}
However, if you redefine the control-F4 key via autokeys
this won't work. In that case a more foolproof method is
to use
CloseWindow=%-c
for the English version of windows. For foreign versions
the letter c should be changed to whatever the underlined
character is on the close option of a window (when you
click the control box in the upper left corner).
Frequently Asked Questions
- Q: How do I ...
A: See the help file (Replace7.hlp). Most features and
many issues are covered here.
- Q: Why doesn't my registration code from version 2 work
with this version?
A: You need to upgrade your registration. Details are
provided on the order form. To view the order form,
install Find and Replace 7 per the instructions in the
help file, open the main Find and Replace form (Select
the menu item Tools, then Add-ins, then Find and
Replace), click on the about button in the upper left
corner, and then click on order form.
- Q: I used the add-in manager to add Find and Replace but
when I try to start it Access says it can't be found.
A: This problem seems to happen on some installations
where Access is installed on a network drive.
Run the registry editor, regedit.
Go to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Access\7.0\Menu
Add-Ins\&Find and Replace
There should be two entries in that branch:
Expression, with a value (string) of
"=StartFindAndReplace()"
Library, with a value (string) of
"C:\MSOFFICE\ACCESS\replace7.mda"
where C:\MSOFFICE\ACCESS is where Access 7 is installed
(this might be different on your machine).
Replace7.mda and replace7.hlp must be in that directory.
If the Library entry is incorrect you can manually
correct it.
If it is incorrect, you'll also have to correct the
entries in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Access\7.0\Wizards\Property
Wizards\Name\FARNameBuilder
The entries should be:
Can Edit, with a value (DWord) of 1
Description, with a value (string) of "Smart Rename
(Find and Replace)"
Function, with a value (string) of
"zFAR_RenameControl"
Library, with a value (string) of
"C:\MSOFFICE\ACCESS\replace7.mda"
where C:\MSOFFICE\ACCESS is where Access 7 is installed
(this might be different on your machine).
Also, check to make sure that the replace7.mda file is
not read only (look at the file properties)
Note: Versions 8.01c and later are year 2000
compliant.
Known bugs in version 8.01q
Currently, there are no known bugs in this version.
Known bugs in version 8.01k
If you receive a message "Find and Replace Debug Warning
#1 zFar_LogWrite" after a search/replace this indicates an
error in logging (happens during a table search when a change is
made to the source table of an attached table). It is a logging
error only. The search and replace is not affected. This has been
corrected in version 8.01m.
Known bugs in version 8.01g
- There is a bug in the Fast-Search caching of Reports such
that the section properties (OnFormat, OnPrint,
OnRetreat, OnTag) of some group headers/footers may not
be cached properly. However, CBF (code behind the section
properties) is properly cached. For example, this means
that with Fast-Search enabled a search of all reports may
miss a Report with a macro specified in the OnFormat
property of a particular Group header. Note: bug
discovered January 5,1999, fixed in version 8.01h.
- A bug was introduced in version 8.01g causing
specifications in the Document Name Like boxes of
Reports, Macros, and modules to not work properly. Note:
bug discovered January 5,1999, fixed in version 8.01h.
- The combo box list for queries shows shadow queries for
form combo/list boxes. These shadow queries are generated
by Access and are not user-modifiable so really don't
belong in this list. I will eliminate these in the
version 8.01h.
Frequently Asked Questions
- Q: How do I ...
A: See the help file (Replace8.hlp). Most features and
many issues are covered here. There is a Frequently Asked
Questions topic which covers a number of questions. Only
things not covered in the help file will be listed on
this web page.
- Q: Does Find and Replace 8 support different language
versions of Access?
A: Yes. It is language independent. However you should be
aware that Access stores some properties internally as
the English equivalent even though you have a foreign
language version. For example the format
"Currency" is stored as "Currency"
even though you have the German version and Access
displays "Währung" in the property sheet; so
you must search for "Currency". This also
applies to the decimal separator (Access stores a
"." even if you have specified a ","
and it displays a ",") and the thousands
separator.
- Q: How much does it cost to upgrade from version 7.0 of
Find and Replace?
A: Version 8.0 is a no charge upgrade. Use your
registration code you received when you registered
version 7.0.
- Q: I used the add-in manager to add Find and Replace but
it didn't work.
A: Add (or edit) the registry entries manually via
regedit.
In the registry branch (create if not there)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Menu
Add-Ins\&Find and Replace
Expression, with a value (string) of
"=zFAR_StartFindAndReplace()"
Library, with a value (string) of
"C:\MSOFFICE\ACCESS\replace8.mde"
where C:\MSOFFICE\ACCESS is where Access 8 is installed
(this might be different on your machine).
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Wizards\Property
Wizards\Name\FARNameBuilder
Can Edit, with a value (DWord) of 1
Description, with a value (string) of "Smart Rename
(Find and Replace)"
Function, with a value (string) of
"zFAR_RenameControl"
Library, with a value (string) of
"C:\MSOFFICE\ACCESS\replace8.mde"
where C:\MSOFFICE\ACCESS is where Access 8 is installed
(this might be different on your machine).
- Q: I followed the instructions above and the add-in still
won't start.
A: Make sure the replace8.mde file does not have the
read-only flag turned on (look at properties). This
usually happens when you copy replace8.mde from a CDROM.
- Q: I am getting an error Error 48 "Error in Loading
DLL". What's wrong?
A: This is usually an Access problem with how dao350.dll
is registered. The Microsoft Knowledge Base article Q177264
describes another problem related to the same thing.
- Q: I am using Windows NT and I have been getting Error
429 "ActiveX Component Can't Create Object"
messages (perhaps also from Excel and Word). It seemed to
happen after installing Find and Replace. What is wrong?
A: See Microsoft Knowledge Base article Q185126
(or Q175512 or Q173430).
- Q: I am searching for a numeric value (for example the
backcolor property of form controls) and Find and Replace
is not finding anything yet I know they are there. What
is the problem?
A: Generally Find and Replace does not search numeric
properties unless you specify them in the Search
User-defined Properties option. See the help file for a
description of this option. Also see the help file topic
"What Find and Replace Searches."
- Q: I am searching for a particular Format property value
and Find and Replace doesn't find anything yet I know it
is there. I am What is going on?
A: If you are using a foreign language version of Access
or you are using a decimal separator that is not
"." or a thousands separator that is not
"," you need to know that Access converts your
format to the U.S. equivalent and stores it this way.
Thus Find and Replace sees the U.S. equivalent. For
example the format "Currency" is stored as
"Currency" even though you have the German
version and Access displays "Währung" in the
property sheet; so you must search for
"Currency". This also applies to the decimal
separator (Access stores a "." even if you have
specified a "," and it displays a
",") and the thousands separator (Access stores
a "," even if you have specified a
"." and it displays a ".").
- Q: I am searching for a particular boolean value (for
example looking for all controls where the visible
property is false) and it is not working.
A: For boolean values you must search for
"True" or "False" not -1 and 0.
However when you set the values you can either specify
True, False, -1, or 0. For foreign language versions of
Access it may not be True or False but the equivalent in
your language (try it and tell me what you find out).
- Q: How do I decompile my mdb? (note: this is an
undocumented Access feature which can solve some gpf/ipf
problems, recover orphaned space, and fix the problem
where an mdb won't stay compiled)
A: To decompile start Access with the /decompile
switch. To do this from windows do a Start,
Run and then where it asks for the name of
the program to run type:
"c:\program files\microsoft
office\office\msaccess.exe" /decompile
Make sure you include the quotes as above. Also
modify the file path if necessary to point to where
msacess.exe is located (if it is different in your
installation). When Access starts select/open the
mdb you want to decompile. (the first
mdb you open after starting Access in this fashion will
get decompiled). Then compact the database
(tools, Database Utilities, Compact and
Repair). Then open up any module and do a menu
Debug, Compile. Then close the module.
Then compact the database again.
Known bugs/problems in version 9.00k
Known bugs/problems in version 9.00j
With Windows Vista, Windows 7, and Windows 2008 Microsoft does not include the
WinHelp32 help program. You must install it yourself to be able to read
the help file. See
http://support.microsoft.com/kb/917607. Also, files downloaded from
the internet will get tagged with an alternate data stream (in the file system;
the Zone.Identifier stream) identifying it as from an external source (and
therefore not trusted). The files you extract (via explorer) from a zip
file from the internet will have this set also. The help file cannot be
opened until you right click the file, select properties and on the General tab
you should click the UNBLOCK button (if the button isn't there it isn't a
problem). This is also the same reason you will get a warning message when
opening the replace9.mde file. If you do the same for this file (UNBLOCK
it) it will eliminate this warning.In Access 2007/2010 the Name builder registry keys do not get properly added. Download the appropriate file below, edit it to change the path to where your replace9.mde file is and rename the
file with a .reg extension. Double click it to install (make sure you turn off UAC if you have WIndows Vista or 7)
Access 2007 reg fix file
Access 2010 reg fix file
Known bugs/problems in version 9.00i
Does not support Access 2007 (please use 9.00j). Install requires
Windows Vista/7 UAC to be turned off.
Known bugs/problems in version 9.00h
Note: This version supports adp style projects and Access 2003
(versions prior to 9.00g did not).
When you start up Find and Replace you get multiple Error 5
messages culminating in a registration message. This occurs only under Windows
98 and is solved by a reboot.
Known bugs/problems in version 9.00g
Note: This version supports adp style projects and Access 2003
(versions prior to 9.00g did not).
A bug in this version prevents macros from being modified (even though the
log says it was successful).
When you start up Find and Replace you get multiple Error
5 messages culminating in a registration message. This
occurs only under Windows 98 and is solved by a reboot.
Known bugs/problems in version 9.00f
Note: This version supports does not support Access 2003 or adps.
When you start up Find and Replace you get multiple Error
5 messages culminating in a registration message. This
occurs only under Windows 98 and is solved by a reboot.
Find and Replace 9.00f (and earlier) does not support adps. There is however a bug that causes the check for adp
files to be bypassed so it doesn't inform you that adps are not supported.
Version 9.00g supports adps and Access 2003.
Known bugs in version 9.00b
If you receive a message "Find and Replace Debug Warning
#1 zFar_LogWrite" after a search/replace this indicates an
error in logging (happens during a table search when a change is
made to the source table of an attached table). It is a logging
error only. The search and replace is not affected.
Frequently Asked Questions
- Q: How do I ...
A: See the help file (Replace9.hlp). Most features and
many issues are covered here. There is a Frequently Asked
Questions topic which covers a number of questions. Only
things not covered in the help file will be listed on
this web page. With Windows Vista, Windows 7, and Windows 2008
Microsoft does not include the WinHelp32 help program. You must
install it yourself to be able to read the help file. See
http://support.microsoft.com/kb/917607
- Q: How do I decompile my mdb? (note: this is an
undocumented Access feature which can solve some gpf/ipf
problems, recover orphaned space, and fix the problem
where an mdb won't stay compiled)
A: To decompile start Access with the /decompile
switch. To do this from windows do a Start,
Run and then where it asks for the name of
the program to run type:
"c:\program files\microsoft
office\office\msaccess.exe" /decompile
Make sure you include the quotes as above. Also
modify the file path if necessary to point to where
msacess.exe is located (if it is different in your
installation). When Access starts select/open the
mdb you want to decompile. (the first
mdb you open after starting Access in this fashion will
get decompiled). Then compact the database
(tools, Database Utilities, Compact and
Repair). Then open up any module and do a menu
Debug, Compile. Then close the module.
Then compact the database again.
- Q: I'm getting an error 5 message upon startup
A: This has only been reported in conjunction with
Windows 98. Rebooting the machine solves it.
- Q: I'm having trouble installing and I'm running Windows Vista.
What's up?
A: Turn off User Account Control to install.