Help finding modified records?

  • Thread starter Thread starter Angie H.
  • Start date Start date
A

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.
 
"Angie H." <[email protected]> said:
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.
Click to expand...

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.
 
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
Click to expand...
 
Back
Top