P
Parr8Head
Hello,
I've recently inherited an Access 2003 application that is now causing one
user some issues. When printing a report as a PDF, the application loops
through the user's printers to see if Acrobat 5 (yes, I know...) is
installed. If so, it sets the default printer to the PDF writer and prints.
The loop begins as such:
For printCount = 0 To Application.Printers.Count
Set Application.Printer = Application.Printers(printCount)
I've narrowed the problem down to the "Set Application.Printer..." line. The
first time that line is called the application hangs for approximately 1
minute. Each additional iteration it is able to hit that line without a
problem. This is only happening for 1 user and, according to the user, the
problem only cropped up a few weeks ago and the user claims no changes were
made to his machine. Any ideas on what could be causing it? I'm trying to
avoid any major code changes as this works for all other users and I'm
pushing to have the application rewritten as a web app.
Thanks so much in advance.
I've recently inherited an Access 2003 application that is now causing one
user some issues. When printing a report as a PDF, the application loops
through the user's printers to see if Acrobat 5 (yes, I know...) is
installed. If so, it sets the default printer to the PDF writer and prints.
The loop begins as such:
For printCount = 0 To Application.Printers.Count
Set Application.Printer = Application.Printers(printCount)
I've narrowed the problem down to the "Set Application.Printer..." line. The
first time that line is called the application hangs for approximately 1
minute. Each additional iteration it is able to hit that line without a
problem. This is only happening for 1 user and, according to the user, the
problem only cropped up a few weeks ago and the user claims no changes were
made to his machine. Any ideas on what could be causing it? I'm trying to
avoid any major code changes as this works for all other users and I'm
pushing to have the application rewritten as a web app.
Thanks so much in advance.