I have VBA code to set printer to duplex print a report if the user's default printer is a particular brand. This code worked for years under Windows XP and Access 2007. Several months ago upgraded everyone to Windows 7 and Access 2010 and the code no longer works. Weirdness is one user is sure this worked for him just last week and db records support that - regardless, it isn't working for anyone to any printer now. More weirdness - code to select printer bin still works. Also, the duplexing constants are still recognized by VBA. I have debugged and confirm the code executes. I have tried printer power off/on.
The code is simply:
If strPrinter Like "*Konica*" Then Reports(strReport).Printer.Duplex = acPRDPHorizontal
...
If strPrinter Like "*Konica*" Then Reports(strReport).Printer.Duplex = acPRDPSimplex
Before I try Windows API code from http://support.microsoft.com/kb/230743, wondering if anyone else has had similar experience and found a simpler solution.
My research indicates this is an issue across the MS Office Suite starting with 2010. However, this thread indicates to me that my code should still work http://answers.microsoft.com/en-us/o...7-4e65b4f09645.
This is the only issue I have encountered with the upgrades and really sucks!