Hi!
I have aproblem with print dialog!
To be more specific I want to create a button which I can print but at first to select with which printer to use because I have 3 printers!

I am not sure how to do that, but you can poll the printers, display them on a form, give the user a button to click to select the printer, change that printer to the default, print the item, and then change the original default printer back to the default.

If someone can't help you with this solution, let me know if you want to use my method.



mmcdonal

The solution may have to do with custom toolbar buttons.

mmcdonal

You can place following line of code in OnClick event of your command button that you will place on the form to view the report.
Let us say your printing report "A".
Then code will be

   Dim stDocName As String

    stDocName = "A"
    DoCmd.OpenReport stDocName, acPreview

    DoCmd.RunCommand acCmdPrint

Along with the preview of your report, this will open a print dialog box to let you choose the printer. You might not be able to see the contents of the report (may be blank page at first look) but it should print the data when you click OK button of print dialog.

Off course you must include the error handler.

HTH

Regards,
Ashfaque

chec out:

ACC: How to Change a Report's Printer Using Code
http://support.microsoft.com/?id=129397

and

How to use code to change a report's printer in Access
http://support.microsoft.com/default...b;en-us;208840

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com