#Error in fields on a form subreport

[Market man]

I have a datasheet subreport that displays sales for every day e.g.
Monday, Tuesday, etc.

A total field displays totals from a SELECT query

e.g. SELECT (Monday+Tuesday+Wednesday) AS Total
Error checking for null and empty and numeric values is performed
already.

This all works fine on the development machine Windows XP Home, Access
2002 - total field displays
correct totals
I copy the .mdb database across to the office machine, Windows 2000
Professional, Access 2002 (exactly same version as the development
machine)

Total field now displays #Error.

It works fine on development machine so it is not an error checking
problem.

#Error also displays on a different subreport using a simple function
like MonthName(Month)

I have checked all references and none are missing. 6 references are
selected on the development machine and EXACTLY the same 6 are
selected on the office machine (have tried deselecting and reselecting
them - problem remains).

What's more, when I close down the form with the #Error field
subreport on and reopen it on the office machine, the #Error sometimes
disappears and the correct total appears, seemingly randomly.

Print preview and printing displays the correct totals with no #Errors
i.e. #Error displays but does not print

Can anyone help?

 

[Bill Taylor]

I have encountered the same mysterious problems and have found that by
reinstalling access on the machine and then rereferenceing the fisrt two
references works for me. You cannot deselect these references as they are
manditory. But what I do is select one at a time and use the browse button
to relocate the reference and it has always corrected the problem. The
Date() function seems to be effected the most for me.
HTH