CODEWITHSUNDEEP
vbams-access
Jerry
Jerry

Reputation: 1

SYNTAX ERROR (MISSING OPERATOR) QUERY EXPRESSION

I get this error when I start up an Access application. Trying to find the offending SQL statement, I put a "STOP" command in the form load event. The error appears before the STOP COMMAND is executed. I have erased all my SQL statements in the application and yet, I still get the error when I start up the program and before the form loads. I have also decompiled and recomplie the program.

Any help out there?

Best regards,

Jerry

Upvotes: 0

Views: 98

Answers (1)

AHeyne
AHeyne

Reputation: 3455

There are some possibilities where SQL statements can be in:

  • Record Source of forms/reports.
  • Control Source of combo or list boxes for example.
  • In newer Access versions also local tables can have lookup queries.
  • ...

You should take a look allover there.

Another approach is to save objects (forms, reports, tables, macros and so on) to text files, and then search in those text files for SQL statements.

As an example: This is the command to save the form AnyForm to a text file AnyForm.txt:

Application.SaveAsText acForm, "AnyForm", "c:\AnyForm.txt"

Upvotes: 2

Related Questions