Microsoft Access 2016 syntax error when openining Design View in queries

Question

Dear All,

I have the below error messages when I try to open a Design View in a few Queries.

I tried to repair Office 2016, uninstall and reinstall with no avail.

I copied the Access program to another compter and run it. Everything worked normally.

Can you please help me to understand what's wrong on that specific computer?

Thank you in advance.

Regards,
William

Answer 1

Hi

Thank you for your reply.

I finally fixed it with OffScrubscript provided by the support.

Regards

Answer 2

(pDate Now())

stands out because Now also includes Date

yes it's weird that it errors on one but not another

sanity check by removing the format clause and temp replace it just a date or Now() and see that it works...then fine tune your format syntax...