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

Trap for find dialog

P: n/a
In a form how I can I trap for the action that a user opens the built in
'find dialog'? I would like to trap for it and before the dialog shows up, I
would like to execute some code, and after that I would like to bring up the
'find dialog'.
thanks,
john
Jun 15 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
If you mean the Find dialog box and you have a button on your form that opens
Find, then you can simply edit the code behind the On Click of that button
and add your code before the DoCmd that opens the Find.

John wrote:
>In a form how I can I trap for the action that a user opens the built in
'find dialog'? I would like to trap for it and before the dialog shows up, I
would like to execute some code, and after that I would like to bring up the
'find dialog'.
thanks,
john
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1

Jun 15 '07 #2

P: n/a
I do mean that dialog box but if the user presses Ctrl-F or chooses it from
the menu, how would I trap for that?
john

"jahoobob via AccessMonster.com" <u12179@uweschreef in bericht
news:73c1c50a84f66@uwe...
If you mean the Find dialog box and you have a button on your form that
opens
Find, then you can simply edit the code behind the On Click of that button
and add your code before the DoCmd that opens the Find.

John wrote:
>>In a form how I can I trap for the action that a user opens the built in
'find dialog'? I would like to trap for it and before the dialog shows up,
I
would like to execute some code, and after that I would like to bring up
the
'find dialog'.
thanks,
john

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

Jun 15 '07 #3

P: n/a
Build a macro named AutoKeys. (The name is important.)

In the Macros Names column (View menu if you don't see it), use ^F (Shift 6
to get the caret character.) In the Action column, use RunCode to call your
function. At the end of your code, use RunCommand acCmdFind to open the
dialog.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <jo@hn.comwrote in message news:f4**********@textnews.wanadoo.nl...
>I do mean that dialog box but if the user presses Ctrl-F or chooses it
from the menu, how would I trap for that?
john

"jahoobob via AccessMonster.com" <u12179@uweschreef in bericht
news:73c1c50a84f66@uwe...
>If you mean the Find dialog box and you have a button on your form that
opens
Find, then you can simply edit the code behind the On Click of that
button
and add your code before the DoCmd that opens the Find.

John wrote:
>>>In a form how I can I trap for the action that a user opens the built in
'find dialog'? I would like to trap for it and before the dialog shows
up, I
would like to execute some code, and after that I would like to bring up
the
'find dialog'.
thanks,
john
Jun 16 '07 #4

P: n/a
Thanks, that works for Ctr-F. Is it also possible to trap for:
- choosing Find from the menu, and
- choosing Find from the binoculars button in the toolbar?
john

"Allen Browne" <Al*********@SeeSig.Invalidschreef in bericht
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
Build a macro named AutoKeys. (The name is important.)

In the Macros Names column (View menu if you don't see it), use ^F (Shift
6 to get the caret character.) In the Action column, use RunCode to call
your function. At the end of your code, use RunCommand acCmdFind to open
the dialog.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <jo@hn.comwrote in message
news:f4**********@textnews.wanadoo.nl...
>>I do mean that dialog box but if the user presses Ctrl-F or chooses it
from the menu, how would I trap for that?
john

"jahoobob via AccessMonster.com" <u12179@uweschreef in bericht
news:73c1c50a84f66@uwe...
>>If you mean the Find dialog box and you have a button on your form that
opens
Find, then you can simply edit the code behind the On Click of that
button
and add your code before the DoCmd that opens the Find.

John wrote:
In a form how I can I trap for the action that a user opens the built in
'find dialog'? I would like to trap for it and before the dialog shows
up, I
would like to execute some code, and after that I would like to bring up
the
'find dialog'.
thanks,
john

Jun 16 '07 #5

P: n/a
So you need a custom menu and toolbar?

Easy enough to create a new menu/toobar, and copy (Ctrl+Drag) the items you
want from the existing menu, but use your own buttons for the Find items.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <jo@hn.comwrote in message news:f4**********@textnews.wanadoo.nl...
Thanks, that works for Ctr-F. Is it also possible to trap for:
- choosing Find from the menu, and
- choosing Find from the binoculars button in the toolbar?
john

"Allen Browne" <Al*********@SeeSig.Invalidschreef in bericht
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
>Build a macro named AutoKeys. (The name is important.)

In the Macros Names column (View menu if you don't see it), use ^F (Shift
6 to get the caret character.) In the Action column, use RunCode to call
your function. At the end of your code, use RunCommand acCmdFind to open
the dialog.

"John" <jo@hn.comwrote in message
news:f4**********@textnews.wanadoo.nl...
>>>I do mean that dialog box but if the user presses Ctrl-F or chooses it
from the menu, how would I trap for that?
john

"jahoobob via AccessMonster.com" <u12179@uweschreef in bericht
news:73c1c50a84f66@uwe...
If you mean the Find dialog box and you have a button on your form that
opens
Find, then you can simply edit the code behind the On Click of that
button
and add your code before the DoCmd that opens the Find.

John wrote:
>In a form how I can I trap for the action that a user opens the built
>in
>'find dialog'? I would like to trap for it and before the dialog shows
>up, I
>would like to execute some code, and after that I would like to bring
>up the
>'find dialog'.
>thanks,
>john
Jun 16 '07 #6

P: n/a
Got it.
john

"Allen Browne" <Al*********@SeeSig.Invalidschreef in bericht
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
So you need a custom menu and toolbar?

Easy enough to create a new menu/toobar, and copy (Ctrl+Drag) the items
you want from the existing menu, but use your own buttons for the Find
items.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <jo@hn.comwrote in message
news:f4**********@textnews.wanadoo.nl...
>Thanks, that works for Ctr-F. Is it also possible to trap for:
- choosing Find from the menu, and
- choosing Find from the binoculars button in the toolbar?
john

"Allen Browne" <Al*********@SeeSig.Invalidschreef in bericht
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
>>Build a macro named AutoKeys. (The name is important.)

In the Macros Names column (View menu if you don't see it), use ^F
(Shift 6 to get the caret character.) In the Action column, use RunCode
to call your function. At the end of your code, use RunCommand acCmdFind
to open the dialog.

"John" <jo@hn.comwrote in message
news:f4**********@textnews.wanadoo.nl...
I do mean that dialog box but if the user presses Ctrl-F or chooses it
from the menu, how would I trap for that?
john

"jahoobob via AccessMonster.com" <u12179@uweschreef in bericht
news:73c1c50a84f66@uwe...
If you mean the Find dialog box and you have a button on your form
that opens
Find, then you can simply edit the code behind the On Click of that
button
and add your code before the DoCmd that opens the Find.
>
John wrote:
>>In a form how I can I trap for the action that a user opens the built
>>in
>>'find dialog'? I would like to trap for it and before the dialog shows
>>up, I
>>would like to execute some code, and after that I would like to bring
>>up the
>>'find dialog'.
>>thanks,
>>john

Jun 16 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.