Formatting Issue 1

[robinsql]

Hi,
I am having a problem formatting the date in Access97. The following works fine in Access2000 but not in 97.
Anyone know what the problem is?
Thanks for any help.

=Format(Date(),"Long Date&quot & " " & Format(Time(),"Long Time&quot

 

[danvlas]

It also works in my A97...

Check for missing references in your 97 database

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[robinsql]

Hi,
How do I check for missing references?

 

[danvlas]

Open any module (even a new one), go to Tools-References.




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[robinsql]

Hi,
You are right. I am missing the following...
Micrsoft DAO 3.51 Object library
Microsoft Visual Basic for Applications

How do I get them?
Thanks!

 

[robinsql]

Hi,
Thank you very much for your help. I removed and then reset the references and it is now working fine.
Thanks,
Robin