var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL VBA Error
I'm trying to run an SQL query that I built using the design view in MS Access, by using VBA, as i plan to add in variables but when I run it I get an error.
I'm not sure what if anything is wrong.
I've attached a screen shot of the code and an error.
I don't see your screen shot....
It wasnt showing for some reason I'ev loaded it again
Looking at the screen shot (not so good for copying code!) it looks like you need a space before WHERE, it probably thinks this is part of the join expresseion. There may be other spaces missing!
Add a space to the end of each line except for the last. Let us know if that works for you...