Enter Parameter Value: problem with Replace on WinXP

[david epsom dot com dot au]

"Replace" is not working in queries or as control source on one computer.
WinXP, Jet 4.0 SP8, Access 2000 SP3. Sandbox mode is turned OFF (2 or 0) in
HKLM, Office 2003 is not installed (No HKCU sandbox key). There has not
previously been a problem on other WinXP computers.

This (upgraded from A97) application actually has a UDF called 'Replace' in
a library MDE, but enabling or disabling that function has no effect.

Any suggestions?

(david)

 

[Douglas J. Steele]

What do you mean by "enabling or disabling that function"? If you have two
functions in the database with the same name, you're going to have problems.
Remove the UDF Replace, or rename it.

If that still doesn't work, check the References.

Open any code module, then select Tools | References from the menu bar.
Examine all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog.

If you really need the reference(s) you just unselected (you can tell by
compiling your application, on the Debug menu), go back in and reselect
them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)