Saving printer with report (1 Viewer)

M

markcrobinson

Registered User.

Local time

Today, 15:12

Joined

Nov 28, 2017

Messages

14

• Nov 30, 2017

• #1

Strangely, every time I try to print a certain report from my VB script, it sends it Tray 1 of my printer (the manual feed tray). I can change this when I manually print and select printer, but it seems to want to default to tray 1. This is not the Windows default.

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 23:12

Joined

Jul 9, 2003

Messages

16,280

• Nov 30, 2017

• #2

See this Blog by Allen Browne

http://allenbrowne.com/AppPrintMgtCode.html

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 23:12

Joined

Jul 9, 2003

Messages

16,280

• Nov 30, 2017

• #3

And Daniel Pineault's Blog HERE:-

https://www.devhut.net/2011/05/26/ms-access-vba-set-report-to-use-default-printer/

 

J

JHB

Have been here a while

Local time

Tomorrow, 00:12

Joined

Jun 17, 2012

Messages

7,732

• Dec 1, 2017

• #4

If all the other reports print out without your problem then, open the report in design view, move a control fort and back again, (so that it as for saving the report when you close it), then view the report in Print Preview, print it out, save and close it.
Else create a new report and copy all to it.