General discussion

Locked

Access XP Print Control

By MSchulman ·
I need to modify a command button to print to a specific network printer. It currently prints directly to the user's default printer. I believe I have to modify the event code, but I'm not sure how.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access XP Print Control

by kees.valkenswaard In reply to Access XP Print Control

You did not specify from where you want to print. Suppose it is from Word or another Office program. In that case you would have to record a simple macro in which you switch to the required printer [so make sure another printer is set before you start the new macro] and subsequently print. Make the macro part of e.g. normal.dot [when using Word]. Add a button [with Tools, customize] to which you connect the new macro. That is it.
You may which to add another button for the default user printer, as after hitting your special button other documents within the same session would be printed on the same printer.
Good luck.

Collapse -

Access XP Print Control

by MSchulman In reply to Access XP Print Control

The title is "Access XP Print Control". I need to modify a command button on an existing form to print a report in Access that currently prints only to the default printer.

Collapse -

Access XP Print Control

by JackOfAllTech In reply to Access XP Print Control

On the assumption you're only asking how to get into the code, open the form in design mode and double-click on the command button in question.

If you're asking for the code itself, I'll need a LOT more info. Send me a copy of the current event code, and the name of the network printer you want to use and I might be able to help you.

Ralph

Collapse -

Access XP Print Control

by MSchulman In reply to Access XP Print Control

Poster rated this answer

Collapse -

Access XP Print Control

by saqibmabbasi In reply to Access XP Print Control

Hello,
you can use the following command in the click event of the CommandButton on the form in an Access database.

CODE:
DoCmd.OpenReport strReportName, strPrinterName

here
strReportName = this is the name of the Report.
strPrinterName = this is the name of the Printer.

you can even specify other printers in a list ad select your desired printer. to do this use the Printer Object.

hope this helps.
Take care.

Collapse -

Access XP Print Control

by MSchulman In reply to Access XP Print Control

Poster rated this answer

Collapse -

Access XP Print Control

by MSchulman In reply to Access XP Print Control

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums