insert into a table from

[mana]

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

i have the following error

invalid or unqualified refrence

can you help me please?
thank you

 

[CJ_London]

duplicate thread - here

http://www.access-programmers.co.uk/forums/showthread.php?p=1422252#post1422252

 

[JHB]

Read you other thread.