Results 1 to 9 of 9
  1. #1
    Milade8080 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    18

    building a search form in Access 2010

    Hi
    I need a form to search records
    With this condition by typing part of the name or description of the downturn to be filtered
    Anyone can design a form for me to


    Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Can refer you to examples. Here is one: http://www.datapigtechnologies.com/f...tomfilter.html
    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
    Milade8080 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    18
    Quote Originally Posted by June7 View Post
    Can refer you to examples. Here is one: http://www.datapigtechnologies.com/f...tomfilter.html
    hi
    Thank you for the answer
    But I have a Microsoft Access 2010 version is

  4. #4
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much June7
    Great video

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by Milade8080 View Post
    hi
    Thank you for the answer
    But I have a Microsoft Access 2010 version is
    If you do not want to build a dynamic parameterized query you can write VBA to build your where criteria.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    The technique demonstrated in the video still applies even to Access 2013.

    Or as ItsMe suggested, use VBA: http://www.allenbrowne.com/ser-62code.html
    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.

  7. #7
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much Guys
    Is it possible to attach a practical example of the DB

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    This is a common topic - many threads. Search forum. Follow the video.
    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.

  9. #9
    Milade8080 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    18
    Quote Originally Posted by June7 View Post
    The technique demonstrated in the video still applies even to Access 2013.

    Or as ItsMe suggested, use VBA: http://www.allenbrowne.com/ser-62code.html
    Tanks
    Good luck

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

Similar Threads

  1. Multi Search Form in Access 2010 Issues
    By AccessJunky in forum Access
    Replies: 4
    Last Post: 08-23-2019, 11:02 PM
  2. MS Access 2010 Multiple Search Form
    By tb199 in forum Access
    Replies: 17
    Last Post: 01-16-2014, 08:33 AM
  3. Building in a Search
    By rescobar in forum Queries
    Replies: 6
    Last Post: 08-02-2013, 03:17 PM
  4. Creating a search box in Access 2010 form
    By d4jones in forum Forms
    Replies: 3
    Last Post: 07-18-2012, 02:53 PM
  5. Keyword search with Access 2010 FE
    By Brian62 in forum SQL Server
    Replies: 1
    Last Post: 06-15-2012, 06:06 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