simple problem but turning my hair grey

[CI-DIRECTOR]

I have just upgraded to Access 2010 bringing my old databases with me.

For the most part they work fine but there is one small basic problem: the date() function doesn't seem to work on any of my reports or invoices anymore. When the report or invoice is run it shows up as #Name?.

Up until now it has not been an issue as everything has been current and I have been able to use the information already in other fields of the database to give a feasible date, but now I have to print statements which show the present date whilst the body of the report may be referring to much older events. I have tried changing every field in my database which mentions date. I have tried deleting the =Date() from reports and re-inserting it using the date and time button at the top of the formatting page on the design window but to no avail.

Please help with what should be a simple problem

 

[RuralGuy]

Is your db in a Trusted Location? Do you have any *bogus* MISSING References?

 

[vbaInet]

Do you have any fields called Date?
Also, check your References.

 

[CI-DIRECTOR]

I have changed all fields in my database which mention date but I'm not sure what you mean about references. I should say that I also get an error message when trying to format the dates too.

Funny how we forget how when we started using the previous version of a program it also caused us grief.

 

[CBrighton]

References can be checked in the VBA window (alt&F11 - Tools => References).

 

[CI-DIRECTOR]

Thanks for the help - have cut a corner and just used Now().

 

[RuralGuy]

That's fine for now but you will eventually need to solve this issue.