Jump to content

Syntax error (missing operator) in query expression

Recommended Posts

  • 1 month later...

MS Access is the database used for HomeManage. As someone who use to write code in MS Access, I'm aware that the single quote can cause issues when the app tries to save it to the database if it is not treated properly. There is nothing you can do, It's a bug. The same is true for the & -- it is a special character that has meaning on MS Access forms and it cause the exact results you found -- to put an underscore under the character following it. These characters have to be treated specially within the program in order to get saved properly in the database. They are bugs.

Link to comment
Share on other sites

Join the conversation

You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...