Print form to specific printer

[Sean]

I have an Access 2002 database shared over a network. The
forms always revert back to the default printer and
margin settings. I have updated office 2002 and followed
previous intructions on setting up Office in order to
prevent this problem with no luck.

I would like to use a command button to print a form to a
specific printer over a network, is this possible and if
so what VB Script would I use.

Many Thanks,

Sean

 

[Brian]

I have an Access 2002 database shared over a network. The
forms always revert back to the default printer and
margin settings. I have updated office 2002 and followed
previous intructions on setting up Office in order to
prevent this problem with no luck.

I would like to use a command button to print a form to a
specific printer over a network, is this possible and if
so what VB Script would I use.

Many Thanks,

Sean

In Page Setup for the report, you need to change from "Default Printer" to
"Use Specific Printer". This change is not permanently made if you merely
choose a different printer in the Print dialog box: to make it stick, you
need to go into Page Setup and make the change explicitly.