Programming function keys

  • Thread starter Thread starter Dudley
  • Start date Start date
D

Dudley

In my Access 2002 database F10 runs Function UpdateEnquiry (). Can some
expert tell me how the function controls F10 and how I can set up functions
for other F keys?

I have tried Ctrl-F looking for Function UpdateEnquiry in current project
but it did not find anything.

Thanks for any help.
Dudley
 
Easiest solution is to create a macro names AutoKeys.

In the Macro names column, use:
{F10}
or whatever key you want.
In the Action column, choose what you want it to do, e.g. RunCode to execute
a function.

Example of setting up an autoKeys macro:
http://allenbrowne.com/casu-05.html
 
Thanks very much - now I see that that is just what the person who designed
my system did!

I assume I go first to modules. I choose one (eg form related) and 'Insert
procedure', then selecting function and public. When I have created the
function I allocate it to the F key using the autokey method. Is this correct?

Thanks
Dudley

Dudley
 
Sorry I did not make myself clear. I meant create the function in modules and
then allocate it to an F key under macros.

Dudley
 
Ah, sorry for the the confusion over function (as in F-key) and function
(as in VBA procedure.)

Yes: you write the VBA function (if that's what you want the F-key to
execute), and call it with the RunCode action in your AutoKeys macro.
 
Thanks very much for your help.

Regards
Dudley

Allen Browne said:
Ah, sorry for the the confusion over function (as in F-key) and function
(as in VBA procedure.)

Yes: you write the VBA function (if that's what you want the F-key to
execute), and call it with the RunCode action in your AutoKeys macro.
Click to expand...
 
Back
Top