T
tina
hi folks,
using A97. here's the scenario: i have an Excel worksheet which is printed
out as a blank form with lines in columns, which is filled in by hand (don't
ask). the leftmost and middle columns are pre-filled with sequential numbers
calculated in the spreadsheet so that on the first printed page you see
numbers 1 - 20 in the left column, 21 - 40 in the middle column; second page
41 - 60 in the left column and 61 - 80 in the middle column, and so on...for
however many pages are printed. to advance the numeric sequence at the next
printing, i open the spreadsheet, look at the very last number in middle
column, for instance 200, then go back to the very top of the first column,
type in 201 and exit the cell, at which point the rest of the values
automatically increment up to 400.
i want to move this setup into Access. now i know that i can create a table
to hold temporary records, use a VBA loop to populate the table 1 - 200, and
bind a report to the table to print out the format i want. then delete all
the records from the table, storing only the highest number, and at the next
printing i can repopulate the table incremented from the stored high number,
and print again, etc, etc.
here's the question: is there some way to build a *virtual* recordset to
base the report on, so that i can store the high value only and avoid
appending/deleting records from a "real" table at each printing?
all comments and suggestions are appreciated.
tia, tina
using A97. here's the scenario: i have an Excel worksheet which is printed
out as a blank form with lines in columns, which is filled in by hand (don't
ask). the leftmost and middle columns are pre-filled with sequential numbers
calculated in the spreadsheet so that on the first printed page you see
numbers 1 - 20 in the left column, 21 - 40 in the middle column; second page
41 - 60 in the left column and 61 - 80 in the middle column, and so on...for
however many pages are printed. to advance the numeric sequence at the next
printing, i open the spreadsheet, look at the very last number in middle
column, for instance 200, then go back to the very top of the first column,
type in 201 and exit the cell, at which point the rest of the values
automatically increment up to 400.
i want to move this setup into Access. now i know that i can create a table
to hold temporary records, use a VBA loop to populate the table 1 - 200, and
bind a report to the table to print out the format i want. then delete all
the records from the table, storing only the highest number, and at the next
printing i can repopulate the table incremented from the stored high number,
and print again, etc, etc.
here's the question: is there some way to build a *virtual* recordset to
base the report on, so that i can store the high value only and avoid
appending/deleting records from a "real" table at each printing?
all comments and suggestions are appreciated.
tia, tina