Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    16

    Unanswered: Find in an Access Page

    OK I'm sure this is simple but...

    In an access page how do I give users the ability to search for a record? I want to let them search the whole database much like you can do in a form. Any ideas would be appreciated.

    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    I assume your a newbie. First create the query for your search of "everything" a user would need. Then figure out how you want the user to fill in data for the variables of the search-- here put in "abc" or similar into criteria field. Should they use a pulldown or enter text? These answers will lead to the building of form(s). Now design the user entry stuff in the form header then give em a command button to launch search. This is where you add the code to build the proper string query. (Refer to sql view of the query for specific syntax.) Then you could treat the rest of the form as the results of the query by using a continuous form and modifying the record source and filter to the appropriate strings, once the search button is hit. Just remember to handle the FilterOn = t/f properly to enable/disable the form filter.

  3. #3
    Join Date
    Sep 2003
    Posts
    16
    Quote Originally Posted by poliarci
    I assume your a newbie.
    thanks....

    I have the query, form, etc. I now want to have the users be able to search the database from a web front end (access page). I am having problems finding the search function in the design view navigation bar.

    Not a n00b but I am somewhat hung-over.
    Last edited by Crypto; 07-30-04 at 18:44.

Posting Permissions

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