Results 1 to 5 of 5
  1. #1
    ANTHROPOIDLUVA is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2012
    Posts
    13

    How to Create Google-like Search field on Form / Prepopulate LOGIN Screen text fields


    I am interested in creating a search field on my form similar to the one Google is well known for. I don't want the carrot (like the one combo box) to appear on such a field. But as the user enters information, the field will begin to auto-populate. Once the user finds the item their searching for, they would be able to click a button, or even hit the return key, and go directly to the associated record.

    One other item I would like to do involves my login screen. There exists two unbound text fields, UserId and Pwd. I would like for the fields to display "UserID" and "PWD" upon load and once User begins to type in either field, the "UserID" and "PWD" disappears. This would allow me to do away with the labels associated with the fields.

    Any help with these items would be greatly appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    1. What do you mean by 'carrot (like the one combo box)'? The AutoExpand property of combobox will auto-populate. Will need VBA code to 'go to' associated record. Options are: set form Filter property, set form RecordSource property, RecordsetClone and bookmarks.

    2. Set DefaultValue property. Then in textbox GotFocus event VBA procedure, use code like: Me.textboxname.SelLength = Len(Me.textboxname)
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368
    Maybe he means Allen Browne's "find as u type"

    http://allenbrowne.com/appfindasutype.html

  4. #4
    ANTHROPOIDLUVA is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2012
    Posts
    13
    June 7,

    I do not want to see the down carrot on the combo box (preferably not use a combox at all) . I am looking to have a search field feature like the one on the accessforums website (see feature: scroll up, top right of webpage: textbox with the magnifying glass)

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I think the Allen Browne procedure suggested by JeroenMioch is probably the best you can get.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Login Screen in Access
    By Di7bash in forum Access
    Replies: 3
    Last Post: 03-18-2014, 11:57 PM
  2. using google maps address into a text field
    By thanosgr in forum Programming
    Replies: 5
    Last Post: 04-26-2012, 03:39 PM
  3. Replies: 1
    Last Post: 12-11-2011, 11:48 AM
  4. Replies: 3
    Last Post: 07-18-2011, 09:24 AM
  5. Replies: 3
    Last Post: 11-05-2010, 03:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums