How to Flag Updated Records

[AngelT]

Objective: Determine whether to run printout of report by number of updated records.

Currently I run several (rather large) reports on a quarterly basis to create hard copies for staff referencing purposes. To assist on determining whether it is justifiable to run a new printout or not of each of these reports, I would like to somehow come up with a method of "flagging" whether a particular record has been revised since last printed.

What would be the best, and of course "easiest" method to accomplish this task?

Thank you for all the help.

 

[KenHigg]

Add a 'date last printed' fld to the table.

???
ken

 

[AngelT]

Hmmmmm.....*thinking*.......... so, once a report prints, it appends the print date to a field of each record? Is that what you are saying?

That would just tell me when I last printed the particular record, but not that the record itself has been revised since the last print out right? ORrrrr.....could I have that "print date" field = Null upon the update of the record?????

*brainstorming*

 

[KenHigg]

Yeah - I was just thinking of a flag type fld. Once it the print runs it changes states. I'm really not sure what event would be best to reset it if there is a change... Maybe the afterupdate?

kh

 

[mohammadagul]

you can also maintain the print log. there is an article on this issue onmicrosoft website which i have read . currently i dont have thelingk but i willcheck.

 

[Hayley Baxter]

You can track when a change has been made to a record. All you would need to do then is have a count for the number of amended records.

Here's a sample of how to track changes. It's in A2000 let me know if you need it converted.

HTH
Hay

 

[mohammadagul]

you can also use the Audit Trial function here. Place a Button on the form whcih shows the audit done.
you can find lot of audit functions and examples. Search for Audit Trial on the form forum

 

[KenHigg]

Of course, before you have an Audit Trial, you need a proper indictment.

 

[AngelT]

Wow! Thank you for all of this input. I'm a little blown away and not sure if everyone is on the same track as I am actually after, but I will be sure to look up each the "print log" and "audit trail" options.

Don't worry....I'll be sure to let you know if I've gotten somewhere or not.