Results 1 to 2 of 2

Thread: showing all records

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2000
    Posts
    15

    Question

    Hi,

    I figured out how do display an individual record from a database. I CANT FIGURE OUT HOW TO SHOW ALL THE RECORDS IN THE SAME WAY!Private

    Sub cmdGet_Click()
    Dim sName As String
    sName = InputBox$("Please enter your name:")
    Set RS = DB.OpenRecordset("SELECT * FROM Contact WHERE Name = '" & sName & "'", dbOpenDynaset)
    txtName = "" & RS!Name
    txtPhone = "" & RS!Phone
    txtNotes = "" & RS!Notes
    RS.Close
    End Sub

    Help!

    Aknighter

  2. #2
    Hyperactive Member barrk's Avatar
    Join Date
    Sep 2000
    Location
    My own little world
    Posts
    274
    Try a grid instead of a text box. Set your grid's datasource to your recordset using ado and you're good to go!

Posting Permissions

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



Click Here to Expand Forum to Full Width