All fields not transferring from table to avery wizard labels

[lblount]

When I create labels with the wizard (which I did regularly with Access 95) I
get a message that 'some data may not be displayed'. Message details says
that its a problem with the label wizard but it can probably be ignored. I
click ok and I get an input window for 'trim parameters'. I don't know what
it means. I click ok and my labels show 'error' on the top line for name and
last name, and on the bottom line for city, state zip. The 2 address lines in
the middle are fine. Any ideas?

lblount

 

[fredg]

When I create labels with the wizard (which I did regularly with Access 95) I
get a message that 'some data may not be displayed'. Message details says
that its a problem with the label wizard but it can probably be ignored. I
click ok and I get an input window for 'trim parameters'. I don't know what
it means. I click ok and my labels show 'error' on the top line for name and
last name, and on the bottom line for city, state zip. The 2 address lines in
the middle are fine. Any ideas?

lblount

Your PC has 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

 

[lblount]

I can't find 'references' under the tools menu or anywhere else. I just
installed Access 2003. Sorry I didn't mention that but in the help menu it
also says to look for the 'references' that you mention. Maybe I should
reinstall?

 

[fredg]

I can't find 'references' under the tools menu or anywhere else. I just
installed Access 2003. Sorry I didn't mention that but in the help menu it
also says to look for the 'references' that you mention. Maybe I should
reinstall?

You must open a VBA code window first.

Open any module in Design view (or click Ctrl + G). <

Then click on Tools + References.

 

[lblount]

Also, when converting the database from Access 95 to Access 2003 I got a
conversion error that reads "Missing or broken VBE reference to the file
'MSJETSQL.TLB'." Could this have anything to do with my problem?

 

[John Vinson]

Also, when converting the database from Access 95 to Access 2003 I got a
conversion error that reads "Missing or broken VBE reference to the file
'MSJETSQL.TLB'." Could this have anything to do with my problem?

It's another expression of the same problem. If any reference is
missing, it messes up all the other references!

As Fred suggests: Open Access; type Ctrl-G to open the VBA editor
screen; and *then* select Tools from the menu. The first option on the
Tools dropdown will be "References".


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[lblount]

Thank you very much. I unchecked the missing item in VBA and the labels work
now except: the first line of the label is First name-space-Last name.
The first name is fine but all the last names are replaced by the name of
the report "labels maillist'. Any more ideas?

 

[Dirk Goldgar]

Thank you very much. I unchecked the missing item in VBA and the
labels work
now except: the first line of the label is First name-space-Last name.
The first name is fine but all the last names are replaced by the
name of
the report "labels maillist'. Any more ideas?

Do you perhaps have a field in your table or query named "Name"? Is
this the field that is being replaced by the name of the report? That
seems a likely cause, as you might refer to [Name] and Access could
interpret that as the Name property of the object in question. If this
is the problem, your best solution would be to rename that field, in the
table and in every query or controlsource where it appears, to something
else -- "LastName", possibly.

A shortcut approach -- if this is the problem -- would be to look at the
definition of the label report and see if you can modify the
controlsource of the text box that makes the first line of the label, so
as to qualify the reference to the Name field with the table name as
well; e.g., instead of

[FirstName] & " " & [Name]

have

[FirstName] & " " & [YourTableName].[Name]

That might do it.

 

[fredg]

Thank you very much. I unchecked the missing item in VBA and the labels work
now except: the first line of the label is First name-space-Last name.
The first name is fine but all the last names are replaced by the name of
the report "labels maillist'. Any more ideas?

** snipped **

What is the EXACT actual expression used in this control?

 

[lblount]

Thanks Fred but Dirk nailed it. Access was confusing my 'Name' with the name
of the report. This is tricky stuff and I really appreciate your time.

 

[Tom Wickerath]

lblount,

Here are a couple of KB articles that you might want to bookmark for future reference:

Reserved Words in Microsoft Access
http://support.microsoft.com/?id=286335

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763


Also helpful are the following two web pages:

Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp


Tom
___________________________________________


Thanks Fred but Dirk nailed it. Access was confusing my 'Name' with the name
of the report. This is tricky stuff and I really appreciate your time.