ACCESS 97 syntax help SOS

[littlehelp]

Simple questions about ACCESS.

What is the function for system date and time in ACCESS 97? In ACCESS 2000, they are Date(), Time(). But didn't work in ACCESS 97.

 

[RobertT687]

Same thing in Access97. Get to debug window in a module. Enter ? date() ? time() ? Now() or ? date ? time ? Now
What are you seeing that tells you they aren't working?

 

[littlehelp]

Just in Access 97 Form, i want to set Dafault value of data date field as current date. So in property, i add Date() to default value, it has error message. but worked in Access 2000.

 

[RobertT687]

What's the error message? I just tried this in A97 on a new form. Default value of unbound field set to Date() with no problem.

 

[tlbroadbent]

You should ask Access questions in an Access forum. Try one of the following.

forum701 - Microsoft: Access Forms
forum705 - Microsoft: Access Modules (VBA Coding)
forum181 - Microsoft: Access Other topics
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.