=DATE() doesn't work in a report

[terri]

i have reports the we have used for over a year that suddenly doesn't like
the =DATE() cell on one computer.
We have reinstalled MS Office and this has not helped.
It worked last week on that computer...and now does not. Just that one
cell. Why would it work everywhere but on that one computer? The report is
a letter, and the date is in the detail portion of that letter/report.

 

[Douglas J. Steele]

Go into the VB Editor, and select Tools | References from the menu (make
sure no code is running when you do this).

If any of the selected references have "MISSING:" in front of them, unselect
it (them), and back out of the dialog. If you really need the reference(s)
you just unselected (you can tell by doing a Compile All Modules, under the
Debug menu), go back in and reselect it (them).

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected.

NOTE: write down what the references are before you delete them, because
they'll be in a different order when you go back in.

 

[Ken Sheridan]

Terri:

Check that the reference to the VBA object library is not 'missing' or
'broken' (Tools | References on the VBA menu bar). If it is try unchecking
the reference, closing the dialogue, and then reopening it and checking the
reference again.

You might also try explicitly referencing the VBA library when calling the
Date() function in the report, with =VBA.Date().

BTW a 'cell' is a spreadsheet concept not a database one. In Access reports
or forms have 'controls' (in this case a text box control I'd assume) and
tables have rows and columns, aka records and fields.

Ken Sheridan
Stafford, England

 

[James A. Fortune]

i have reports the we have used for over a year that suddenly doesn't like
the =DATE() cell on one computer.
We have reinstalled MS Office and this has not helped.
It worked last week on that computer...and now does not. Just that one
cell. Why would it work everywhere but on that one computer? The report is
a letter, and the date is in the detail portion of that letter/report.

This thread might contain helpful information:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/e2deb34d06e97cfc#

James A. Fortune
(e-mail address removed)

 

[terri]

i'm sorry....i can't find the VB Editor....have never used it ... so i guess
this is something i can't fix. we have MS 97.

 

[Douglas J. Steele]

It's sufficient to invoke the Debug window (using Ctrl-G), as long as you
don't have things set up to have the Debug window on top (look on the Module
tab under Tools | Options)

 

[ANTONIO CARLOS HOPPNER]

Terri:

Check that the reference to the VBA object library is not 'missing' or
'broken' (Tools | References on the VBA menu bar). If it is try unchecking
the reference, closing the dialogue, and then reopening it and checking the
reference again.

You might also try explicitly referencing the VBA library when calling the
Date() function in the report, with =VBA.Date().

BTW a 'cell' is a spreadsheet concept not a database one. In Access reports
or forms have 'controls' (in this case a text box control I'd assume) and
tables have rows and columns, aka records and fields.

Ken Sheridan
Stafford, England