CREATING A FORM AND PRINTING LABELS

[Rjconrep]

I am trying to create a form that the shipping department can use.
Things they will need to do:
1. Add records
2. Search for mailing info on companies in the data file
3. Print mailing labels for only the companies they have selected.

I am trying to figure out a way to create a mailing label from a form.
HELP
RJM

 

[THoey]

Couldn't you create a table just to hold this information? Pseudo code:

- Empty table of previous labels
- User selects companies to mail to (put names or ID's into table)
- Query updates table with company info
- run report to print the labels

Does this point you in a good direction? Terry M. Hoey

 

[Rjconrep]

I already have a table created with the Contact information in it. However, there are alot of instances where the company name is repeated, just the contact person changes. So if shipping chooses lets say "ASPEN" in the company field and 6 different records come up but she only wants the one with the contact person "Rhonda" how would I get the form to save only the one record to a different table. Am I making this more complicated than it is?
It started out as an action query and a report, now it has turned into a fancy form with all of the bells and whistles. I don't think people realize how much work goes into these things. If they did they wouldn't make so many changes half way in.

Thank you for your help!!!

 

[THoey]

Sorry this is rushed, but I am on my way out the door for a three day weekend...

I would have a listbox that displayed the companys (query your table for all DISTINCT companies). After that is selected, another listbox with the different names of people from that company (Second query that is refreshed when the first listbox has an item selected and queries for all the names where the company = the selected company). Based on what the user chooses here, add a record to the table. Then, another button that would print the report once they have select everyone they want to send to.

Hope that helps. If not, post back and someone will help or I will try again on Tuesday... Terry M. Hoey

 

[Rjconrep]

Here is what I have so far:
I have 1 datafile (shipping) which has all of the shipping information in it. (Contact, company, addr1, addr2, csz, phoneNumber). This is what I based my Form on.
I created an action (create table) query that will prompt the user for the company name and then the contact name.
On the form I of course have all of the shipping fields, I have a command button that will search for the company, once the company is found I have a button that access's my query. The user then puts the information in and the query updates a table called labels. I then have another button that goes to the label screen. I have most of what I need I think. My delimma now is: How do I print one record multiple times?
If you thing that I am going about this all wrong let me know. I have just started writing code in VB so I have been using a lot of the command buttons and letting access do most of the work.
Thank you for your help.