Guys, patulong naman sa mga master jan panu ba yung code na once click ko yung data sa datagrid mapupunta sa textbox yung details?
datafield and datasource?
- - - Updated - - -
guys pls help me po .. paano po ba plalabasin yung autonumber sa msaccess sa vb? once po kasi na mag aadd ng record dapat ilalabas po ni vb yung auto increment nya,, naka auto increment na po yung msaccess.. using adodc connection po
heto po code ko
Adodc1.Refresh
Adodc1.Recordset.MoveFirst
Do While Adodc1.Recordset.EOF
If Adodc1.Recordset.EOF = True Then
Text5 = Adodc1.Recordset("stdno").Value + 1
Exit Do
End If
Loop
Adodc1.Recordset.AddNew
Adodc1.Recordset("stdno").Value = Text5
Adodc1.Recordset("studname").Value = Text1
Adodc1.Recordset("age").Value = Text2
Adodc1.Recordset("bday").Value = Text3
Adodc1.Recordset("course").Value = Text4
Adodc1.Recordset.Update
R = MsgBox("record has been sucessfully added!", vbOKOnly)
Label2 = ""
Text1 = ""
Text2 = ""
Text3 = ""
Text4 = ""
Text1.SetFocus
Adodc1.Refresh