Report printing multiples of the same label

jhaehn

New member
Local time
Yesterday, 19:54
Joined
Sep 24, 2004
Messages
5
I have a database of addresses, and I need to print multiples of some, and none of others based on preferences. How do I do this? It seems like there should be a way to do this.

*frustrated but hopeful*

Julie
 
Julie,

I'd take the simplistic approach and create a new table:

tblPrint
========
PrintID - AutoNumber
AddressID - FK to main table
Quantity - How Many to print

Then on your main form, you can put a Command Button and:

Code:
DoCmd.RunSQL "Insert Into tblPrint (AddressID, Quantity) " & _
             "Values (" & Me.AddressID & ", " & Me.Quantity & ");"

Hopefully that get's us started. Need to know how you print your
labels. Do you print one label per record? We may have to fine
tune the above, but we can do this.

Wayne
 
Wayne,

Thanks for the help, I appreciate it.

The scope of the project has grown considerably... and I'm not sure how to make this work.

Here is what I need to have it do:

I have a table of information to print labels. On this table I have 7 different types of labels. I have created 7 different forms that display the information the way I need it printed out, but right now I am having to go to each form and print the ones I need, if I need multiples of certain ones, I print it multiple times.

What I hope to do is to be able to give the different types each a identifier and do something like what was referenced in another post here. (give certain qualities the ability to be visible only if certain things were true)

I'm still lost on the print multiples of the same thing.

I want to print a list that has 3 of label X012 and 2 of label H030 and 1 of label M001 and 4 of label S023.

Is this possible?
 
Ok, I just found this thread here: http://www.access-programmers.co.uk/forums/showthread.php?t=70338&highlight=Selection

I think this is a better solution than the 7 different forms... I want to print the forms.. not a report because I can't effect the layout of the report as much as I can the form.

The labels have to have information in certain areas.

Maybe I should have put this in the form discussion area?

Any ideas?
 

Users who are viewing this thread

Back
Top Bottom