Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In Access 2002 SP-3, is there a way I can set things up, when I open a database, to go to the first entry under, say, "K", by pressing K on the keyboard?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    First entry in what?

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='761017' date='24-Feb-09 18:34']First entry in what?[/quote]
    A table.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    No, that is not possible.

    If you create a form based on the table, and set that form as startup form (in Tools | Startup...), you could write code in the On Key Press event of the form to jump to a record, but I think it would have undesirable side effects. It would be better to use a combo box (dropdown list) or a series of buttons.

    The attached database shows an approach with buttons representing the letters of the alphabet, based on an example by Microsoft.
    Attached Files Attached Files

Posting Permissions

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