Access 2002
I would like to allow the user to select a printer in a form and pass that selection to a called report.
Background: This is a bill printing program so the bills must print in sequential zip code order for bulk mailing. Bills have different formats depending on type (regular, closing, etc.). A standard module calls the appropriate report based on a field in the table.
I would like to be able to send bills (say 1 - 500) to printer A and another set (501 - 1000) to printer B.
My understanding is that spooling printers together will not work because the sequence will not be maintained.
In Access 2002, I am able to load the printers into a combo box. The user is able to select the range of numbers and the desired printer. The standard module is opening the report in design view, setting the new printer and the printer settings. I coded the save and close but the settings are not saved.
This appears to be caused by the report having event procedures and therefore the "Has Module" value is "yes". If I take out the event procedure (which I need) and change the "Has Module" value to "no", the settings are saved!
Any suggestions will be greatly appreciated.
Thanks in advance.
I would like to allow the user to select a printer in a form and pass that selection to a called report.
Background: This is a bill printing program so the bills must print in sequential zip code order for bulk mailing. Bills have different formats depending on type (regular, closing, etc.). A standard module calls the appropriate report based on a field in the table.
I would like to be able to send bills (say 1 - 500) to printer A and another set (501 - 1000) to printer B.
My understanding is that spooling printers together will not work because the sequence will not be maintained.
In Access 2002, I am able to load the printers into a combo box. The user is able to select the range of numbers and the desired printer. The standard module is opening the report in design view, setting the new printer and the printer settings. I coded the save and close but the settings are not saved.
This appears to be caused by the report having event procedures and therefore the "Has Module" value is "yes". If I take out the event procedure (which I need) and change the "Has Module" value to "no", the settings are saved!
Any suggestions will be greatly appreciated.
Thanks in advance.
