Access/VBA - Create Audit History

Completado Publicado Aug 12, 2011 Pagado a la entrega
Completado Pagado a la entrega

I am working on adding an audit trail to a database. I found a concept I liked here: <[url removed, login to view]>

I can't get it to work because I don't know how to use VBA. I get compile errors and once I got through the compile errors it still didn't work. I just don't have the experience.

I've attached a copy of the database with the modules the above post suggests and the form I'm trying to add this process to is:

Frm-MasterDataTool

(My failed attempt is on Frm-MasterDataTool2)

You'll need to check or paste over the VBA code to make sure I haven't screwed anything up there.

One addition: I want to add a field to each record created in the Tbl__ChangeTracker -- "Customer Mobile Number" which is present in my form. It needs to get included with each record.

If for some reason this audit trail will not work, I'll accept another similar process, but this one seems fairly robust and (if I could get it to work!) it would copy to other forms easily, and I particularly like that it captures the computer ID and login information. I'm willing to pursue a different set of code, but would want to have some conversation about these items.

Microsoft Access

Nº del proyecto: #3506330

Sobre el proyecto

4 propuestas Proyecto remoto Activo Aug 13, 2011

Adjudicado a:

Prashantskin

See private message.

$25.5 USD en 2 días
(447 comentarios)
6.8

4 freelancers están ofertando un promedio de $57 por este trabajo

finecodervw

See private message.

$76.5 USD en 2 días
(50 comentarios)
5.4
UFS

See private message.

$84.15 USD en 2 días
(1 comentario)
0.7
jaison007g

See private message.

$40.8 USD en 2 días
(0 comentarios)
0.0