 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / October 2005Label Wizard pulling wrong information
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 ? 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. > Hello ! > I have never used Access before. A friend of mine set up the program for me [quoted text clipped - 4 lines] > I go to label wizard and generate the labels it is pulling up people that no > longer exist in my database. Why ? 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 ? > 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 [quoted text clipped - 8 lines] > > I go to label wizard and generate the labels it is pulling up people that no > > longer exist in my database. Why ? >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] 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 ? > >When I change the table/database,,,,that should change what prints out on > >the labels, right ? [quoted text clipped - 9 lines] > > John W. Vinson[MVP] 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.  SignatureJoan Wild Microsoft Access MVP > That is what it is. The Labels report is pulling people in from a > different table that when I enter into the database. [quoted text clipped - 21 lines] >> >> John W. Vinson[MVP] 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. > 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. [quoted text clipped - 28 lines] > >> > >> John W. Vinson[MVP] > 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 [quoted text clipped - 7 lines] > > 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. SignatureJoan Wild Microsoft Access MVP 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. > Hello ! > I have never used Access before. A friend of mine set up the program for me [quoted text clipped - 4 lines] > I go to label wizard and generate the labels it is pulling up people that no > longer exist in my database. Why ? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.