printing labels to selected rows/columns

DesBlair

New member
Local time
Today, 22:19
Joined
May 7, 2005
Messages
8
Has anyone found an easy way to print single address labels to a specified row and column on a label sheet? I can print to the first row and column but not to anywhere in a partly used label sheet. One way is to set up separate margins for each position but on a 7 by 3 sheet this would mean having 21 separate settings - not very practical. Any thoughts other thyan exporting to Word??

DesBlair
 
This seems to be a pretty common question around here.

For this situation I have a pop-up form that allows the user to enter the row to begin printing on. Then with a command button I use VBA and SQL to make a temporary table, first inserting blank records into the table (to skip over rows) and then appending the records to be printed on the labels. A label report is then run off this table.

Attached is an example.
 

Attachments

Thanks!

Many thanks RichO. It's easy when you know how!

DesBlair
 
Label printing from a query

Thanks to RichO for the help with my earlier problem – Printing to particular label rows works fine when printing all the records. My difficulry now is how to do this when printing from a query which is used to select a subset of the records. What I really need to do is be able top select one or more records and print to any row on a label sheet. I feel sure the answer lies in some VBA code but I can’t figure it out. See qryCategorise and report AddressLabelsSelection.
Can anyone help please? (Access 2002)


Des :confused:
 

Attachments

Here's what I did with your example:

I converted your query to an append query to append the information to the temp table. Then from the form, when you select a category I set the warnings to false (so it doesn't alert you that it's going to paste rows into your table), opened the append query, set the warnings back to true, and opened the report.

You don't need dual reports for this application as long as you are displaying the same information.

Also, it looks like your labels print only 2 per row but you changed the code that skips rows for 3 labels per row. Is that what you wanted?

I also set the form up with only one command button for printing. If there is an entry in the combo box it appends labels based on the selection, otherwise it appends all.
 

Attachments

Thanks again!

Works perfectly. Yes I am using 3 column Avery labels. No problem though - even I can fix that. Thanks again Rich. What a useful forum this is!
Des :-)
 

Users who are viewing this thread

Back
Top Bottom