Date Formatting problem?

[servoss]

I'm having an odd situation in which the same piece of code works on one machine, but not two others.

I have a report that groups data by month and outputs that month to each group using the following function:

=Format$([IssueDate],"mmmm yyyy")

This works quite well on one machine, which is running Windows 98 and Access 2000. It does not work on two other machines: one with NT and one with XP, both using Access2000.

On these machines when I run the report the field contains #Name?. If I try to edit the field data control (in report design view), I get an error box, an image of which is attached.

I have checked the VBA Reference library listings on all three and they are identical - same libraries checked and in the same order.

I am at a loss.

Any thoughts?

Thanks,
Tom

 

[Rich]

Almost certainly a reference problem, try here
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[servoss]

Ok, I figured it out...

Turns out there was a MISSING library referenced before the one that was needed for the format command. I removed the MISSING one and it worked just fine.

Thanks, anyway, for the help.

Tom