problem with syntax error message, says its missing operator help

K

koi

I have just started setting up a database and I have a command button on data
entry form. When I tried to set up the expression for it all seems fine but I
get an error message when I try to run. It says there is a syntax error
(missing operator) in query expression 'Data Concerning Program
Changes.[ID].' I can not figure out what I am doing wrong. I am not sure what
the missing operator is in this expression. Can anyone help.
 
E

Eric D via AccessMonster.com

Try enclosing your field in brackets
[Data Concerning Program Changes].[ID]

If that doesn't work, you need to provide a copy of the query. Open the query
in design mode, find the View icon on the Tool Bar... under File and click on
the down arrow. Select SQL View. You should now see the SQL version of your
query. Copy it and Paste it into your question here.
I have just started setting up a database and I have a command button on data
entry form. When I tried to set up the expression for it all seems fine but I
get an error message when I try to run. It says there is a syntax error
(missing operator) in query expression 'Data Concerning Program
Changes.[ID].' I can not figure out what I am doing wrong. I am not sure what
the missing operator is in this expression. Can anyone help.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"The operation cannot be performed because the object has been deleted." 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Syntax error in DLookup expression 6
Syntax Question 2
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
syntax error 1
syntax error missing operator in command button 2
Errors 2448 and 3075! 1

Top