Insert into?

[irade92]

Hi
why this doesn't work
mATC_FULL = "escitaloptam tabl. 20 mk"
DoCmd.RunSQL "INSERT INTO tblXML_LEKOVI_KOM (GENERIKA_FULL) VALUES (" & mATC_FULL & ")"

field GENERIKA_FULL is text

 

[arnelgp]

...VALUES ('" & mATC_FULL & "')"

 

[MajP]

May want to look at my discussion for why and the CSql function.

Get Filter from Controls, CSQL, and Combine Multiple Filters

If you follow my threads, I try to demonstrate how to write code that is flexible, generic, encapsulated, fault proof, and debuggable. My goal is always to try to write code once that can be re-used often and everywhere. I do this in functions, procedures, and class modules. This may require...

www.access-programmers.co.uk

 

[irade92]

...VALUES ('" & mATC_FULL & "')"

Thanks