Multi User Log System

  • Thread starter Thread starter Vanessa
  • Start date Start date
V

Vanessa

Hi there,

Am I being really dumb, I am setting up a multi user access system, and
I am having a pain with one (what I think would be a simple) element,
perhaps I have been too close to the project but I am stumped.

What I want to do is automatically take information from one table to
another depending on a afterupdate or something, as a log of what
people have entered, this cannot be held on the same table as the info
can be edited several times a day on the same record and we have to be
able to count outcomes, so ultimatly I cant use append query as the
information change can happen quickly, but we need a record for each
outcome on a seperate table.

I've tried some VB but that didn't work

I just don't have the answer, arghh!!!

Cheers
Vanessa
 
Sorry I failed to mention, that the last outcome hase to be on the
original table as well as adding a unique log in the log table,

Thanks
Vanessa
 
Hi Vanessa - where is the problem occurring? It sounds like you should be
able to append a record with a field holding the Current Time on Afterupdate.
I would help to know what it is NOT doing.
 
Hi there,

Am I being really dumb, I am setting up a multi user access system, and
I am having a pain with one (what I think would be a simple) element,
perhaps I have been too close to the project but I am stumped.

What I want to do is automatically take information from one table to
another depending on a afterupdate or something, as a log of what
people have entered, this cannot be held on the same table as the info
can be edited several times a day on the same record and we have to be
able to count outcomes, so ultimatly I cant use append query as the
information change can happen quickly, but we need a record for each
outcome on a seperate table.
Click to expand...

What did you try?

This should be straightforward IF you are - as you emphatically should
be! - using a Form to do the data editing and data entry. In the
Form's BeforeUpdate event you can open a Recordset based on your log
table and add a new record:

Private Sub Form_BeforeUpdate(Cancel as Integer)
Dim db As DAO.Database
Dim rs As DAO.Recordset
<do any form validation checks here>
Set db = CurrentDb
Set rs = db.OpenRecordset("LogTable", dbOpenDynaset)
rs.AddNew
rs!ThisField = Me!txtThisField
rs!ThatField = Me!txtThatField
rs!WhenLogged = Now
rs.Update
rs.Close
Set rs = Nothing


John W. Vinson[MVP]
 
Back
Top