1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to search an access database

Discussion in 'MS Access' started by meetmaruthi, Apr 1, 2006.

Thread Status:
Not open for further replies.
  1. meetmaruthi

    meetmaruthi New Member

    Joined:
    Apr 1, 2006
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    i have 13 fields in my access table.it stores the admission information of a table.now if i click open on particular form it shows a dialog box .it contains a textbox in which i type the admission number of student. i need the particular record associated with it and i want all records to be retrieved into respective texboxes.

    I am using data1 control on form to connect to ms access and vb 6.0
    pls help me
     
  2. coderzone

    coderzone Super Moderator

    Joined:
    Jul 25, 2004
    Messages:
    734
    Likes Received:
    37
    Trophy Points:
    0
    Either you need to be firing the SQL or you need to be matching them by moving through each id in the data control.
     
  3. rahulnaskar

    rahulnaskar New Member

    Joined:
    Aug 26, 2004
    Messages:
    25
    Likes Received:
    2
    Trophy Points:
    0
    possibly, the easiest one is to change the sql of your data control and make it like:

    "select * from <table> where <field1> = <value>"

    where table is your table name, field1 is the field you want to search and value is the value supplied by user, and refresh the data control. You will be having the desired record in shortest possible time and can refresh the form with retrieved fields.

    Hope this helps...

    Rahul
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    Duplicate of [thread=674]How to search an access database[/thread]
     
Thread Status:
Not open for further replies.

Share This Page