MISSING OPERATOR IN QUERY EXPRESSION

[sanders720]

OBJECT =

SELECT DISTINCT * FROM tblStockList WHERE ITEM = 0000037 and CODE = OB and DESCRIPTION = 1 1/2 X 2 X 11 GA TUBE A500


with rs...

.Open OBJECT, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\deepblue\EngineeringBOM\Data\EngineeringBOM_data.mdb;Persist Security Info=False", adOpenStatic, adLockOptimistic

Produces an error or MISSING OPERATOR IN QUERY EXPRESSION

Please advise... Do I need additional quotation marks in the OBJECT variable definition, or is there another issue?

Thanks in advance for the help!!!

 

[vb6novice]

The SELECT statement you provided has neither quotation marks or parenthetical division. You will definitely need them for the SELECT statement to evaluate properly. It should probably read:

OBJECT = "SELECT DISTINCT * FROM tblStockList WHERE (((ITEM = '0000037') And (CODE = 'OB') And (DESCRIPTION = '1 1/2 X 2 X 11 GA TUBE  A500')));"