Registar Eventos

[Skincb]

Good afternoon,


I have a small application developed by me, but how many users have to work on it daily, I need a command to put in the table records each change to the data in each field of the form, I have this done.

Private Sub MatQuant_AfterUpdate ()
Dim stSql
stSql = "INSERT INTO Registo (Reg_usr, Reg_data, Reg_form, Reg_apl, Reg_onde) SELECT [Formulários]! [Avaria]! [usuário], Now (), 'Avaria_Mat', 'SkAvarias', 'QUANTIDADE' e [Matquant] "
DoCmd.RunSQL stSql
End Sub


but if it took a few fields to put in each field, but are huge fields in the form.
There is some way to do this faster with the same objective?

[rpeare]

Most here speak english.. any chance of getting a translation?

[June7]

You want an audit log? For one example, review: http://allenbrowne.com/AppAudit.html