By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,283 Members | 1,703 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,283 IT Pros & Developers. It's quick & easy.

=Format$ field doesn't work after copying database to new computer

P: n/a
Hello,
After copying a database to a new computer, a header using the
=Format$ stops working. Instead of displaying the field, the report
prompts me to "Enter paramater value for Format$. Any input would be
appreciated.
TIA,
Jerry Harris
Western Kentucky University
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 10 Feb 2004 07:28:25 -0800, Jerry Harris wrote:
Hello,
After copying a database to a new computer, a header using the
=Format$ stops working. Instead of displaying the field, the report
prompts me to "Enter paramater value for Format$. Any input would be
appreciated.
TIA,
Jerry Harris
Western Kentucky University


Jerry,
The machine may have a missing reference.
Open any module in Design view.
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
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.