VBA / Visual Basic. Simple String SQL

Question

I'm creating a Voting System. so it's like this every time A Button1 is pressed + 1 or it will increase the vote in the Access database. I can't find anything in Google.

trx = "update [Table1] SET [Vote] = Vote + 1, (WHERE ID = 1)"

What's the question? Where do you get stuck?

neelsg
– neelsg

2015-01-22 13:55:33 +00:00
Commented Jan 22, 2015 at 13:55 — neelsg
– neelsg, Commented Jan 22, 2015 at 13:55

HansUp · Accepted Answer · 2015-01-22 13:56:15Z

4

Don't include a comma before the WHERE clause. Also you don't need to put the WHERE clause inside parentheses.

Test this as a new query in the Access query designer.

update [Table1] SET [Vote] = Vote + 1 WHERE ID = 1

Fine tune as needed. And once you have it working in the query designer, adapt your VBA code to use that working statement.

answered Jan 22, 2015 at 13:56

HansUp

97.3k11 gold badges80 silver badges139 bronze badges

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

Comments

HaveNoDisplayName · Accepted Answer · 2015-01-22 13:58:34Z

1

Remove comma before Where and brackets around where clause

trx = "update [Table1] SET [Vote] = Vote + 1 WHERE ID = 1"

answered Jan 22, 2015 at 13:58

HaveNoDisplayName

8,537106 gold badges41 silver badges50 bronze badges

Collectives™ on Stack Overflow

VBA / Visual Basic. Simple String SQL

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