Monitor Form Usage

[mattc66 via AccessMonster.com]

Hi All,

I have a database that is used by many users. I want to monitor who uses what
form and or clicks on certain buttons.

Does anyone know of a untility that I could addon that would perform these
tasks?

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200711/1

[bobh]

Hi,
I don't know of any utilities that do that but I do that in most of my
access apps
using vba code. I have a table called tblWhoWhatWhen and when a user
opens particular forms or clicks on certain buttons I open the
WhoWhatWhen table and write a record,
something like this
If Me.bxWhchRpt = "1" Then
'record who and what
Set MyRec = MyDB.OpenRecordset("tblWhoWhatWhen", dbOpenDynaset)
MyRec.AddNew
MyRec!UserID = Me.bxUserID
MyRec!RunDte = Format(Date, "mm/dd/yyyy")
MyRec!RunTme = Format(Time(), "HhNnSs")
MyRec!WhchHub = Me.cboHub
MyRec!WhchRpt = Me.bxWhchRpt
MyRec!StartDte = Me.bxFrstMth
MyRec.Update
MyRec.Close

bobh

On Nov 28, 4:15 pm, "mattc66 via AccessMonster.com" <u16013@uwe>
wrote:

Hi All,

I have a database that is used by many users. I want to monitor who uses what
form and or clicks on certain buttons.

Does anyone know of a untility that I could addon that would perform these
tasks?

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...