Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ACC97: DATE function now returns a "type mismatch"

Status
Not open for further replies.

AlanKW

Technical User
Jun 20, 2002
161
US
ACC97 DATE function now returns a "type mismatch"

In a production system, the DATE function has stopped working. This line which worked yesterday now does not.
[tt]If PendedDate = Null Or IsDate(PendedDate) = False Then PendedDate = date[/tt]

There were no changes to the server or to the desktops. The NOW function still works. The DATE function works in other databases.

The references loaded are:
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library
Microsoft Excel 9.0 object Library

(we use Access97 and office 2000)


Another database that has the same references but Word instead of Excel

Please advise
 
[red]STUPID HUMAN TRICKS[/RED]

I foolishly and mistakenly saved a module with the name DATE. Once I renamed that, it worked....

Hope someone learns from my pre-caffeine stupidity :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top