Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / November 2007

Tip: Looking for answers? Try searching our database.

OpenReport action cancelled because of Printer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AllenB - 31 Oct 2007 01:11 GMT
What is the issue when Access cancels an OpenReport action based on a
particular (default) printer? If the selected printer is changed, such as
default to Adobe Acrobat, reports open properly.

I know I can manually change the printer on my computer but I'm concerned
about proper functioning of a deployed database.  Is there a way to manage
this without programmatically changing a user's prnter? Thank you.

AllenB
Allen Browne - 31 Oct 2007 12:08 GMT
Open the report in design view. Go to Page Setup, and change middle tab so
that it uses the Default Printer (not a Specific Printer.) The report will
then format for whatever printer the user has, as long as they have some
valide printer driver installed.

If you need to programmaticallly change the printer, in Access 2002 and
later you can set the Printer object before you open the report. If you want
to offer the user to have the report remember to go to one of their
printers, see:
   Printer Selection Utility - Users assign printers to reports
at:
   http://allenbrowne.com/AppPrintMgt.html

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> What is the issue when Access cancels an OpenReport action based on a
> particular (default) printer? If the selected printer is changed, such as
[quoted text clipped - 5 lines]
>
> AllenB
AllenB - 31 Oct 2007 15:07 GMT
Thank you Allen.  I tried your solution, found the default printer option
already selected, and had no success in cycling the settings.  

I believethe issue is what consititutes a 'valid' printer.  For example, my
installation of HP Laserjet 1020 does not allow report previews in MS Access.
If the default printer is Quicken PDF, however, the report previews
properly.  Interestingly I , by Quicken's design, cant use that Quicken PDF
printer except from within Quicken.  In the Quicken case, the report views
valid but printing isnt valid.  In the HP Laserjet 1020 case, I cant preview
reports but I can print them (if an alternate printer is set as the defalt
which allows OpenReport actions).

Are there specific printer settings or characteristics that prevent its
'valid' use in previewing MS Access report?  I truly appreciate your help.

AlenB

> Open the report in design view. Go to Page Setup, and change middle tab so
> that it uses the Default Printer (not a Specific Printer.) The report will
[quoted text clipped - 18 lines]
> >
> > AllenB
Allen Browne - 31 Oct 2007 15:34 GMT
I am not familiar with printer drivers that have the limitations you
describe.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thank you Allen.  I tried your solution, found the default printer option
> already selected, and had no success in cycling the settings.
[quoted text clipped - 43 lines]
>> > manage
>> > this without programmatically changing a user's prnter? Thank you.
KitCaz - 31 Oct 2007 18:49 GMT
Allen, thanks for providing the link to your awesome set printer utility!

I had a couple of hurdles:

1) for whatever reason, setting my report toolbars to 'ReportToolbar' caused
an error and I wasn't able to get the menu item onto any toolbar.  I worked
around this by just putting a checkbox on my application form that the user
can tick off before they hit 'Preview' which will set the desired prompt.

2) I found that when I allowed frmSetPrinter to open and I didn't change the
printer (I just clicked 'OK' with the 'use default printer' selection, I
received an error in the line of code that tries to delete the "Printer2Use"
property because it doesn't exist.  I wrote a condition in the error logic to
skip the error message if the err.number was equal to 3265, so I covered this.

Although I'm pretty much ok, I'm just telling you this In case I did
something wrong in the way I installed this.  It's an awesome set of code,
though, so THANK YOU!

Chris

> Open the report in design view. Go to Page Setup, and change middle tab so
> that it uses the Default Printer (not a Specific Printer.) The report will
[quoted text clipped - 18 lines]
> >
> > AllenB
Allen Browne - 01 Nov 2007 01:41 GMT
Thanks for the feedback.

Re issue 1:
You should be able to import the toolbar from the sample database with:
   File | Get External | Import
After selecting the file, click the Options button in the Import dialog.
Then click the Menus And Toolbars box.

Re issue 2:
Thanks: have adjusted the code so it calls HasProperty() before attempting
to delete the property.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Allen, thanks for providing the link to your awesome set printer utility!
>
[quoted text clipped - 50 lines]
>> > manage
>> > this without programmatically changing a user's prnter? Thank you.
Bernie - 01 Nov 2007 00:41 GMT
I believe I have the same problem. see 'Reports won't open. Please Help'
31/10/07 in this news group. 'DoCmd.OpenReport ....' fails in code and all
other means of opening a report fails including Design. Since the same
reports have worked with the same printer and setup previously, there  must
be a solution. Have you just reinstalled something?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.