Subject: | |
From: | |
Reply To: | |
Date: | Mon, 9 Apr 2007 08:10:27 -0400 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Edwin, thank you very much. The information you provided is great.
Tracey
-----Original Message-----
From: Records Management Program [mailto:[log in to unmask]] On
Behalf Of Edwin Staples
Sent: Saturday, April 07, 2007 9:04 AM
To: [log in to unmask]
Subject: Re: [RM] Access Database Functions
For tracking which records are edited and when, I do the following (you
can
do this in MS Access "forms", or in a server-side scripting language
such
as ASP).
Here are the steps for putting user name and date into a table for
monitoring who and when.
1) create a field called "edit-date" in the table, of the date type.
create
a field called username (the 2nd will only work if you have passwords
for
the database, which you can find out about in Access Help).
2) put that field into an access form
3) in the form, view the properties window
4) select the "event" tab
5) in the code window for the "Before Update" event:
edit-date = date()
username = CurrentUser
Everything to the right of the sign is a built-in function that
VB "magically" knows about.
For the purpose of tracking what my interns do during a given day, I
create
queries off my data that search for today's date, or today's date minus
7
days, with user names.
As to the Outlook question, I know the code is in the VB library
somewhere
but never had occasion to use it.
(I copy most of my code off other people, such as ASP101.com)
Good luck!
List archives at http://lists.ufl.edu/archives/recmgmt-l.html
Contact [log in to unmask] for assistance
List archives at http://lists.ufl.edu/archives/recmgmt-l.html
Contact [log in to unmask] for assistance
|
|
|