Report Date Not Being Displayed Properly

[Rick_C]

In the header section of each report, I have a self generated text field to
display the computer's today's date as June 9, 2009. When the report
displays, it looks like #NAME?.

All the dates that are queried from the data fields and are formatted as
mm/dd/yyyy, display correctly.

The program runs on 30 different computers. 29 work correctly. 1 is causing
me this headache. The only difference is that it is a new computer with
Office 2007 installed. All the other computers have either Office XP or 2003.

I checked the format on the PC and Regional Settings. They seem to be correct.

Thank you in advance for any help.

Rick

 

[Klatuu]

You don't say what you are using to display the date, but It sounds like you
are using either Date or Now.
Check the VBA references in the offending computer. You probably have at
least one missing.

 

[Rick_C]

Dave,

Thank you for your reply... I am using DATE.

Also... This is a Developer's Toolkit installation. So far the only
difference between the offending computer and all the others is the Officer
2007.

I was hoping this would not be a solitary problem :-(

Rick

 

[Klatuu]

It isn't that difficult. Open the VBA editor select Tools, Relationships,
and look at the list. You will probably find one marked Missing.