insert into a table from a from field in ms access

mana · Apr 13, 2015

Hello

i want to insert the values from a from field into a table i wrote the below code but it doesn't work can you help me pleasE?
i want to add some values from other forms but i don't know what to write cna you help please?

DoCmd.RunSQL (" insert into tbl_userinformation (Anwendung) values (" & Me.Label135 & ");")

and the error is :
object doesn't support this property or method
thank you

CJ_London · Apr 13, 2015

labels do not have a value, you need to use a textbox or any control which does have a value (e.g. combobox)

mana · Apr 13, 2015

hello

thank you for the answer
i also wrote the below code but i have error in below line
i don't know what to write instead of that
can you help me please?

Dim db As Database
Dim rec As Recordset
Set db = CurrentDb
Set rec = db.OpenRecordset("Select * from tbl_userinformation")
rec.AddNew
rec("Anwendung") = Me.Label135.Caption
rec("actualdate") = !Forms!frm_main!Text0.Value

rec.Update
Set rec = Nothing
Set db = Nothing

JHB · Apr 13, 2015

You've a ! in front, remove it.

mana said:
rec("actualdate") = !Forms!frm_main!Text0.Value

Else write the error number and description!

insert into a table from a from field in ms access

mana

Registered User.

CJ_London

Super Moderator

mana

Registered User.

JHB

Have been here a while

Similar threads

Users who are viewing this thread