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