label making

N

newbie

When I go to the "available fields" while attempting to make labels, I do not
see {address 1} or {address 2} fields to choose from. All the other fields
are there to choose from.
 
N

newbie

No, {address 1} and {address 2} are not listed. All the other choices are
there like name, city, state, zip.
 
N

newbie

As instucted by the label making help section, I am going to the Contacts
navigation area. Then I select contact address book. Then I go to the
create tab and select labels. Then I go to the area where I make my
prototype label. This is where I do not see the address choice in the
available fields.
 
T

Tom Wickerath

Newbie,

Are you using Microsoft Access or some other program? If you are not using
MS Access, then you are posting your question to the wrong newsgroup. This
newsgroup is for Q&A related to using Microsoft Access. If you are using
Access, then you need to answer the questions I asked, which you have not
done.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
N

newbie

Yes, I am using Microsoft Access 2007.

Tom Wickerath said:
Newbie,

Are you using Microsoft Access or some other program? If you are not using
MS Access, then you are posting your question to the wrong newsgroup. This
newsgroup is for Q&A related to using Microsoft Access. If you are using
Access, then you need to answer the questions I asked, which you have not
done.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
Click to expand...
 
T

Tom Wickerath

Yes, I am using Microsoft Access 2007.

Okay, how about an answer to my other question? I will repeat this question
here:

Are you using a table or a query as the source of records (recordset) for you
label report? If you are using a query, have you added the {address 1} and
{address 2} fields to the QBE grid? If you are using a table, are these
fields present in the table?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
D

DAP

I have the same problem... The address field is in the database, but does not
show up when I try to print lables...Help!
 
D

DAP

I have the same problem.. The address field is in my contact list, but
cannot use it for lables... Any suggestions?
 
T

Tom Wickerath

Hi Jeff,

Why would the author of this template have chosen the memo data type for an
address field??? That's just plain nuts! Any chance of getting them to fix
this?

To Terry: You got lucky this time with a speedy reply, since Jeff (a
Microsoft employee) replied to this thread. In the future, you will very
likely get a much faster resolution to your issue if you can provide more
useful information, instead of just saying "I have the same problem...".
This includes identifying the version of Access that you are using, along
with service packs applied. Yesterday, I asked Terry if he created this
database himself, or downloaded it as a template. If you were having the same
problem, then you likely downloaded the database as a template, right? In
which case, you could have said so and provided a link. That way, other
people such as myself can quickly grab a copy of the sample and start looking
into the issue instead of just guessing what the user is or is not seeing.
Just my 2 cents worth.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
J

Jeff Conrad [MSFT]

in message:

Hi Tom,
Why would the author of this template have chosen the memo data type for
an
address field???
Click to expand...

This is the "standard" with all the existing templates. Any template with a
contacts or employees table will see this because they are all taken from
one "base" master template table. (Like an assembly line if you get the
picture.) The Contributors and Employees table in the Charitable
Contributions, for example, inherit the same attributes as the base tables.
That's just plain nuts!
Click to expand...

I'm sure you can guess my opinion. said:
Any chance of getting them to fix this?
Click to expand...

Most likely not because they would have to change virtually every template
and I would surmise they're not willing to do that especially when it's an
easy change to make for the user if they so choose.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
T

Tom Wickerath

Hi Jeff,
Most likely not because they would have to change virtually every template
and I would surmise they're not willing to do that especially when it's an
easy change to make for the user if they so choose.
Click to expand...

Given that this silly decision to make an address field a memo data type has
affected three people in just this thread alone ("newbie", "DAP" and
"Terry"), I can see why you've prepared a web page to address this issue.
Looks like it's going to be a very popular sticking point with many users.

Any chance of getting this fixed for the templates available in the next
release of Office 14?


Thanks,

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
J

Jeff Conrad [MSFT]

in message:

Hi Tom,
Given that this silly decision to make an address field a memo data type
has
affected three people in just this thread alone ("newbie", "DAP" and
"Terry"), I can see why you've prepared a web page to address this issue.
Looks like it's going to be a very popular sticking point with many users.
Click to expand...

Exactly, and I would very surprised if a KB article would be made on it so I
thought it would be prudent to make a FAQ page. (Emphasis of course on the
first letter said:
Any chance of getting this fixed for the templates available in the next
release of Office 14?
Click to expand...

I'll bring it up with the team.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank Page After Envelope-Label Wizard 5
ASK Field Formatting 1
MS Project Center-Autolink column fields 0
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
Mail merge labels 8 per page, but 84 is not divisible by 8 3
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0

Top