Date()

  • Thread starter Thread starter Kim
  • Start date Start date
K

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????
 
Kim said:
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????
Click to expand...

Can you post the SQL if this is a query or explain a little more
what you're doing?
 
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
 
Kim said:
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
Click to expand...

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.
 
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????\
Click to expand...

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.
 
Back
Top