Footer Date Stamp Problem

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi All,

I've developed some basic reports that include a date stamp in the footer.
I put it there using Insert/Date and Time... from the design menu. Access
drops this code

=Format(Date(),"Long Date")

into a text box. The problem is, I get the correct date information when I
run the report but when run on other machines by my user group, ?Name shows
up in the control. I've got several other dates on the report, some of
which are manipulated with functions (not Format), and there are no problems
with them.

I'm running:

WinXP Pro
Access 2000 SP3

Users are running:

Various versions of Windows
Access 2000 SP3

Any ideas or suggestions?

Thanks & Ciao,

Tony
 
Tony said:
Hi All,

I've developed some basic reports that include a date stamp in the footer.
I put it there using Insert/Date and Time... from the design menu. Access
drops this code

=Format(Date(),"Long Date")

into a text box. The problem is, I get the correct date information when I
run the report but when run on other machines by my user group, ?Name shows
up in the control. I've got several other dates on the report, some of
which are manipulated with functions (not Format), and there are no problems
with them.

I'm running:

WinXP Pro
Access 2000 SP3

Users are running:

Various versions of Windows
Access 2000 SP3

Any ideas or suggestions?

Thanks & Ciao,

Tony
Click to expand...
Tony,
On those machines that give an error,
open any module in Design view, or press Ctrl + G.
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft
Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access' for
the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for
how to reset a missing one.
 
Fred,

Thanks for the quick response. What you suggested worked perfectly, and I
only had to remove the reference once. When I went to some of the other
clients, it was gone already.

Thanks again & Ciao,

Tony
 
Back
Top