Stamp date for every record change

[AtleDreier]

Hello!

I need to know when and who made a change to a record. Is there an easy way
to do this?

The problem is that the data can be changed through both forms and queries,
so programming the event for every form/query is impractical. Is there any
'global' event that fires when a record is saved or something?

 

[Allen Browne]

In Access 2010 (released later this month), you will be able to use Data
Macros to do this.

In current versions of Access, there's now way.

 

[ryguy7272]

Office 2010 Beta seems to be available for free
http://www.microsoft.com/office/2010/en/download-office-professional-plus/default.aspx

Is that right? MS wants people to test it's product, and that's why it's
free...for now. What's the story? Also, I have 2007 now. Would I have to
uninstall 2007 to run 2010?

Thanks!!
Ryan---

 

[vanderghast]

And the most important update, that is, a delete, it will stamps the record
as being deleted by whom and when, then, a moment later, be deleted?

Vanderghast, Access MVP

 

[Allen Browne]

Yes, the beta was free, but time-limited.

Better to get the real product when available.

 

[AtleDreier via AccessMonster.com]

Well, we don't really delete data. We mark them 'Void' with a flag field.
Only I can actually delete, and then only redundant or invalid data. So
deletions are not a big concern. But I might ban the use of query datasheets
and do everything through forms instead. Then i can do it on the 'on update'
event, right? That fires whenever a record is saved, I think.

And the most important update, that is, a delete, it will stamps the record
as being deleted by whom and when, then, a moment later, be deleted?

Vanderghast, Access MVP

Hello!

[quoted text clipped - 6 lines]

so programming the event for every form/query is impractical. Is there any
'global' event that fires when a record is saved or something?

 

[John Spencer]

You can use the before update event of the form which should fire whenever a
record is changed/added.

And you are absolutely correct about using forms and only forms to control
data entry.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Well, we don't really delete data. We mark them 'Void' with a flag field.
Only I can actually delete, and then only redundant or invalid data. So
deletions are not a big concern. But I might ban the use of query datasheets
and do everything through forms instead. Then i can do it on the 'on update'
event, right? That fires whenever a record is saved, I think.

And the most important update, that is, a delete, it will stamps the record
as being deleted by whom and when, then, a moment later, be deleted?

Vanderghast, Access MVP

Hello!

[quoted text clipped - 6 lines]

so programming the event for every form/query is impractical. Is there any
'global' event that fires when a record is saved or something?