Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    program a function key (Access 2003)

    I would like to know if there is a way to program a function key, say F11, so that when the user press that key, a windows will pop up automatically.

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: program a function key (Access 2003)

    Hi there

    You could use Keyboard Accelerators to assist you.

    If you have a comman button on a form that has the Caption, say, "Open Menu" you could go into its properties and place an & in front of the Open menu text to look like this &Open Menu. When you next look at the form the command button will read O pen Menu

    This will allow the user to open the form by clicking alt+O.


    Is this what you were looking for?
    Jerry

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: program a function key (Access 2003)

    Hi Jerry,

    Thanks for the tips. That could work but I prefer to just press a function key and it opens up a popup windows directly.


    Thanks

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: program a function key (Access 2003)

    No probs...be aware that F11 in Access brings the database window to the front of all other objects. There is a full listing of function key assignment in the help files.
    Jerry

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: program a function key (Access 2003)

    You can create a macro named AutoKeys (it must be exactly this name).
    Open this macro in design view.
    Display Macro Names (there is a button for this on the toolbar)
    Enter the code for a keystroke in the Macro Name column.
    For example, the code for F11 is {F11}, that for Ctrl+F11 is ^{F11}, and that for Shift+F11 is +{F11}
    Enter the action(s) you want to execute in the Action column.
    See screenshot below.

    Warning: AutoKeys are active throughout the database!

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: program a function key (Access 2003)

    You should also be aware that many of the Function Keys already have some assignment, so if you change them to do something else, user already familiar with Access will be confused by the changes in the User Interface. We frequently use a double-click on a field to pop-up a form.
    Wendell

  7. #7
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: program a function key (Access 2003)

    Thanks everyone. The AutoKeys macro works really nicely.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •