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

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

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

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