Creating Labels, Missing Column

A

AKK Lover

I'm trying to create address labels. In my file I have the columns for
"Street Address", "City", "State", "Zip Code" and "Country". The street
address does not show up in the window to select what info I want on the
label. Anyone know how to fix this???
 
W

Wayne-I-M

Hi

In your table you "may" have IDfield, 1stName, 2ndName, Street Address,
City, State, Zip Code and Country.

Create a query based on the table. Bring all the fields in the query and
create a calculted culumn with something like
Capital: Left([1stName],1)

Create a new report based on the query - insert something like this into a
text box (this is the source).

=([Capital] & " " & [2ndName]) & Chr(13)+Chr(10)+[Street Address] &
Chr(13)+Chr(10)+[City] & Chr(13)+Chr(10)+[State] & Chr(13)+Chr(10)+[Zip Code
& Chr(13)+Chr(10)+[Country]

Go to page set up

Select the number of columns you want and the column size and width

Print the 1st page of the report to make sure it's OK.

You will need some method of limiting the number of lables - you may want to
look at create a new form (based on the same query) and using query by form
to limit which lables are printed.

Good luck
 
A

AKK Lover

Wayne, thank you for your effort, but you are like someone I used to work
with that if you asked the time he would tell you how to make a clock. I
think you're over thinking this. My Access database I have columns for 1st
name, last name, street address, city, state, zip, country, phone, email and
more. You can click on the "Create" tab at the top, in the "reports" section
you select "Labels". You can there select the Avery label you are using. In
my case "5160" (a 1" x 2 5/8" label). Click next and select your font and
size, text color. Click next and there is a window showing all available
fields. It list all your columns, except for some reason it doesn't list
"Street Address". So I can easily select the names, city, state, zip. but I
can't get the street address. Seems like a very easy process. Once the fields
are selected, click next and select what order you want your labels to sort
by ie: Last Name, or something else. Click next, name the file then click
Finish. At that point it gives you a view of the label file you created. In
my case 5 pages, 3 labels wide, 10 labels tall.

Would anyone know why my "street address" column would not show up in this
list of "Available Fields"?

Sorry for the length of this but I think I may have been misunderstood
 
A

access database reports

i would like to create lables with access where do i start at? i don't know
where to go i have thmicrosoft office access 2003 book but i can't find it in
the book could you guide me to the right page or steps

thanks

Dana
 
J

Jeff Boyce

Dana

Are you referring to "mailing labels"?

If so, you can use the <New> <Report> toolbar button/wizard to help walk you
through the process.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
F

fredg

i would like to create lables with access where do i start at? i don't know
where to go i have thmicrosoft office access 2003 book but i can't find it in
the book could you guide me to the right page or steps

thanks

Dana

Labels, as in Mailing Labels?

Do you already have a table with the names and addresses?

If so, then ...
Click on Reports + New
Select the Label Wizard
Enter the record source for the labels
Follow the wizard's instructions
 
A

access database reports

Thank you regarding the lables.


Here is another question i just downloaded Access 2007 and know i can not
find none of my inventory that i entered in Access 2003 did i lose it ? and
do i have to entered everything all over again in Access2007.

Thanks
Dana
 
J

Jeff Boyce

You'll want to repost as a new thread. When you "bury" your new question
down in an existing thread, fewer folks see it and respond.

I don't have enough information to hazard a guess. For example, did you use
Access 2007 to "convert" your Access 2003 database?

Or, how are you trying to open the "old" database w/ Access 2007?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
A

access database reports

i had Access 2003 i set up a inventory list and now i have Access 2007 and i
can't find none of my inventory i know that the Access 2007 override Access
2003 but know i don't know where to look i look but can't seem to find it.

Thanks
Dana
 
J

Jeff Boyce

Since we're not there and know nothing about how your Access 2003 "inventory
list" was set up, we'll be hard-pressed to be able to tell you where your
data might be.

Is there a chance your application has both front-end and back-end (i.e., is
"split")? If so, the front-end portion should contain links to where the
back-end data is located.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Top