How to solve a menubar problem

[Flippertje]

I'm trying to build a menu with a button that does:

1. select a specific printer (PDFWriter)
2. print a specific report
3. set the printer back to the original printer

Is this possible? I've trying for days and can't get it to work! I've been close (i think) by trying to point the menubutton to a macro but i couldn't get a macro to these things....

Anyone??

MaNNNNNNNYYY thanks,

Flippertje!

 

[mp9]

In Access 2002 and above, the following VBA may get you started.

'Declare a printer variable
Dim prt As Printer
'Set it to current default printer
Set prt = Application.Printer
'Change to PDF print queue
Application.Printer = Application.Printers("PathToPDFWriterHere")
'Your code to print here
'Set default back to original printer
Application.Printer = prt

http://www22.brinkster.com/accessory/

 

[Flippertje]

Thank you for you're help!
The code in VBA i have but the means to 'hang' this code at a button on a menubar is missing....

Can you help me here?

Tnx Flippertje !