I have a database with a mail label printer and another printer attached to the computer. I would like the user to hit the command button for each of the printers and have the selected data printed without having to select which printer to use each time. I don't know programming. Can any one...
Does not even go to the default. Dialogue box opens. Each printer is there listed, even the old ones that are no longer linked to the printer, but which the command button was printing from before. Thank you.
Dear Paul,
Thanks so much for your help. Below is the code on the command button. Again, I did not do this. I don't know code. :(
Private Sub Command45_Click()
On Error GoTo Err_Command45_Click
Dim stDocName As String
stDocName = "Bottle Labels"
DoCmd.OpenReport stDocName, acNormal...
Dear PBaldy,
Thanks for the reply. I have tried that, but every time that I am ready to print, the print dialogue box opens up again asking for which printer to select. Before, it just used to print directly to the printer that the command button on my form was set to. Crazy thing is when I...
How can I automate different printers for different reports on the same MS Access 2007 database, without having to select the printer each time?
There are two reports that are printed on the same database. Previously, I had automated form buttons to print the reports, without having to select...