Create a Insert into From scratch for newbie

[ryoka012]

Hi,

Can anyone put me to the right direction in creating a vba in access
i have sample vba in click event using command button.

Private Sub cmdSaveRecord_Click()
Dim daDb As DAO.Database

Set daDb = OpenDatabase("J:\ContainerVerification.accdb")
daDb.excute = "insert into CLEARANCE (FName,LastName)" _
                         & "values(txtfname,txtLastname);"

what are the missing syntax in my code.

Thanks.


End Sub

[orange]

Where do txtLastname and txtFname get values? Where are they Dimmed?

You will probably need something like this - if these are controls on your form.
"insert into CLEARANCE (FName,LastName)" _
& "values('" & txtfname & "','" & Me.txtLastname & "');"

[pbaldy]

Plus it's Execute, not excute.

[ryoka012]

i will get it on a textbox..

[ryoka012]

I have an error saying.

Compile error:

Argument not optional

it has been pointing on daDb.Execute

Can anyone point me on the right direction.

[orange]

Remove the = sign and try it.

Google ms access db.execute

[ryoka012]

I have an error saying.

Compile error:

Expected user:defined type, not project

it has been pointing on dim msdb as database

Can anyone point me on the right direction.

[pbaldy]

Try

dim msdb as DAO.database

[orange]

ryoka12,

Please show us your latest code.