By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,616 Members | 1,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,616 IT Pros & Developers. It's quick & easy.

Monitor Form Usage

P: n/a
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

Nov 28 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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...
Nov 28 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.