I'm using Access 2003 with connectivity to an SQL server. My question is, when I create an ADE from my ADP it appears that users can not save settings for printers. In particular I need a user to set a specific printer and have that printer never change for that report. The problem: access reverts back to the orginal printer after printing the report. Is there a way around this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Printers in ADE
- Thread starter RichM1
- Start date
- Thread starter
- #2
ADE (and MDE) do not allow changes to report settings which are where the printer is stored - in design you can set a specific printer or let it choose the default printer.
I have seen some code somewhere that allows you to set the printer at run-time therefore I guess if you can load the printer name against a specific user it would work. Shall I go hunting for it?
I have seen some code somewhere that allows you to set the printer at run-time therefore I guess if you can load the printer name against a specific user it would work. Shall I go hunting for it?
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question