[AccessD] I must have angered the Printer gods

[Brad Marks]

John,

Thank You, Thank You, Thank You.

You were right on target.  I was not familiar with this setting.  I am not sure how it got changed, but it is now fixed.

WOW!!! - The Printer Mystery solved and the Cubbies won the World Series  - Outstanding Week!

Brad 
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bodin
Sent: Friday, November 04, 2016 8:54 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] I must have angered the Printer gods

If you edit the report and go into the page layout properties, is the Sales Dept printer the default printer instead of the generic Default Printer option?  I've had report changes and testing to Adobe PDF only to find out once I saved it, it made my Adobe the default printer and users kept getting errors when printing.  May not be your issue, but along the same lines.  -hth






John Bodin

sBOR Office Systems

jbodin at sbor.com<mailto:jbodin at sbor.com>




________________________________
From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of Brad Marks <bradm at blackforestltd.com>
Sent: Friday, November 4, 2016 9:41 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] I must have angered the Printer gods

All,

Yesterday, our accountant asked for a minor change to report (Access 2007).

I made the requested change and ran some tests by printing the report.  I used a printer that is in our Sales department.

This morning, when our accountant printed the report, it was printed on the Sales department printer instead of the Accounting department printer.

He then called me and together, we opened the report and then printed it by selecting the Accounting department printer.  Again, it printed on the Sales department printer in spite of the fact that we had explicitly selected the Accounting department printer.  I could not believe this and tried it two more times and sure enough, the report continued to print on the wrong printer.

I then tried the exact same steps on my PC and things worked properly.

I have never seen this happen before.

The strange thing is that this problem did not occur until after I have made some minor cosmetic changes to the report.  None of the changes that I made, had anything to do with the printer, other than the fact that I used a different printer for one of my tests.

Any ideas on why this problem has surfaced?

Is there a way to "force" an Access report to a specific printer (with no user intervention)?

Thanks,
Brad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com