I always have the same issue here and am wondering if anybody else does. I use adobe to print my reports to for ease of sharing with customers, and looking professional while doin it. The code i have sets the default printer to the "Adobe PDF" then commences printing. Since i set the name of the file on format, i have to actaully open the report in preview mode with
Then i use
to print the report and then close.
All of this is done on a remote desktop (that matters in just a second). Here is the problem.
Everytime i first login to the remote, open access and print....Access hangs up, until i close acrotray.exe from processes, then it will continue printing the reports....norm ally(the way they were intended to print). If i try to print again, i have to do the same thing again.
My other option to finish printing is to actaully close Access (of course the prompt to repair the database...then tell microsoft about it). Once i do this, i can print anything just fine to Adobe, without any freezing, multiple times (this is the method i end up using, since it will print fine afterwards), until i log out of the remote, and log back in, so everyday, there is at least one lockup.
If anybody has come across this, or even has an idea about what to try i would be very greatful. Thanks in advance.
By the way, i have searched google, and cant seem to find even 1 relevant result.
Code:
acViewPreview
Code:
DoCmd.PrintOut DoCmd.Close
All of this is done on a remote desktop (that matters in just a second). Here is the problem.
Everytime i first login to the remote, open access and print....Access hangs up, until i close acrotray.exe from processes, then it will continue printing the reports....norm ally(the way they were intended to print). If i try to print again, i have to do the same thing again.
My other option to finish printing is to actaully close Access (of course the prompt to repair the database...then tell microsoft about it). Once i do this, i can print anything just fine to Adobe, without any freezing, multiple times (this is the method i end up using, since it will print fine afterwards), until i log out of the remote, and log back in, so everyday, there is at least one lockup.
If anybody has come across this, or even has an idea about what to try i would be very greatful. Thanks in advance.
By the way, i have searched google, and cant seem to find even 1 relevant result.
Comment