Thank you. I have Office 2019 and it is working well. But I have a strange behavior in the query searching for something. Sometimes I get Syntax error.... and the dialogue box opens, and I cannot close it by pressing ok or the X button, then I have to long press the Esc key and the error message box is deleted. Then I highlight the wrong syntax text and delete it. Now the field is blank, but as soon as I start typing something, the error box comes with the first letter of what I am typing. I found that if I click in different column in the query then go back to the first column and I start typing, things go well. When I delete the syntax field, I tried the Backspace and delete buttons, same result. Any idea?
Scott Axton
@Reply 3 years ago
A syntax error usually means that you either spelled something wrong or didn't supply all of the necessary items needed for a function. It's too difficult to try and guess what is going on.
Please post some screen captures of your query, in design mode.
Is being processed as part of a Macro or VBA? It would also be helpful if you post a picture of the exact error message you are receiving.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
