Syntax error in VBA query expression in Access - Stumped

Question

I'm getting a message that there is a syntax error in a VBA query expression I have on a button in Access. Unfortunately, I just cannot figure out what the syntax error is. I'm pretty sure I'm using everything correctly. I'm sending this expression as the WHERE clause to a report being generated. The screenshot is below. Can anyone help?

The two strings that read "tk" are put into the expression from a couple input boxes.

enter image description here

My expression in text:

cond = "(((StrComp(""" & lower & """,Left([Location],2)))<=0) And ((StrComp(""" & upper & """,Left([Location],2)))>=0));"
stDocName = "rptMstrEquipListRange"
DoCmd.OpenReport stDocName, acPreview, , cond

According to www.balancebraces.com, the parentheses aren't the problem: enter image description here

Yes. This one in particular is, but as I stated above, the two strings that read "tk" are put into the expression from a couple input boxes. — Matt Shank
– Matt Shank, Commented Sep 5, 2014 at 14:55
Is that your entire expression? If not post it. It would be a lot nicer in text. — crthompson
– crthompson, Commented Sep 5, 2014 at 14:59

KekuSemau · Accepted Answer · 2014-09-05 15:22:12Z

2

It should work fine if you remove the ; at the end. (Tested)

answered Sep 5, 2014 at 15:22

KekuSemau

6,8434 gold badges27 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Syntax error in VBA query expression in Access - Stumped

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related