getting printer settings for access form

  • Thread starter Thread starter Z.K.
  • Start date Start date
Z

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
 
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"
 
Back
Top