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

Place Code In An Already Existing Form

P: n/a
OS: NT4
Office: XP

Hello All,
Is there any way that I can add code on a Form work event
automatically.
Example: I have fifty forms in a Database and I want to track who is
opening the form at what time and the frequency of opening each form.
I can simply go and insert a function call whoOpenedTheform(myUser) on
the load event of the form. However, I dont want to open 50 forms and
type that on each and every work event. Is there any way (Wizard,
Add-Ins....) that I can automate this task of writing this function on
each and every work event
All help is really really appreciated

Thanks
Farooq
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
As\ a clue as to where to begin, have a look at InsertLines etc in the help
file. This will insert code into a form

Just loop through all the forms in the Db

This is an AK2 solution, but I expect it will work in XP as well

Phil
"Farooq" <kf*****@yahoo.com> wrote in message
news:81**************************@posting.google.c om...
OS: NT4
Office: XP

Hello All,
Is there any way that I can add code on a Form work event
automatically.
Example: I have fifty forms in a Database and I want to track who is
opening the form at what time and the frequency of opening each form.
I can simply go and insert a function call whoOpenedTheform(myUser) on
the load event of the form. However, I dont want to open 50 forms and
type that on each and every work event. Is there any way (Wizard,
Add-Ins....) that I can automate this task of writing this function on
each and every work event
All help is really really appreciated

Thanks
Farooq

Nov 13 '05 #2

P: n/a
You might want to look at a product called "Speed Ferret" by Black Moshanon
(sp?)
This is an excellent tool that I have used a lot. It lets you do search and
replace on every part of an Access database, including code, control names
on forms, properties, etc.
-John

"Farooq" <kf*****@yahoo.com> wrote in message
news:81**************************@posting.google.c om...
OS: NT4
Office: XP

Hello All,
Is there any way that I can add code on a Form work event
automatically.
Example: I have fifty forms in a Database and I want to track who is
opening the form at what time and the frequency of opening each form.
I can simply go and insert a function call whoOpenedTheform(myUser) on
the load event of the form. However, I dont want to open 50 forms and
type that on each and every work event. Is there any way (Wizard,
Add-Ins....) that I can automate this task of writing this function on
each and every work event
All help is really really appreciated

Thanks
Farooq

Nov 13 '05 #3

P: n/a
Thank You So Much Phil. This is a great starting point
Thanks Once Again
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message news:<41*********************@mercury.nildram.net> ...
As\ a clue as to where to begin, have a look at InsertLines etc in the help
file. This will insert code into a form

Just loop through all the forms in the Db

This is an AK2 solution, but I expect it will work in XP as well

Phil
"Farooq" <kf*****@yahoo.com> wrote in message
news:81**************************@posting.google.c om...
OS: NT4
Office: XP

Hello All,
Is there any way that I can add code on a Form work event
automatically.
Example: I have fifty forms in a Database and I want to track who is
opening the form at what time and the frequency of opening each form.
I can simply go and insert a function call whoOpenedTheform(myUser) on
the load event of the form. However, I dont want to open 50 forms and
type that on each and every work event. Is there any way (Wizard,
Add-Ins....) that I can automate this task of writing this function on
each and every work event
All help is really really appreciated

Thanks
Farooq

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.