Expression not working on my computer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AP - 30 Mar 2006 23:21 GMT

The following expressions will not work on my computer. As far as I can
tell everyone else in my work group has the same version of Access with
the same service pack #. Any suggestions.

=Format(Date(),"Short Date") & " " & Format(Time(),"Short Time")

=(Format$([MONTH],"mmm yyyy",0,0) & " " & [H/P])

=(Format$([Forms]![Trend1]![DateTY],"mmm yyyy",0,0) & " " &
[Forms]![Trend1]![H/PTY])

Thanks

Reply to this Message

Graham Charles - 30 Mar 2006 23:37 GMT

This is a shot in the dark, but I've seen this happen if you've got
missing references in your project. For example, perhaps you've got a
reference to ADO 2.8 on your development machine, but your users don't
have it installed; that sort of thing.

Anyway, from one of the user's machines, go to the code window
(Alt+F11), then look at Tools / References and see if anything that's
checked off is listed as "MISSING". If you're not getting compile
errors (e.g., if you don't use any VBA code), then you can probably
remove whatever the reference is... give it a shot, anyway.

Hope that helps.

g.

Reply to this Message