Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Exclamation Unanswered: lookup data and change field

    hi...i need to lookup data in an access database by a unique field, display the data, then change a certain field...does anyone have an idea on how to start this project?...i need to open a database, display the row, and change one using access this a correct way to open?...

    Private Sub Form_Load()

    'Create and set the Recordset object
    Set objRec = New ADODB.Recordset
    Set objRec.Source = objComm
    objRec.LockType = adLockOptimistic

    'set cursor type
    objRec.CursorType = adOpenDynamic

    Set objConn = New ADODB.Connection
    objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & "Data Source=C:\test\test.mdb"
    Set objRec = objConn.OpenRecordSet("Orders")

    End Sub


    thanks for your time...
    Last edited by vpdb; 08-03-04 at 16:20.

  2. #2
    Join Date
    Jul 2004
    can u make it more precise? i mean how the data to be displayed, on what control or something then what specific fields..just give example...tired of thinking any example right now...

Posting Permissions

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