Date()

[Kim]

When I add this to a field on the criteria - I get an
error indicating that the syntax is incorrect or that the
expression is too complex, I can use this in my Access
2000 version - but why can't I use this in my Access 97
version????

 

[John Mishefske]

When I add this to a field on the criteria - I get an
error indicating that the syntax is incorrect or that the
expression is too complex, I can use this in my Access
2000 version - but why can't I use this in my Access 97
version????

Can you post the SQL if this is a query or explain a little more
what you're doing?

 

[Kim]

I have a field in a query called appointment date, and I
want to just display todays date when a form is opened
(that uses this query). So I added "DATE()" to the
criteria on the query - but it will not run the query

 

[John Mishefske]

I have a field in a query called appointment date, and I
want to just display todays date when a form is opened
(that uses this query). So I added "DATE()" to the
criteria on the query - but it will not run the query

You could just create a textbox on the form and set its
controlsource property to

=Date

If you want another field in your query with today's date
then add a new column and type

TodayDate: Date()

in the Field: row of the column.

 

[John Vinson]

When I add this to a field on the criteria - I get an
error indicating that the syntax is incorrect or that the
expression is too complex, I can use this in my Access
2000 version - but why can't I use this in my Access 97
version????\

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.