Search
Guyz,, need help
pwede ko ba maiconnect ang project ko sa MS database from the server computer
client-server kc project q pero ms access database q.. asap..
tnx...
i.e. I called data from access txtStudName.Text = rs!Student_name.. kung walng laman ung feild na Student_name "invalid use of null" shows up..
test the field if is null or not before passing to the control
If Not IsNull(rs("Student_name")) Then
txtStudName.Text = rs!Student_name
End If
what should i do with this error,.. if my MSaccess db has no field value is there any extra code to be written on my form to skip to next validation?? anyone here who can help.. thanks! i.e:
hi there!
First, you need to make connection string of your data base from your vb project,,like this
Public cn As ADODB.Connection
Public rs As New ADODB.Recordset
Public Sub myCon()
Dim mDataSource As String
mDataSource = "database/kiosk.mdb"
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.CommandTimeout = 0
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mDataSource & ";Persist Security Info=False"
Set rs = New ADODB.Recordset
End Sub
hope makatulong ito sa problema mo..
guys help how to connect vb sa access database.. enrollment system kc project qoh.. plz..
i have a problem using imagebox to search and retrive data from ms access.
pls help