Set print flag to "Yes" if record has ever printed 1

[jeffmorl]

I have an Access db form that collects workers hours, work order numbers, dates, etc. as well as an internal time stamp.

Each week I print a bar code report based on the time stamp parameter, e.g., print only the records that fall between two date ranges.

It has come up that now I want to be sure that I have never printed any record before. I found an example (thread702-483214
) that sets a print flag in a header table, and I understand that concept with that particular example, but I can have hundreds of records printed at any given time.

I thought about updating the table's PrintFlag field to Y on each cycle of each line item on the printed report. That doesn't sound too efficient to me. Is there a better way to set the flag to "Y" other than a docmd.runsql command for each recordID?

Thanks in advance.

 

[MazeWorX]

not really but as far as process time you wont even notice. if you have a batch then you may want to consider creating the sql via code and running the SQL one time. In the later case you would simply be creating your where clause with a loop.

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[TheAceMan1]

How are ya jeffmorl . . .

I've never used it but the following link looks promising:

How to tell if an Access Report was Printed

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]