How do i code in DAO and ADO?
Posted on 2002-03-16
Hi, i'm a student doing my project and would really appreciate any of you experts out there to help
me with my Visual Basic Coding. Include below is my coding page for a form name add new user. Can somebody
tell me what is wrong with my coding (assuming that i have tick in the relevant references for DAO method.)
Dim mydb As Object, myset As Object
Private Sub cmdCancel_Click()
frmWelcome.Visible = True 'This will enable the user to return to the welcome page
Private Sub cmdNext_Click()
frmNewPrint.Visible = True
Set mydb = openDatabase("C:/My Documents/Double Module/dbSys.mdb") 'This sets the program to open the
Set myset = setmydb
On Error Resume Next 'If any error occurs, the program will automatically skip the current, and move
on to the next data
myset!Name = txtName.Text
myset![FingerID No] = txtFingId.Text
myset!Position = txtposition.Text
myset!Department = txtDept.Text
myset![Date joined] = txtdate.Text
If txtName.Text = "" Then
MsgBox ("Please fill in your name")
ElseIf txtFingId.Text = "" Then
MsgBox ("Please fill in your assigned FingerID Number")
ElseIf txtposition.Text = "" Then
MsgBox ("Please fill in your position in this firm")
ElseIf txtDept.Text = "" Then
MsgBox ("Please fill in the department you work in")
ElseIf txtdate.Text = "" Then
MsgBox ("Please fill in the date you started, start with the day,month, then year")
txtName.Text = "" 'This command will set the fields to be empty for the next data transaction
txtFingId.Text = ""
txtposition.Text = ""
txtDept.Text = ""
txtdate.Text = ""
i have problems running this. CAn anyone tell me what's wrong. And if i want to re write it using ADO,
how would it look like? i'm very new to ADO concept but i heard that it supports microsoft Access 2000.
Plz help.. urgently needed