Mime-Version: |
1.0 |
Sender: |
|
Subject: |
|
From: |
|
Date: |
Sat, 7 Apr 2007 09:04:29 -0400 |
Content-Transfer-Encoding: |
8bit |
Content-Type: |
text/plain; charset="windows-1252" |
Reply-To: |
|
Parts/Attachments: |
|
|
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
|
|
|