How to search an access database

Discussion in 'Visual Basic ( VB )' started by meetmaruthi, Apr 1, 2006.

  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:
    736
    Likes Received:
    38
    Trophy Points:
    28
    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
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice