Syntax error in query expression vba

Hi all, I am struggling with a set of VBA coding that a previous person on the project was using. I am fixing their mess and i cannot for nuts. Here is the error that I got: Syntax error in date in query expression ' tblReserve. studID= tblStudents. StudNumber and tblReserve. RESOLVED] Syntax error ( missing operator ) in query expression. dglienna is offline ex MVP - Visual Basic Power Poster. Syntax error ( missing operator) in query expression General. Also the Syntax error normally points to the query that forms the Record. operator in query expression, frispee, Modules & VBA, 3, : 18 AM.

Esxi fatal error 33 inconsistent data

Robocopy system error 85

System error 4097

Php fatal error uncaught error call to undefined function eregi

Syntax error in insert into statement visual basic 2010

Video:Error expression syntax

Expression query error

When you run this query, you receive the following error message: Syntax error ( missing operator) in query expression ' TableName. Hi I have the following error message " Syntax Error ( missing operator) in query expression" occurring when I am trying to update combo box. Hi, I have an access db that I am trying to query from a vb6 program. I' ve the following code: Dim sSQLQuery As String sSQLQuery = " SELECT. I have a simple Access Database with 1 table and multiple forms that feed data into the table. One of my forms is open in datasheet view and. Syntax error ( missing operator) in query expression. It' s been a long time since I messed with DAO and VBA, so I could be mistaken.