Date() expression

C

Christopher Buxton

i am trying to get todays date to display as the default in my main table. I
am using the expression Date(). This works fine on my computer.

I have then setup a query to only display records with todays date by using
the expression Date() in the filter. This displays only records that have
been input on today. That works on my computer.

When I took it to work to use, it displayed the error message stating that
the expression 'Date' was invalid in 'jobT.input date'.

My home computer is a Celeron 2.0GHz 256MB RAM. Windows XP and Office 2000.

My work computer is P3 1.4GHz approx. 64MB RAM. Windows 98 and Office 2000.

Why won't it work? Is there another way of achieving my goal.

Thanks

Chris
 
J

John Vinson

When I took it to work to use, it displayed the error message stating that
the expression 'Date' was invalid in 'jobT.input date'.
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.

Another possibility is that you have some code or control referencing
a field or control named "input date". If so, you MUST enclose this
name in square brackets, since the blank is being interpreted as a
delimiter rather than part of the name. Alternatively, avoid using
blanks in object names - InputDate is just as readable and doesn't
require bracketing.

John W. Vinson[MVP]
 
Top