Report works on one computer and not other

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a report that displays a total from the report footer of a subreport.
It works great on three computers. On a fourth computer, however, it
displays on #Error. I have tried changing the macro security settings with
no success. The computer that doesn't work has Access 2003 w/ SP2 while the
others have Access 2003 w/ SP1. Any suggestions or work arounds?
Thanks!
Melinda
 
Melinda

There's a chance that that 'other' computer has lost a connection to some of
its references.

Check the following:

* Open a code module
* Click Tools | References
* Check for any that are checked, but prefixed with MISSING.
* If you find any like that, note which one(s), uncheck them, and close
the window.
* Re-open the window (Tools | References)
* Re-check the one(s) you unchecked.
* Close the window
* Click Debug | Compile .... (the first item on the drop-down menu)

Does it work now?
 
Hi Jeff,
I tried your advise, but unfortunately, there were no missing references.
Just in case, I noted all of the checked references, unchecked the ones I
could, closed and rechecked them. Nothing. I compared the "other" computer
to my own and they have the same references checked. This is getting to be
quite odd.
Any other ideas out there?
Thanks,
Melinda
 
OK, have a solution. I changed my field from =[TimeSub].[form]![Wed] to
=[TimeSub]![Wed]. This works on both computers. Now if only I could figure
out why the original formula didn't work on the "other" computer. Oh, well.
 
Back
Top