Date() function in Access

[Dave]

I have used the 'Date()' function in Access on several occasions to insert
the current date into a field. However, I notice that on some computers, the
macro fails, saying it doesn't understand teh function. This is despite
using the same version of Access (2000) throughout the network, using the
same service pack (3) and checking that the msowcf.dll is installed in all
cases. I also checked regional settings to see if there was any clue there.
Any ideas?

Thanks in anticipation,

Dave

[Allen Browne]

Has to be a references issue:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave" <no****@yourbusiness.com> wrote in message
news:uV*********************@wards.force9.net...

I have used the 'Date()' function in Access on several occasions to insert
the current date into a field. However, I notice that on some computers, the macro fails, saying it doesn't understand teh function. This is despite
using the same version of Access (2000) throughout the network, using the
same service pack (3) and checking that the msowcf.dll is installed in all
cases. I also checked regional settings to see if there was any clue there. Any ideas?