Printer choice

[geraintthomas]

Hello,

I am using a database report with print button.
The database is used at different sites by numerous users who use different printers.

Unfortunately the reports all print on the same printer.
I have used the following code:

Private Sub Command14_Click()



On Error Resume Next

DoCmd.OpenReport "MRCD No End", acPreview


DoCmd.SelectObject acReport, "MRCD No End"
DoCmd.RunCommand acCmdPrint
If Err.Number <> 0 And Err.Number <> 2501 Then
MsgBox Err.Number & ":" & Err.Description, vbCritical
End If


End Sub

as discribed in a prev thread. This works, though does not follow the printer I choose.......
Please help

 

[Jibbadiah]

In page set-up menu the user can choose to select a specific printer and then select from a drop-down of existing printers on their network.

If you are disabling the ability to use the default shortcuts, then you can add this button to your own toolbar and allow them to use it.

Show them where this is... it shouldn't be too hard for them to understand.

If you hard-code a printer in vb you are putting yourself in the tricky situation of not being able to swap if that specific printer has problems.

J.

 

[geraintthomas]

Hi J,

Cheers, have adjusted the settings not to use specified but default and tested, all fine now.

Have a good weekend