VB version difference

[Guest]

I developed a database in Access 2000 w/SP3 applied. However, when I
installed my latest phone software, it was necessary to update my Outlook to
2002 and my VB to 6.3. Now, the database I developed in this environment
will work fine on my computer but won't work on my client's computer. I'm
assuming that the difference in VB versions is the problem. They also have
Access 2000 w/SP3 applied but are still running VB 6.0. When I try to
preview a report, the system prompts me to enter a value for a variable
called "Replace". Does anyone have any ideas? I've already tried creating a
new database in the client's environment and importing all in. Any help
would be appreciated. Thanks. k

 

[Guest]

I don't really know the answer, but one thing to consider that Replace is the
name of a function. I don't recall if it existed in 6.0 or not. Even if it
did, the difference may be confusing Access. This is one good example of why
using Reddick naming conventions that prevent this sort of thing is always a
good idea.

 

[Douglas J. Steele]

I'm guessing that there's a problem with the References collection, and so
Access is choking on a call to the Replace function.

As usual, my first piece of advice is to 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 doing a Compile All Modules), 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)

 

[Guest]

Thanks so much. I had looked high and low for a reference to the Replace
function within my report and couldn't find one. But after you echoed my
initial response, I went back control by control and looked again and found a
reference to a Replace function. Since I didn't create the report, I'm still
trying to figure out the programmer's intent. I'm sure when I remove the
reference to the function and find a different way to accomplish the goal,
the error will go away. I'm just embarrassed that I missed it the first time
I looked. Thanks again for your time. k