Audit trail - Logging system (unbound forms)

[morglum007]

Hi there all.

Here I am again, and with new and "amazing" problems to be discussed.

As usual, I have been digging in the web, and little or no solutions available for my problem. Well, at least, not "easy" ones.

After strugging a little with data base saving system (denying auto-save feature in access (2007)), making difficult queries, and so on, I reached something I cant deal with at the moment.

By the way, I have also implemented a "secured" data base with front end and back end, located in local network with some sort of SSL bypass access data-base in the middle.

Everything works OK. My secured data-base have its own users (aside from Sharepoint), and it tracks IP, MAC, MOBO S/N, CPU S/N and so on, so user personal's data are gathered without problems.

Now I am implementing a logging system, in which I plan to capture all movements inside database, I got a temp table, which is filled with collected data, and after user logs-off, report is generated in .txt/.log, and sent via e-mail to secured server (among other .log copy sent fia FTP to another location). This way I preserve data-base status clean of undesired extra data.

By now, I have implemented, with no problems, audit for log-in,log-off, panel navigation (front end forms) and bound data changes capture.
Anyhow, I found some problems when capturing data with unbound forms.

This forms usually are used to make special queries, give user's collected data in someway, and so....

Maybe this sounds litle stupid, but... does anybody here knows something about dealing with that? Maybe it is also so stupid, but atm I cannot find any practical idea.

I have tried to use the form's "on current event", but seems it does not work at all with unbound data. I have also seen some people capturing windows commands, but it seems "dangerous" if you do not do it with some care. Is there any easier solution?

The way I want to do it, is not by hand, I mean, without coding on each control in unbound forms.
I would like a "select case ctl.controltype....accommandbutton...." option if available, cause some controls may become unstable when loading extra data on its already busy coding, and also, because there are in fact plenty of 'em.

Any ideas/suggestions appreciated.

TIP: During this months coding I have learnt a lot, and some guys here helped me a lot. Hope this could be solved as well.

Have a nive day!

 

[JamesMcS]

So you're trying to update a table with data entered into unbound fields? How about an update query in the on click of a button? i.e. update whichever field to [forms]![unbound form]!control.value?

 

[morglum007]

First, thanks for the reply.

Second, I have seen something like out there, but could not apply succesfully.
I have been searching for ways to capture certain commands (including command buttons) but did not saw any example of how to do it.

If i correctly understood, you are trying to get an update command into one table. Thats not what I am trying to solve, cause unbound forms have no tables at the backend. It is something like a runtime generated form which is filled in a very particular way (depending on user's ideas), catching data from different tables and different places.

maybe I am missing the point, but I do not got any table to update. As I told before, there is no problem with bound forms, or tables update, so it can be correctly gathered. The problem are the unbound forms, most of them are "read only", with no back-end data attached.

Please, forgive me in advance I am not understanding you at all, or I did not explained myself so correctly.

Thanks

 

[JamesMcS]

I'm not familiar with runtime generated forms, but it doesn't matter that the form is unbound. If you have a value in a text box, I'm sure it can be used in an update query in VBA (i.e. docmd.runsql), and you can use as many of these as you like. So, if you have text boxes A, B and C, and the values therein need to be in tables D, E and F, just use 3 docmd.runsql's.