I have a multi page per record access report that is setup to print as a folded stapled booklet, this is fine aslong as you only want to print one record at a time but when you want to print off a group of records at one time using the code
The report is sorted by the ClsDesc and grouped by the StuRecID field. Report layout wise everything is working fine, the problem is that the printer identifies the report output as being one print job no matter how many records are included in the run, ie: each record consists of 5 pages if one record is printed at a time then the printer will fold and staple the 5 pages as one single booklet, if 3 records are sent to print at the same time the printer will fold and staple 15 pages as one single booklet rather than the required 3 booklets of 5 pages each.
I am after some code that will send each individual record as one print job. At present I have had to set up a form with a combo box listing every single record, and a button that prints just the selected record, so I have to select a record, press print, change to another record, press print, etc. This takes ages when there are around 200 records.
so you have a specialised report, going to a specific printer.
I'd be tempted to read the printer manual and find what code forces a group or staple, and place that in the group footer.
Whether you can do that int he windows world I don't know, but that sort of trick was required in the so called bad old pre windows days
undoubtedly you will need to use an ASC or CHR character code
if that doesn't work then you coudl automate the process, by calling the report with each customer.
build a recordset with the customers
iterate through that recordset, calling the report with the appropriate parameters.
so have a look at opeing a recordset (DAO or ADO)
look at how to iterate through a recordset (have a look at the appropriate recordset .EOF)
have a look at the macro command to open a report (docmd.openreport).. look at the parameters you need to pass to make sure the report prints.