AndyShuter
Registered User.
- Local time
- Today, 21:10
- Joined
- Mar 3, 2003
- Messages
- 151
I have just installed a database on a Network supported by a server. The network has 3 printers. In order to select which printer to use, I am using the following command in Visual Basic...
Dim prtDefault As Printer
Set Application.Printer = Application.Printers(2)
Set prtDefault = Application.Printer
Dim stDocName As String
stDocName = "rptSentToSub"
DoCmd.OpenReport stDocName, acNormal
DoCmd.Close acForm, "dialoguebox1"
...So, as you can see, the command uses INDEXING to decide which printer to send the report to.
However, One of the printers (A Samsung ML1480 - very modern one as well) doesn't pick up when I try to send to it.
I've also tried identifying the printer by it's name and that doesn't work either.
Do i need a special piece of printer driver software to make this work? I've tried printing through other Office applications and it works fine.
Also I would be exteremely grateful for any other network printing suggestions - for example allowing the user to select his /her own printer everytime they print
Hope this makes sense
Regards
Andy
Dim prtDefault As Printer
Set Application.Printer = Application.Printers(2)
Set prtDefault = Application.Printer
Dim stDocName As String
stDocName = "rptSentToSub"
DoCmd.OpenReport stDocName, acNormal
DoCmd.Close acForm, "dialoguebox1"
...So, as you can see, the command uses INDEXING to decide which printer to send the report to.
However, One of the printers (A Samsung ML1480 - very modern one as well) doesn't pick up when I try to send to it.
I've also tried identifying the printer by it's name and that doesn't work either.
Do i need a special piece of printer driver software to make this work? I've tried printing through other Office applications and it works fine.
Also I would be exteremely grateful for any other network printing suggestions - for example allowing the user to select his /her own printer everytime they print
Hope this makes sense
Regards
Andy
