EXP Systems Forum: Some reports do not convert

Message

   Hello Michel,

I'm using the latest Pro version with MS Access. Using the same code, taken from the sample, following the same path, some reports convert to PDF, some go directly to print (not the default printer).

The report definitions are nearly identical. Using the report definition of one report that did print, I used the data from one that did not... the report still printed.

I now believe that the problem lay in the report definition, but cannot imagine what would influence the PDF creation as the Application.Printer remains the same in both cases.

I'm fairly new to Access and VBA, but the code is well documented. There are no surprises or alternate paths taken from one report to the other.

Any thoughts on this?

Ron.

Author	Message
RAM1 Newbie Joined: 18 Jun 09 Location: United States Posts: 1	Topic: Some reports do not convert Posted: 18 Jun 09 at 7:33PM
	Hello Michel, I'm using the latest Pro version with MS Access. Using the same code, taken from the sample, following the same path, some reports convert to PDF, some go directly to print (not the default printer). The report definitions are nearly identical. Using the report definition of one report that did print, I used the data from one that did not... the report still printed. I now believe that the problem lay in the report definition, but cannot imagine what would influence the PDF creation as the Application.Printer remains the same in both cases. I'm fairly new to Access and VBA, but the code is well documented. There are no surprises or alternate paths taken from one report to the other. Any thoughts on this? Ron.
	IP Logged

Michel_K17 Moderator Group Forum Administrator Joined: 25 Jan 03 Posts: 1673	Posted: 19 Jun 09 at 12:09AM
	Hi Ron, The only thing that comes to mind (a shot in the dark really) might be that setting the default printer might take some time to "take". Therefore, you could try to add a short pause (I'd say 100 ms as a good start) after changing the default printer before sending the print job to PDF reDirect or the PDF batch printer. Hopefully this will work.
	Michel Korwin-Szymanowski EXP Systems LLC
	IP Logged

Programming
EXP Systems Forum : PDF reDirect : Programming