Print more pages in vb.net 2005

Question

I know this subject has been written about before but I still cant get a solution to my problem.  It is the proverbial problem of printing a second, third and more pages.  And I know the answer has to do with e.hasmorepages but I cant see where to put it in my code.  Can u help please.

I have a file which is similar to a csv file with 40 fields.  Each of the fields needs to be printed in columns and rows and when I print it looks like a spreadsheet.  WHen the page is full i need to throw a new page and continue until I reach the file end.  The analysis of the the file is quite complex.  One of the fields out of the 40 can contain in its own right 40 fields which also can produce rows on my spreadsheet. 

The known factor and crucial issued is when I reach an Ypos (vertical) position of about 1000 on the page i want to start a new page.  This is what i have done so far but either get indefinate pages which never starts to print or one page which continues to overlap the text for page 2, 3, 4 etc.

I have attached my code and a printout of what i achieve when printing :) 

I'd appreciate someones solution

Richard 

 

 

 

 

 

 

Answer 1

thanks
i figured out the problem
i had to change the select the database and change the copy always option to
copy only when new ...
and it s working fine now!!

Answer 2

If you could show the code that you are using it would be a lot easier to determine what might be wrong.