General discussion

Locked

Access2000: Date() doesn't work

By AJD ·
I have an Access 2000 database that uses the Date() function to return the current date. It works fine on my WinNT4.0 workstation. When I open the database on any other WinNT4.0 or Win9x machine, the field returns a #name? error. Why?
Is there another function I can use to return the date?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access2000: Date() doesn't work

by kirya In reply to Access2000: Date() doesn ...

Sorry, but I don't know were the error may be. The other ( a bit ugly) way to get the date is DateValue(Now())

Collapse -

Access2000: Date() doesn't work

by AJD In reply to Access2000: Date() doesn ...

Thanks for the tip, that did actually work but the underlying problem is still there.

Collapse -

Access2000: Date() doesn't work

by keith.hall1 In reply to Access2000: Date() doesn ...

Could be that if you check the references from the tools menu in the Visual Basic Code section that one of them is marked as missing - possibly DAO. Uncheck this and then scroll further down the list for the same library to see if its installed another location on your other machines.

Regards

Keith Hall

Collapse -

Access2000: Date() doesn't work

by AJD In reply to Access2000: Date() doesn ...

Thanks, mate - you're a guru!! The database was actually referencing a library from the Veritas Backup Exec client I had on my machine, which was not on any of the other workstations. Thanks for your help! Spot on!

Collapse -

Access2000: Date() doesn't work

by acwiz In reply to Access2000: Date() doesn ...

If you are using it as the default property it should work. If it is the control source make it "= date()" (without the quotes).

Collapse -

Access2000: Date() doesn't work

by AJD In reply to Access2000: Date() doesn ...

Tried that already. Thanks anyway.

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums