Syntax error in sql 1

[ParyGoal]

Hello everyone
I am getting a syntax error in the sql statment while updating the database. I can't seem to find an error.
Below is the update statement I am using

TmpString = ""
TmpString = "UPDATE tblUserGroups "
TmpString = TmpString & " SET FirstName = '" & Apostrophe(ProperCase(Trim$(TextBox(0).Text))) & "', "
TmpString = TmpString & "LastName = '" & Apostrophe(ProperCase(Trim$(TextBox(1).Text))) & "', "
TmpString = TmpString & "UserFullName = '" & Apostrophe(ProperCase(Trim$(TextBox(2).Text))) & "', "
TmpString = TmpString & "MidInit = '" & Apostrophe(Trim$(TextBox(3).Text)) & "', "
TmpString = TmpString & "strUserName = '" & Apostrophe(Trim$(TextBox(4).Text)) & "',"
TmpString = TmpString & "Password = '" & Apostrophe(Trim$(TextBox(5).Text)) & "', "
TmpString = TmpString & "Access_Level = '" & Apostrophe(ProperCase(Trim$(ComboBox(0).Text))) & "', "
TmpString = TmpString & "TitleID = " & lngTitle & ", "
TmpString = TmpString & "WHERE strUserName = '" & tmpUserName & "'"

Does anyone see a problem with this update statement?

Thank you

ParyGoal

 

[gmmastros]

It'll be easier for us to help you if you tell us...

1. What database are you using?
2. What is the exact wording of the error message
3. What the resulting TmpString looks like just prior to executing this.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ParyGoal]

Hi George

Very good questions.


I am using an access database.

Error message

Microsoft ODBC Microsoft Access Driver Syntax error in Update Statment
Err # -2147217900

Resulting TmpString

UPDATE tblUserGroups SET FirstName = 'Sam', LastName = 'Samula', UserFullName = 'Sam Samula', MidInit = 'M', strUserName = 'Ssamula', Password = '22222', Access_Level = 'Administrator', TitleID = 18, WHERE strUserName = 'Ssamula'

It looks like it's adding a comma before the where clause ,which is not allowed.

 

[gmmastros]

So... you found it yourself. Congratulations.

TmpString = TmpString & "TitleID = " & lngTitle & "[!],[/!] "

Just remove that comma (highlighted in red).

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ParyGoal]

Thank you George very much for your help.
It did the trick.

Tarik