Creating a mailing labels report using the labels wizard

  • Thread starter Thread starter M. A. van Schaik
  • Start date Start date
M

M. A. van Schaik

I am using Access 2000, but I am new to the product.

I am following directions in a textbook to create a
mailing labels report using the labels wizard.
I can complete all the steps, but when I hit the Finish
button at the end, the program does not generate a mailing
labels report in the Print Preview window. Instead, it
produces a dialog box that asks me to put in a value
for "trim". I am not familiar with the term and do not
know what form the value should take for the wizard to
actually produce a mailing labels report.

I read somewhere (Internet source) that the program is
supposed to automatically assign a function when I don't
assign one, but it doesn't do that. When I hit the Cancel
button I get an empty report.

Can anybody help me? Thank you.
 
I am using Access 2000, but I am new to the product.

I am following directions in a textbook to create a
mailing labels report using the labels wizard.
I can complete all the steps, but when I hit the Finish
button at the end, the program does not generate a mailing
labels report in the Print Preview window. Instead, it
produces a dialog box that asks me to put in a value
for "trim". I am not familiar with the term and do not
know what form the value should take for the wizard to
actually produce a mailing labels report.

I read somewhere (Internet source) that the program is
supposed to automatically assign a function when I don't
assign one, but it doesn't do that. When I hit the Cancel
button I get an empty report.

Can anybody help me? Thank you.
Click to expand...
You have a missing reference.
Open any module in Design view (or click 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.

For even more information, see
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
 
Back
Top