Access: the code contains a syntax error

Question

When I try and place a command button on a form I get the following message:

Answer 1

Ok, That is a constant and the full command should be:

DoCmd.RunCommand acCmDRecordsGotoNew

It would definitely be a syntax error if it stood alone. It could also be a syntax error if it is used where you can't add a new record.

And yes, a compile error could interfere with a control wizard. Try commenting out the offending line (put an apostrophe in front of the line) and see if fixes the problem.

Answer 2

I no longer can compile (grayed out). I tried deleting the form and redoing, and when i place the buttom, it gives me the same error. The button is intended to save the entered record, but i never get that far because of the pop up. 

Why can't i compile now?

Answer 3

Hmm, this is odd.  Have you tried running Repair?  Sounds like the wizard may have gotten corrupt.

Answer 4

The Compile option being grayed out means that the compile completed successfully and there are no more syntax errors. If you make a change in the code, the Compile option should return.

But if the problem persists, then that's not the issue. So we need to move on. Does this happen on other databases? Can you create a new blank database and see if the problem persists? If it does, I would do a repair of Office.

This is an unusual problem and may take some investigation to resolve.

Answer 5

I have run compact and repair under "Info". I have also gone out to office/setup and reinstalled the apps. I do notice that Access is not included in Office 365 Home edition, but is available for the PC only. I believe that Office was installed on the computer when i purchased it and i just activated it. I have run regedit and cannot find where Office (Access) is registered. Is that a problem? Thanks for your help.