I imagine there are a few ways to do this, but hopefully someone can help me with a simple one.
Can I create a temporary recordset or array (I know nothing about arrays, but found them mentioned on searches on this subject) which allows me to record a page number for each record, and then run a code loop that uses each page number as a variable?
Background:
I need the code to go through a recordset and make a note of all the corresponding records in another table that need to be acted on; however, they can only be acted on once.
For example, imagine a book with dynamic content. Each word is a record, and I have have to replace two words on page 5, one word on page 6 and three words on page 11. I need to reprint pages 5, 6 and 11, so I have to print 3 pages from six records.
It is preferable for me to have all the pages figured out and then call the code to execute the action. Lastly, it is not preferable to create and delete tables in the database.
I need the code to go through a recordset and make a note of all the corresponding records in another table that need to be acted on; however, they can only be acted on once.
For example, imagine a book with dynamic content. Each word is a record, and I have have to replace two words on page 5, one word on page 6 and three words on page 11. I need to reprint pages 5, 6 and 11, so I have to print 3 pages from six records.
It is preferable for me to have all the pages figured out and then call the code to execute the action. Lastly, it is not preferable to create and delete tables in the database.
Can I create a temporary recordset or array (I know nothing about arrays, but found them mentioned on searches on this subject) which allows me to record a page number for each record, and then run a code loop that uses each page number as a variable?
