Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2006
    Posts
    4

    Question Unanswered: Help with user entry on form to scoll down to right record

    Hello,

    I have a form which displays all the Device ID's in our company. Being a big site it has lots of entries. Currently the engineer has to use the scroll bar to find the right Device ID in the list.

    What I would like to do is to protect the device ID field and if an engineer type h it would scroll to the beging of the records with h, if they type hc it would scroll to the records being with hc etc... all this in real time.

    Can you help?

    Thank you for your time.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    The simplest solution would be to use the combo box wizard, selecting the third option "Find a record...".
    Paul

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    pbaldy's got it exactly right. When the engineer starts typing Autofill will go to the appropriate record, and bada bing bada boom!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Sep 2006
    Posts
    4
    Thank you both for your advise, it worked great, only problem I have is that i used to double click on the Device ID which activated a popup, displaying everything about the port that device was on. I figure I will only be able to do one thing or the other, but once again thank you!

  5. #5
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Sounds like something you could still do.
    Paul

  6. #6
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    100% Paul,

    define it: it can almost certainly be done
    (one exception i found so far: manufacturer's serial# for *.* hard-drives in Win-revs prior to XP/Vista... but i'm still playing with it)

    therefore:
    I figure I will only be able to do one thing or the other = FALSE
    ...but provide some detail

    izy
    currently using SS 2008R2

Posting Permissions

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