Results 1 to 2 of 2
Thread: Printer wierdness (XP/2000)
2006-07-13, 09:48 #1
- Join Date
- Jan 2001
- Manchester, Gtr Manchester, England
- Thanked 0 Times in 0 Posts
Printer wierdness (XP/2000)
I've found some code a colleague wrote a couple of years ago.
Basically it looks through a recordset, opening the report for a single record at at time and uses an attribute of the record to set part of the report caption.
For each record, the report is opened in preview mode, its caption is set to be a path and file name (complete with file extension '.pdf') and then it is printed using DoCmd.Printout. The report is then closed and the loop repeats.
By using Jaws pdf as the default printer, correctly named pdfs are then created in the correct folders without any user intervention. This handy quirk didn't work with any other pdf printers/writers.
I though this would be useful for something I'm doing now, however, Access is behaving a little oddly.
The report is being sent to a printer I don't have on my system, even though its print settings are set to 'use default printer'
The printer appears to be one in a different office (where my colleague who is using the db works).
2006-07-13, 13:04 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Printer wierdness (XP/2000)
Try setting the report for a specific printer, then set it back to the default printer.
If that doesn't help, try changing your default printer in the Printers and Fax Devices control panel, then set it back to the original one.
Sometimes actions like these help to restore things to normal.