vba Sql question

[Norman Fritag]

hi there,

StrSql = "UPDATE TblResults SET TblResults.DOHID = " & intnum1 & _
" ,TblResults!AHS = " & chr(34) & txtAHSto & chr(34) _
& " WHERE (((TblResults.DOHID)=& " Intnum2 & "));"

what's going wrong with this sql statement. It produces an error at the
textstring. saying ... 'AHStext". error??

any hints??

Regards

Norman

[Jeffrey R. Bailey]

I just did a quick cursory scan, so give this answer that amount of weight,
but it looks like the "!" should be a period in the section of your SQL: "
,TblResults!AHS = "

If this works out to be the problem, then formatting the code for your SQL
string a little differently should enable you to tell the difference between
the SQL portion of the string and the VBA code to supply values/arguments
dynamically.

--
Jeffrey R. Bailey
"Norman Fritag" <mt*****@ozemail.com.au> wrote in message
news:hQ***************@nnrp1.ozemail.com.au...

hi there,

StrSql = "UPDATE TblResults SET TblResults.DOHID = " & intnum1 & _
" ,TblResults!AHS = " & chr(34) & txtAHSto & chr(34) _
& " WHERE (((TblResults.DOHID)=& " Intnum2 & "));"

what's going wrong with this sql statement. It produces an error at the
textstring. saying ... 'AHStext". error??

any hints??

Regards

Norman

[Peter Chong]

Correction
& " WHERE (((TblResults.DOHID)=" & Intnum2 & "));"

"Norman Fritag" <mt*****@ozemail.com.au> wrote in message news:<hQ***************@nnrp1.ozemail.com.au>...

hi there,

StrSql = "UPDATE TblResults SET TblResults.DOHID = " & intnum1 & _
" ,TblResults!AHS = " & chr(34) & txtAHSto & chr(34) _
& " WHERE (((TblResults.DOHID)=& " Intnum2 & "));"

what's going wrong with this sql statement. It produces an error at the
textstring. saying ... 'AHStext". error??

any hints??

Regards

Norman

[Dave]

"Norman Fritag" <mt*****@ozemail.com.au> wrote in message news:<hQ***************@nnrp1.ozemail.com.au>...

hi there,

StrSql = "UPDATE TblResults SET TblResults.DOHID = " & intnum1 & _
" ,TblResults!AHS = " & chr(34) & txtAHSto & chr(34) _
& " WHERE (((TblResults.DOHID)=& " Intnum2 & "));"

what's going wrong with this sql statement. It produces an error at the
textstring. saying ... 'AHStext". error??

any hints??

Regards

Norman

Hi Norman,

Just looking at you code briefly, it seems that the '&' is out of
place on your last line. Hope that's it???

& " WHERE (((TblResults.DOHID)= " & Intnum2 & "));"

FYI- I just recently learned that in SQL code you can replace Chr(34)
with a single quote. For example, your middle line:

" ,TblResults!AHS = '" & txtAHSto & "'"

Good Luck...

Dave

[James Fortune]

Da***************@SunLife.com (Dave @ SunLife) wrote in message news:<4e**************************@posting.google. com>...

"Norman Fritag" <mt*****@ozemail.com.au> wrote in message news:<hQ***************@nnrp1.ozemail.com.au>...

hi there,

StrSql = "UPDATE TblResults SET TblResults.DOHID = " & intnum1 & _
" ,TblResults!AHS = " & chr(34) & txtAHSto & chr(34) _
& " WHERE (((TblResults.DOHID)=& " Intnum2 & "));"

what's going wrong with this sql statement. It produces an error at the
textstring. saying ... 'AHStext". error??

any hints??

Regards

Norman

Hi Norman,

Just looking at you code briefly, it seems that the '&' is out of
place on your last line. Hope that's it???

& " WHERE (((TblResults.DOHID)= " & Intnum2 & "));"

FYI- I just recently learned that in SQL code you can replace Chr(34)
with a single quote. For example, your middle line:

" ,TblResults!AHS = '" & txtAHSto & "'"

Good Luck...

Dave

Make sure you test what happens when txtAHSto contains a single quote first.

James A. Fortune