Change logging in Access

[Glenn Glazer]

I would like to know if Access does automatic change logging. That is, for a given record, I can call up a history of the changes made to that record

Thanks

Glen

P.S. If you could cc my email address, that would be great!

 

[Cheryl Fischer]

No, it doesn't. You would need to create your own routine(s) to do that.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I would like to know if Access does automatic change logging. That is,

for a given record, I can call up a history of the changes made to that
record.

 

[Glenn Glazer]

Thanks, Cheryl

By routines, do you mean VB

Best

Glen

----- Cheryl Fischer wrote: ----

No, it doesn't. You would need to create your own routine(s) to do that

-

Cheryl Fischer, MVP Microsoft Acces
Law/Sys Associates, Houston, T

I would like to know if Access does automatic change logging. That is

for a given record, I can call up a history of the changes made to tha
record

 

[Van T. Dinh]

See Allen Browne's Web site for ideas:

<http://members.iinet.net.au/~allenbrowne/AppAudit.html>

HTH
Van T. Dinh
MVP (Access)

 

[Cheryl Fischer]

Yes. In Access, you would use Visual Basic for Applications.

 

[Glenn Glazer]

Goldmine! Right on the money

Thanks, Van

Best

Glen
----- Van T. Dinh wrote: ----

See Allen Browne's Web site for ideas

<http://members.iinet.net.au/~allenbrowne/AppAudit.html

HT
Van T. Din
MVP (Access