P
Posted27thSept
I am trying to give my users complete control of printer
selection and settings paper source, paper size,
orientation, duplex printing) for forms and reports of my
Access 2000 MDE database. I have reasearched into DEVMODE
and DEVNAMES but I understand they must be used in design
view and can't be used in an MDE file. I found "On the
Fly Pinting"
(http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm) but it does not support printer settings
for MDE files. I found the following link:
http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm which shows code for changing the printer
but not the settings. I am planning to link an MDB file
located on each computer's local drive to the main MDE
file so the user can specify the printer and settings he
wants on that machine. When each report is printed, the
table in the MDB file is looked up and the printer is
selected and settings set. Or the user can click another
button if he wants to change the printer or settings for
one printing. Any suggestions are requested.
selection and settings paper source, paper size,
orientation, duplex printing) for forms and reports of my
Access 2000 MDE database. I have reasearched into DEVMODE
and DEVNAMES but I understand they must be used in design
view and can't be used in an MDE file. I found "On the
Fly Pinting"
(http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm) but it does not support printer settings
for MDE files. I found the following link:
http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm which shows code for changing the printer
but not the settings. I am planning to link an MDB file
located on each computer's local drive to the main MDE
file so the user can specify the printer and settings he
wants on that machine. When each report is printed, the
table in the MDB file is looked up and the printer is
selected and settings set. Or the user can click another
button if he wants to change the printer or settings for
one printing. Any suggestions are requested.