I'm trying to write a script that will enter in a date and/or time field, when each record was last printed. I have a very large database that will take several days to print each record (on an ID machine) and I need to be able to "mark" the ones that were printed and come back to print the ones that were not. Any ideas?

Edited April 21, 200619 yr by Guest

Perhaps a number field with an auto-entered value of 0 that is set to 1 when printed would work? Then you could search the field for any records with a zero to see which, if any, have not been printed.

Okay, but how do I get it to auto enter when a record is printed?

I would implant the date printed so you can review batches or reprint sets if your printer accidently begins shredding them. Otherwise, you wouldn't know which records to reprint.

But you need to include in your print script, setting the PrintDate. If you are using print 'records being browsed' then you need to loop through them after printing adding something like:

Go To Record/Request/Page [ First ]

Loop

Set Field [ DatePrinted ; Status ( Current Date) ]

Go To Record /Request / Page [ Exit after Last ; Next ]

End Loop