Access 2007 wont save specific printer
Posted on 2007-10-18
Access 2007 wont save specific printer. I think its a bug with 2007 and I wish I wouldnt have upgraded but to late now. How do I get around this. Here is the VB code for the button that I want to automaticly print 3 reports:
Private Sub Command162_DblClick(Cancel As Integer)
Dim stDocBOADeposit55 As String
stDocBOADeposit55 = "US Deposit Page 1"
DoCmd.OpenReport stDocBOADeposit55, acNormal
Dim stDocBOADeposit56 As String
stDocBOADeposit56 = "US Deposit Page 2"
DoCmd.OpenReport stDocBOADeposit56, acNormal
Dim stDocBOADeposit57 As String
stDocBOADeposit57 = "US Deposit Page 3"
DoCmd.OpenReport stDocBOADeposit57, acNormal
Is it best to change default printer to what I want and then back? Can I choose the printer with VB? What is the best work around. havent had much traning in VB so the more you can explain the better. Thanks much.
P.S. If I ever see Bill Gates I will kick him in the nutts for this.