Results 1 to 7 of 7
  1. #1
    Uncolouredcolors is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2015
    Posts
    10

    Need help!

    Hey guys. I don't know if this is the right place for this thread, but here it goes. I need some help creating a searching form and to show the results inside the form! It's like a Library type searching. U know, u want to search for some type of monument or so and it shows the results, all the info, photos and that! Please, i really need help because i don't know that much about access and i've search a lot for tutorials and don't seem to find!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    make a continuous record form
    in the header, put a box or combo to do the filtering.
    in the after update of the control, filter the results,

    Code:
    me.filter = "[state]='" & cboStates & "'"
    me.filterOn = true

  3. #3
    Uncolouredcolors is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2015
    Posts
    10
    Thanks for replyin Man! but u are talking chinese to me, ahah. Sorry! I don't know that much about access... I'm just trying to learn to help a friend of mine...

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

  5. #5
    Uncolouredcolors is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2015
    Posts
    10
    Quote Originally Posted by orange View Post
    See this tutorial and sample from Allen Browne

    http://allenbrowne.com/ser-62.html
    or see
    https://www.accessforums.net/code-re...rch-43055.html for ideas.
    Yeah! Something like the Universal Search! That's amazing! I want something like that, where u search for words or dates and it shows all the correspondants! and the Details window is genius because I need to show some photos too! Can you help me out with this?

  6. #6
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    then you must learn some Access principles.
    Cant do that here.

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    @uncoloredcolors

    Post a copy of your database -doesn't have to be full database--just enough records to show what you have.

    Post instructions are behind the Go Advanced button below.

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

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