Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Mar 2005
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Access - searching in a form

    Let's say I have created a form. It has the following fields:

    1. Last name
    2. First name
    3. date of birth.
    4. A search button.
    5. Radio buttons which let a user to choose the search criteria.(i.e by last name, first name or date of birth).

    How do I implement the search feature in Access.

    Also let's say I have 10 students in a class. I would like to search by class number - lets say the number is 100. Once I wrote in a textbox 100 a window will pop up with the list of the students. Once I choose a student his information appears in appropriate textboxes like his first name, last name, school id etc...

    I would appreciate any help.
    Thank You.

  • #2
    Regular Coder Freon22's Avatar
    Join Date
    May 2005
    Location
    USA
    Posts
    287
    Thanks
    3
    Thanked 5 Times in 5 Posts
    I set up a access 2000 database for the company that I work for. That was a few years ago. I know that in my form I set the search button up with the control F key. Tomorrow I will look it up for you, its done with macros. I know that everything you have ask for can be done with access. I just don't know if I can help you enough to get it all done.

  • #3
    Regular Coder Freon22's Avatar
    Join Date
    May 2005
    Location
    USA
    Posts
    287
    Thanks
    3
    Thanked 5 Times in 5 Posts
    Ok its a new day. I looked up the database that I had setup. I have a Search button, delete record button, and a few other on it. Each one was a pain for me to get working. Between posting on forum like this one and reading books on MS access, I was just able to get it to work. So I'm not going to be of any help. The best thing I can say is to buy a good book on access and take it one step at a time. Also if you already have data in your database make sure you make a backup copy before you start.

  • #4
    New Coder
    Join Date
    Mar 2005
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok. Thank you.


  •  

    Posting Permissions

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