Fastest way to print large data

[Isaac]

@Hello1
You said you 'came across this thread' but as you started the thread that's rather odd!

I thought it was a reference to the thread link posted directly after that sentence?

 

[isladogs]

Possibly?

 

[Hello1]

I thought it was a reference to the thread link posted directly after that sentence?

It was, sorry for the confusion. Could have wrote it more precisely but its been a long day

 

[Isaac]

Anything you do with a vba code loop will be slower than an optimized internal Access function.
If you didn't take these measurements, how will you know that your latest "solution" which requires the expense of preprinted forms, will be faster?

Rendering & printing of 100% of a typically designed Access report, faster than using for Output/Print on the pure text results of a query?
Have to admit I've never compared these two things directly, but would be curious ..

 

[Hello1]

Anything you do with a vba code loop will be slower than an optimized internal Access function.

You never told us how long it takes to print a report with all the graphics.
You never told us how long it takes to print a report with just the text.

If you didn't take these measurements, how will you know that your latest "solution" which requires the expense of preprinted forms, will be faster?

I didnt have the chance to compare yet. Its not that I want to go with pre-printed forms but I have to
Once I manage to complete the Output/Print procedure I will compare one to another in terms of speed.
I had some success with a program called Printfil after sharing my printer and using Net Use LPT1 \\YourPrinterServer\ShareNameForTheOKI, in VBA I use Open "LPT1:" For Output As #1 and it prints one page, however not all of them.
DOSPrinter performed much faster, however, I didnt manage get to print with it directly from VBA, only CMD and the program itself. In CMD I cant figure how to define code page for eastern europe because of special characters like šđčćž...
I will try tonight to do some more researching