Access 2007 Runtime and Date()

[Rose B]

I have recently converted an Access 2002 application to 2007 and then tried
to run under Acess 2007 runtime. I have found that any underlying queries or
field sources that use the Date() function don't seem to work. I am still
trying to find my way through this, but so far have found that if I replace
with Now() then this seems to work (but checking formats, calcs etc.) - if
anyone has found a better way would love to hear as wading trhough every
query and form is very tedious! (VB code seems to be OK).

Any suggestions appreciated.

 

[John W. Vinson]

I have recently converted an Access 2002 application to 2007 and then tried
to run under Acess 2007 runtime. I have found that any underlying queries or
field sources that use the Date() function don't seem to work. I am still
trying to find my way through this, but so far have found that if I replace
with Now() then this seems to work (but checking formats, calcs etc.) - if
anyone has found a better way would love to hear as wading trhough every
query and form is very tedious! (VB code seems to be OK).

Any suggestions appreciated.

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.
Date() is very often a victim of missing references!

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

 

[S.Clark]

I would think that you have a missing reference, which is common with the
Date() function.

If not, then you can use DAO to walk through all queries and replace Date()
with Now().