Label Wizard pulling wrong information

G

Guest

Hello !
I have never used Access before. A friend of mine set up the program for me
so that I can enter new names/addresses into a database and then print labels
using label wizard.

I have been adding and deleting people from my database all week. Now when
I go to label wizard and generate the labels it is pulling up people that no
longer exist in my database. Why ?
 
G

Guest

It sounds like your deletes are not working. The names are not actually
getting deleted from the table. If you can scroll through the table, I think
you will find the people you thought you deleted still in the table.
 
G

Guest

That's what I thought too - so I checked the table and the entries are gone.

When I change the table/database,,,,that should change what prints out on
the labels, right ?
 
J

John Vinson

When I change the table/database,,,,that should change what prints out on
the labels, right ?

Depends on the Report. Perhaps there are TWO tables, and you're
editing one table and the label report is printing from a different
one!

Try opening the label Report in design view, and view its Properties.
The Recordsource property should either be the table that you're
editing, or a Query based on that table. What is in this property? Is
it what you expect?

John W. Vinson[MVP]
 
M

MacDermott

I'm a little concerned that you're using the label wizard to create a new
report each time.
Once a report is created, you should be able to run it over and over.
Each time, it will show your current data.
There shouldn't be any need to run the wizard again.
 
G

Guest

That is what it is. The Labels report is pulling people in from a different
table that when I enter into the database.

I have one master list that comes up fine (654 people in the database and
654 people in the label list). Unfortunately when I split up the lists (I
have the tables broken down into 5 different tables for mailing purposes) the
information is pulled in from the wrong table.

I don't know how to fix this.

Help ?
 
J

Joan Wild

You really shouldn't create 5 different tables for mailing purposes. Just
add a field to your 'master' list where you can specify the mailing purpose.
Then all you need to do is create a query based on this table, and set a
criteria on the mailing purpose field to pull the one list.

Then your report can be based on this query.
 
G

Guest

Sorry - I know what I wanted to say - but it came out different.

I do have one master list - and on that master list I am able to change to
any of the 5 different lists (for viewing and editing purposes).

When I select from the customer master list to the labels - all is well.

But when I choose one of the 5 contained within the master list (it brings
up the old table information).

I'm confused.
 
J

Joan Wild

Missie1 said:
I do have one master list - and on that master list I am able to
change to any of the 5 different lists (for viewing and editing
purposes).

When I select from the customer master list to the labels - all is
well.

But when I choose one of the 5 contained within the master list (it
brings up the old table information).

I'm confused.

As am I. Why do you have an 'old table'? You should have one table.
Perhaps post with a description of your tables.
 

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