Requery Error

  • Thread starter Thread starter Leonard Patella
  • Start date Start date
L

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?????


..
 
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
 
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.
 
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
 
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
 
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
 
Back
Top