Bank passbook printing

[evander]

I guess it's been a few months since the last time I was in this forum... I'm not sure if I should post this thread here, or in programming, or somewhere else, but basically my problem focuses on printing.

I want to know how Access can be programmed to print data on a bank passbook, which will be periodically "updated," meaning new data will be printed on it. Access will have to tell the printer to start printing at a certain position (or line number). I found this sample passbook using Google. It looks like a passbook issued by a cooperative or association, and is manually filled out.



http://www.google.com.ph/imgres?imgu...ed=0CDoQ9QEwBA

Hoping to get a response.
Thanks!

[goodguy]

In your db, every time you update the passbook, save the id of the last transaction and the passbook's last line position. Next time, you simply fetch the transactions records that follow and format them to start printing at the next line position. Add code to roll over new pages.

[evander]

Thanks replying goodguy!
One more question, how do I tell the printer to do this: "Add code to roll over new pages."

[goodguy]

While you are keeping count of the line number during printing, when the maximum lines per page is reached, what do you tell the printer? You stop the printing briefly and prompt the user to remove the passbook and turn to new page and insert it back into the printer. Then you tell the printer to continue printing and reset the line number to 1.