Code

Re: Track all changes made to a record in Infopath

Unreal1998 — Fri, 13 Nov 2009 16:10:33 GMT

Access doesn't have a built in functionality to keep historical data like that, it requires code. My organization wants me to create a working prototype with Access( lol) and then sell the idea to other business groups and get funding for some kind of server where we can use some SQL based app. For now I'm stuck with Access and Infopath. I really don't have the technical skills to build forms in Access. I'm much better in Infopath. I just wish I could run a similar code from infopath and pass it on to Access.

Re: Track all changes made to a record in Infopath

Greg Collins — Fri, 06 Nov 2009 23:44:12 GMT

I'm not a database expert, and know practically nothing of Access, however in SQL I believe you can write a trigger to copy out the previous row data when changes are made. Perhaps Access has something like that you can do?

Track all changes made to a record in Infopath

Unreal1998 — Fri, 06 Nov 2009 21:44:17 GMT

Can the following code be applied to Infopath when it's linked to Access in the back-end. For example: anytime I submit a change to a record in Infopath, can the pre-update record be copied to a historical table.

http://www.vb123.com/Toolshed/00_access/auditrecords.htm