VBA SQL Syntax Problems

Question

I have the following SQL:

SQL = "UPDATE [TBLTMP] SET TBLTMP24 '" & Me.TOWN & "' WHERE TBLTMP00 = '" & "1" & "';"


Table name TBLTMP
Field to update TBLTMP24
Record to update TBLTMP00

I want to store the value of ‘Me.Town’ in the field TBLTMP24 which is in the table TBLTMP, record number 1, anyone have any ideas what might work?

Gareth · Accepted Answer · 2014-07-17 11:13:11Z

1

You're missing an = in your SQL Statement after TBLTMP24. You're statement should be:

SQL = "UPDATE [TBLTMP] SET TBLTMP24 = '" & Me.TOWN & "' WHERE TBLTMP00 = '" & "1" & "';"

answered Jul 17, 2014 at 11:13

Gareth

5,2636 gold badges47 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bla... · Accepted Answer · 2014-07-17 11:13:57Z

0

I think all you need is to add = into your query, like below:

SQL = "UPDATE TBLTMP SET TBLTMP24 = '" & Me.TOWN & "' WHERE TBLTMP00 = '" & "1" & "';"

If you want to change some columns add commas, like below:

SQL = "UPDATE TBLTMP SET TBLTMP24 = '" & Me.TOWN & "', another_col = '" & Me.another & "' WHERE TBLTMP00 = '" & "1" & "';"

answered Jul 17, 2014 at 11:13

Bla...

7,2887 gold badges30 silver badges47 bronze badges

Collectives™ on Stack Overflow

VBA SQL Syntax Problems

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related