Results 1 to 4 of 4

Thread: I need a search function for my access database.

  1. #1
    Join Date
    Sep 2009

    I need a search function for my access database.


    I need a search function for my access database.
    Please help me with some article or some suggestions.

  2. #2
    Join Date
    Apr 2008

    Re: I need a search function for my access database.

    You just need to use odbc functions to search access database. For th9is you need to connect inquiry html form to ms access data base. Simple.
    Since your question is not clear Please have a look at this too if you mean the way to search like text search.
    Searching for Text Information in Databases
    Database search & text search

  3. #3
    Join Date
    Apr 2008

    Re: I need a search function for my access database.

    Hey Please you have a look at this webpage.
    I am quite sure that you will like to know & learn Ms Access & the search function tutorial provided here.

    Hope this helps you.

  4. #4
    Join Date
    Apr 2008

    Re: I need a search function for my access database.

    You basically have one question for each type of investigation you want. For example, if you want to be able to search for names, then drafting a demand that the user / client / customer list also examine what the data means. The criteria of this question is the Name Criteria, and is based on the field on the form where the user types in their research. (The same thing is done for other types of investigations such as last name, that of birth, anything you like, only one question, and the criteria to decide the control of the create). NOTE. TO MAKE SURE TO INCLUDE THE NUMBER OF IDENTITY. Then a command or button for each field, or as in this example a drop down box with a list of values specify which area of research. (I'll explain the example used here) even in the OnClick command button, the code checks to see if a selection in the combo box or something or is addressed in the research criteria. If one of them is empty, it displays an error message that this list and does not go. If they both have a value, then checks the value in the combo box is. For example combo box's value is Name, then the IF statement (would COMPUTER-AIDED SOFTWARE ENGINEERING also may be) running. Now it can check, it must know what to do. As before, the drafting questions, you should also study a form for each establishment. In the form, take a list box on, and base it on the list box of your research question. Now in the main form, when the button click is if the combo box selection statement to check, and then simply open the appropriate form. The results form then opens, you or an OnClick, OnDoubleClick or even on the list box is set. This value would simply have to take in the list box is selected (the identity area as lack of demand as the first one is to make it so easy should) open the main form, and go to that the number of identity card report. All code for this is that sample, so this will hopefully easier to understand little lights. If you have anything still unsure then just let me know. Happy to try to clarify and explain a little

Similar Threads

  1. Quick search Function in Opera with different Search engines?
    By Oorja in forum Technology & Internet
    Replies: 2
    Last Post: 23-02-2012, 04:53 PM
  2. Replies: 3
    Last Post: 11-12-2010, 10:45 PM
  3. Open and print Access Database without access?
    By Boagrius in forum Software Development
    Replies: 6
    Last Post: 28-08-2010, 11:28 PM
  4. Search Access Database in Windows XP
    By Doroteo in forum Windows Software
    Replies: 3
    Last Post: 04-11-2009, 10:19 PM
  5. convert filemaker pro database to access database
    By Czack in forum MS Office Support
    Replies: 3
    Last Post: 15-04-2007, 01:06 AM

Posting Permissions

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