Date Headache

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a real problem with recording the date a check box was clicked. I
created a macro in the On Enter field of properties section of the check box.
The item is a field I call date. Under expression I put date(). By everything
I know this should work just fine. However, when the box gets check, an
error comes up saying the function is not found or something like that. So I
changed the expression to Now(). This works fine, accept now I can't run a
query on the number of changes per day. Can anyone help me with this?
 
Running a query as you wish is simple. Just include a calculated field in
the query:
TheDate: DateValue([FieldThatContainsNowValue])

Then use this calculated field for grouping or sorting or filtering or
whatever.

The reason you may have problem with Date function is that you probably have
a field or control named Date on the form. Date is a reserved word in ACCESS
and should not be used as the name of a field, control, table, form, etc.
That can confuse ACCESS. See these articles for more information:

List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266

Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763
 
Back
Top