Svgmassive
asked on
Access printing shortcut in Ms Access
I have a report that I have set up a printing shortcut set up in the printing preferences that selects the bin , papersize and orientation.Can I use VBA to make the shortcut active when selecting the report and return the printer back to the previous setting when exiting the database
What is a "printing shortcut"?
Access remembers certain printer settings for a report such as alternate trays. You will need to test on several computers but shouldn't have to make any adjustments as long as they are using a similar printer.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am trying to change the paper and bin selection at the printing short cuts.
I have attached the jpeg.
thanks
printing_shortcuts.bmp
I have attached the jpeg.
thanks
printing_shortcuts.bmp
@Svgmassive
That is a printer specific feature, not something that can be controlled from VBA unless the printer company provides an API (which it probably doesn't).
That is a printer specific feature, not something that can be controlled from VBA unless the printer company provides an API (which it probably doesn't).
ASKER
The problem I am having since i don't have admin rights the PDF is of a legal size paper and i need it to print from tray 3 and it doesn't do that from within ms access
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi MacroShadow that works for printing the report.I am trying to bulk print pdf files in a folder from within access and it doesn't chose the correct bin.I have to constantly go and select the right bin.
Thanks
Thanks
How are you printing the PDFs?
Can you post your code?