Help finding modified records?

[Angie H.]

Hi
Am using a MSOffice '97 Access DB. Has loads of tables with relationships
set up.
It is used by about 20 people.
I need to be able to dig out records/entries that have been recently
modified.
Anyone out there with any clues about how this could be set up.
I used to do this with FileMaker Pro ... but I'm new to Access.
Thanks
Angie H.

 

[JSand42737]

Hi
Am using a MSOffice '97 Access DB. Has loads of tables with relationships
set up.
It is used by about 20 people.
I need to be able to dig out records/entries that have been recently
modified.
Anyone out there with any clues about how this could be set up.
I used to do this with FileMaker Pro ... but I'm new to Access.
Thanks
Angie H.

Angie

Firstly, you need to have some means of identifying when records were modified.

To do this, you need to add to the tables that you are interested in a
Date/Time field, called LastEdit.

Now, in each of the forms that is used to modify these tables' data, you need
to place some code in the BeforeUpdate event.

Open the form in design mode, and select View|Code from the menu bar. Then copy
the code below into the code window:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me!LastEdit = Now
End Sub

Once you have this information, it is then possible to query the tables to get
data that has been edited in the last hour/day/whatever.

 

[Angie H.]

THANK-YOU, Jon!
Bingo.
And thanks for website

Angie

Firstly, you need to have some means of identifying when records were modified.

To do this, you need to add to the tables that you are interested in a
Date/Time field, called LastEdit.

Now, in each of the forms that is used to modify these tables' data, you need
to place some code in the BeforeUpdate event.

Open the form in design mode, and select View|Code from the menu bar. Then copy
the code below into the code window:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me!LastEdit = Now
End Sub

Once you have this information, it is then possible to query the tables to get
data that has been edited in the last hour/day/whatever.


--

Jon

www.applecore99.com - Access Tips and Tricks