Print report to specific printer using VB

[Jahappz]

I have 1 report and i want to have 2 buttons that:

Button 1 prints report to default printer
Button 2 prints report to specific printer (PDF Writer)

I dont want to copy the report and change the properties to the printers. Is there any way to specify the printer user VB behind the button?

 

[Remou]

Yes, but how to do this depends on the version of Access you are using.

http://support.microsoft.com/?id=129397

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vb98/html/vbobjPrinter.asp

 

[Jahappz]

I am using Microsoft Access 2000

 

[Remou]

You can get more information here:

http://www.mvps.org/access/reports/rpt0009.htm

 

[Jahappz]

Didnt really get it how i should use that function can you provide me with some sample code? that has 2 buttons and 1 report ?

 

[Jahappz]

The function works but when you change back to the standard printer it wont change until you restart Access, anyone got any input on work-arounds for that?