Trap for find dialog | | |
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
| | | | re: Trap for find dialog
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: Quote:
>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 | | | | re: Trap for find dialog
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... Quote:
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: Quote:
>>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
>
| | | | re: Trap for find dialog
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:f4v7r2$i4r$1@textnews.wanadoo.nl... Quote:
>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... Quote:
>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: Quote:
>>>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
| | | | re: Trap for find dialog
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" <AllenBrowne@SeeSig.Invalidschreef in bericht
news:46734502$0$22446$5a62ac22@per-qv1-newsreader-01.iinet.net.au... Quote:
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:f4v7r2$i4r$1@textnews.wanadoo.nl... Quote:
>>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... Quote:
>>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
>
| | | | re: Trap for find dialog
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:f4vtt2$pue$1@textnews.wanadoo.nl... Quote:
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" <AllenBrowne@SeeSig.Invalidschreef in bericht
news:46734502$0$22446$5a62ac22@per-qv1-newsreader-01.iinet.net.au... Quote:
>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:f4v7r2$i4r$1@textnews.wanadoo.nl... Quote:
>>>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
| | | | re: Trap for find dialog
Got it.
john
"Allen Browne" <AllenBrowne@SeeSig.Invalidschreef in bericht
news:4673c609$0$22415$5a62ac22@per-qv1-newsreader-01.iinet.net.au... Quote:
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:f4vtt2$pue$1@textnews.wanadoo.nl... Quote:
>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" <AllenBrowne@SeeSig.Invalidschreef in bericht
>news:46734502$0$22446$5a62ac22@per-qv1-newsreader-01.iinet.net.au... Quote:
>>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:f4v7r2$i4r$1@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
>
|  |
Similar Microsoft Access / VBA bytes | | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,439 network members.
|
