Inserting into table problem

[sike11 via AccessMonster.com]

Hi,

I have the following piece of code in my Add Record click:

str = "Insert into tblQOEDescription(Qualification_Reference,
Qualification_Name)"
str = str & "VALUES('""QoE-" & Me.txtQualref & "'" & "," & "'""Qual on
Entry " & Me.txtQualName & "'" & ");"
CurrentDb.Execute str

It inserts the values I want, but encases the beginning of the fields with
double quotes(") which I do not want.

Eg. the table looks like:

Qual Ref Qual Name
"AS-ADVACC "AS Advanced Access

Can anybody help?

Thanks in advance.

 

[Guest]

str = "Insert into tblQOEDescription(Qualification_Reference,
Qualification_Name)"
str = str & " VALUES('QoE-" & Me.txtQualref & "', '" & "Qual on
Entry " & Me.txtQualName & "');"

 

[sike11 via AccessMonster.com]

Thank you Klatuu,

I managed to solve it with a friend's help!! But thank you - it confirms what
he recommended!

str = "Insert into tblQOEDescription(Qualification_Reference,
Qualification_Name)"
str = str & " VALUES('QoE-" & Me.txtQualref & "', '" & "Qual on
Entry " & Me.txtQualName & "');"

Hi,

[quoted text clipped - 17 lines]

Thanks in advance.

 

[Guest]

Your friend is obviously Knowledgable and Intelligent

Thank you Klatuu,

I managed to solve it with a friend's help!! But thank you - it confirms what
he recommended!

str = "Insert into tblQOEDescription(Qualification_Reference,
Qualification_Name)"
str = str & " VALUES('QoE-" & Me.txtQualref & "', '" & "Qual on
Entry " & Me.txtQualName & "');"

Hi,

[quoted text clipped - 17 lines]

Thanks in advance.

 

[sike11 via AccessMonster.com]

Hi Klatuu,

Sorry for the late response..

Will pass the message on, but I am afraid he will get a swelled head!!!

Your friend is obviously Knowledgable and Intelligent

Thank you Klatuu,

[quoted text clipped - 11 lines]