Date Display

[andy1210]

I have created a report that displays the Current Month and Current Year at the top using the following code -:

=MonthName(Month(Date())) & " " & (Year(Date()))

This works fine on my machine, and if I put it on the server and run the report it works fine, however if the other 2 users who need to access the report run from either their machine or the server, then they are prompted to enter a date themselves and the report doesnt load, instead it displays Error at the top where the month and year should be. Can anyone help? Is this down to a setting on their versions of Access or something to do with the system time??

Regards

Andy

 

[Rich]

You have a MissingReference, search here for numerous posts on the subject

 

[Smart]

when you are in the vb Code of your database click on tools (on the menu bar) then on references. compare these from your Pc to those on the erroring PC's. You should spot the missing reference

 

[andy1210]

thanks for the help, I have looked into the missing reference problem and not yet solved it, I am still working on it. Could it be any other problem do you know?

Cheers
Andy

 

[richary]

Wouldn't using

=format(date(),"mmmm yyyy")

give the output you need more cleanly and possibly remove the error at the same time?

 

[andy1210]

yep, got it working. Thanks for the help.

Andy