date() function issue

  • Thread starter Thread starter billyw
  • Start date Start date
B

billyw

hi...

have got an access database set up and i'm using the =date() function to
apply date to a box.
problem is if anyone else tries to use this (on another physical PC) they
get an error.
=now() works ok but gives time etc which we dont want.
would the =today() function be a better bet?

cheers
 
billyw said:
hi...

have got an access database set up and i'm using the =date() function
to apply date to a box.
problem is if anyone else tries to use this (on another physical PC)
they get an error.
=now() works ok but gives time etc which we dont want.
would the =today() function be a better bet?

cheers
Click to expand...

This is going to sound strange, but compare the Regional settings in the
control panel of a machine that works and one that does not.
 
More than likely you have a missing reference on the machine(s) which
exhibit the problem. To check is easy enough:

On the affected machines open any code window or press Ctrl+G.

Go to Tools ... References

and either uncheck, or find and fix any marked as MISSING

It doesn't even matter which library is affected, as a single missing
reference can affect the entire application. For further information, Allen
Browne has this great information.

Http://members.iinet.net.au/~allenbrowne/ser-38.html

and Doug Steele has this:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
billyw said:
hi...

have got an access database set up and i'm using the =date() function to
apply date to a box.
problem is if anyone else tries to use this (on another physical PC) they
get an error.
=now() works ok but gives time etc which we dont want.
would the =today() function be a better bet?

cheers
Click to expand...
 
Back
Top