-
MS Access 2007
Hi Folks,
Need a little help... I am stuck... I am trying to make a Login entry screen and also an automatic log system. example: Each time someone logs in it records into the Log table that I have created
Also
is there away to record all the forms that way if anyone changes anything you can go back and see what was changed?
ill try to attached the database nvm it cant be zipped... its too large 570kb and the max i can upload is 100kb
let me kno and i will email it to you....
-
You will find examples for both here:
UtterAngel
Check out:
Audit Trail
This db demonstrates how to set up an audit trail of changes to the data including ID, Field Name, the field value before it was changed, the field valueafter it was changed, the user who did the change, and the date/time the change was made.
Boiler Plate Database
This is a moderately advance database that encorporates a number of functions such as 1) user logon 2) table reattachment 3) user tracking 4) how to control access via the use of modal switchboards and more. FYI: Username = admin; Password = admin.
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC]
Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|