I'm using Access to print books and I would like to serialize (have a serial number) for each book printed.
20 books or so maybe printed at any one time.
I have two tables, one with the book details and the other with the records. The next serial number for that series of books would be stored in the book details table.
The serial number should print in the footer of each page
so I figure that an OnPrint event should be used.
I can't find anywhere if the OnPrint event is reset for each copy of a report that's printed or whether it applies for the whole time the report is open for that session.
I'm alright with the vba code required (I Think) just not where to include it.
TIA
Howard
20 books or so maybe printed at any one time.
I have two tables, one with the book details and the other with the records. The next serial number for that series of books would be stored in the book details table.
The serial number should print in the footer of each page
so I figure that an OnPrint event should be used.
I can't find anywhere if the OnPrint event is reset for each copy of a report that's printed or whether it applies for the whole time the report is open for that session.
I'm alright with the vba code required (I Think) just not where to include it.
TIA
Howard