getting printer settings for access form

[Z.K.]

I was wondering if anyone could tell me or point me to a website where I
could find out how to get the printer settings for an access form. What
I want to do is select a print report button which would then bring up a
print dialog for changing which printers to print to and other print
settings. Oh, I am using Access 2000. I found some code for Access
2003 using a printer object, but it does not seem to be available in
Access 2000.

Roger

 

[Albert D. Kallal]

If you are just rying to pop up the printer dialog box..then you can do that
with:

On Error Resume Next
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.RunCommand acCmdPrint

I have a nice working reprot with a buttion ON THE reprot that pops up the
printer dialog box here you can try:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm


Garb the 3rd example from the above "ms-access interface hidden"