If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Specific printer - Access 2007
I have a report that needs a specific printer, only available from one PC.
The solutions I see here allow selecting the printer, but the printer returns to the default printer if you every go to design view with the report or in some cases design view with any report in the database. I would prefer to hard code the printer and margins where they can not possibly change. The default printer would need to work for other reports. I not a VB person. Is there code that could be added to a property or event that is already published that would accomplish this. Thanks |
#2
|
|||
|
|||
Specific printer - Access 2007
Hi Jim,
Am I having a deja vu or did you not post this question earlier? well just a quote from the Allen Browne reply on that question earlier... ------------ If it's any help, there is a way to create a custom property for the report to hold the printer name you want it to print to. You then set the Printer object before opening the report, and reset it afterwards. You can copy the code to do this from the sample database in this article: Printer Selection Utility - Users assign printers to reports at: http://allenbrowne.com/AppPrintMgt.html hth -- Maurice Ausum "Jim S" wrote: I have a report that needs a specific printer, only available from one PC. The solutions I see here allow selecting the printer, but the printer returns to the default printer if you every go to design view with the report or in some cases design view with any report in the database. I would prefer to hard code the printer and margins where they can not possibly change. The default printer would need to work for other reports. I not a VB person. Is there code that could be added to a property or event that is already published that would accomplish this. Thanks |
#3
|
|||
|
|||
Specific printer - Access 2007
I did post the question, but thought I might not have adequately explained
that the printer never needs to change for this series of reports. We do have to go back into the report and make design changes though. I have used Allen's module and toolbar if this is what you are refering too. It works to get the correct printer to stay with the report - as long as you don't view it in design view or anyother report that used that printer in design view. If I do use design veiew, I have to reset the printer and the margins on each report. Am I missing something? Thanks "Maurice" wrote: Hi Jim, Am I having a deja vu or did you not post this question earlier? well just a quote from the Allen Browne reply on that question earlier... ------------ If it's any help, there is a way to create a custom property for the report to hold the printer name you want it to print to. You then set the Printer object before opening the report, and reset it afterwards. You can copy the code to do this from the sample database in this article: Printer Selection Utility - Users assign printers to reports at: http://allenbrowne.com/AppPrintMgt.html hth -- Maurice Ausum "Jim S" wrote: I have a report that needs a specific printer, only available from one PC. The solutions I see here allow selecting the printer, but the printer returns to the default printer if you every go to design view with the report or in some cases design view with any report in the database. I would prefer to hard code the printer and margins where they can not possibly change. The default printer would need to work for other reports. I not a VB person. Is there code that could be added to a property or event that is already published that would accomplish this. Thanks |
#4
|
|||
|
|||
Specific printer - Access 2007
Hi Jim,
i get your point. But to my knowledge this bug isn't fixed yet. So coding according to the KB-article or using Allen's module seems to be the only workaround as of this moment. -- Maurice Ausum "Jim S" wrote: I did post the question, but thought I might not have adequately explained that the printer never needs to change for this series of reports. We do have to go back into the report and make design changes though. I have used Allen's module and toolbar if this is what you are refering too. It works to get the correct printer to stay with the report - as long as you don't view it in design view or anyother report that used that printer in design view. If I do use design veiew, I have to reset the printer and the margins on each report. Am I missing something? Thanks "Maurice" wrote: Hi Jim, Am I having a deja vu or did you not post this question earlier? well just a quote from the Allen Browne reply on that question earlier... ------------ If it's any help, there is a way to create a custom property for the report to hold the printer name you want it to print to. You then set the Printer object before opening the report, and reset it afterwards. You can copy the code to do this from the sample database in this article: Printer Selection Utility - Users assign printers to reports at: http://allenbrowne.com/AppPrintMgt.html hth -- Maurice Ausum "Jim S" wrote: I have a report that needs a specific printer, only available from one PC. The solutions I see here allow selecting the printer, but the printer returns to the default printer if you every go to design view with the report or in some cases design view with any report in the database. I would prefer to hard code the printer and margins where they can not possibly change. The default printer would need to work for other reports. I not a VB person. Is there code that could be added to a property or event that is already published that would accomplish this. Thanks |
Thread Tools | |
Display Modes | |
|
|