Date function not recognised in Access

[Guest]

I hope some people out there might be able to help me. I have an Access 2002
database with various tables in it. If I go in to design view of any table
which has a date field in it and then modify the table design and save and
close the table it gives an error "This function is not Recognised". I go to
the date field and my default value for that field is set to : =Date() and it
doesnt recognise this function at all for some reason. This error hapens on
certain machines and on some it does not happen.

 

[Jeff Boyce]

Check the References (open a code module, click Tools|References). It
sounds like one's gone MISSING. Uncheck it, close, reopen the References,
re-check it, and recompile.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Thanks, but this is not an application written in the database, this is
purely a database with tables in it. and this error happens on the tables
level when I view a table in design mode. Then the error Occurs on a field
that has a data type of date/time and the default value is set to =date(). It
states that it does not recognise that function. Any help will be greatly
appreciated..

 

[TC]

Jeff's comment still applies. You might have a missing reference. Just
create an empty code module, so you can get to the Tools:References
command, to check for that.

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[Guest]

It makes sense to me that it can be the references and dll's that access use,
but what if the user only has access runtime installed on their machine? What
steps need to be taken to rectify this problem then?

 

[Van T. Dinh]

If Access runtime is installed, the VBA dll is also installed on the PC.

 

[Van T. Dinh]

It may not be the cause but I normally use Date() *without the equal sign in
the DefaultValue Property of the Field in Table DesignView.