Requery Error

[Leonard Patella]

I have an form that has default view as continuous forms.
There is a command button that requeries the form though a
macro (Requery Action). I have converted this application
to an MDE.

Everything works fine on my pc. The problem is when I
move the application to other pc's and click the button, I
get a pop-up error message "Invalid object or no longer
valid" followed by another pop-up error message, "unknown
function name", then the application crashes.

I cannot understand why it works on some pc's and not
others. All are running Access 2000. The same problem
occurs with the MDB.

Any suggestions?????


..

 

[MacDermott]

Sounds like a References problem.
On one of the machines which has a problem, using the MDB, open a code
window and select Tools - References. Check for items marked MISSING

HTH
- Turtle

 

[Leonard Patella]

There are no references marked missing. This is really
crazy, I cannot repeat the error on my PC and all I am
doing is copying the mdb to a server and pasting it to the
other PC. It seems to only occur with the requery command
whether I do it with vb or a macro.

I have substituted the refresh command, but that does not
provide the same results.

 

[MacDermott]

On the machine which errors, make a list of all the references.
Then delete as many as you can (some won't delete).
Save the file.
Then restore the references, in their original order.
See if that helps.

- Turtle

 

[Leonard Patella]

Hi Turtle:

I tried what you suggested but I had no success. Same
error. The only thing different that I see between the PC
without errors and the PC with errors is that the one
without errors has Service Pack 5 installed and those with
errors have Service Pack 7 installed. Both are Access
2000.

Lenny

 

[MacDermott]

Well, possibly it's not references...

One of the problems with using macros is that they're awfully hard to debug.
You might try converting your macro to code.

HTH
- Turtle