Microsoft Access 2016 syntax error when openining Design View in queries

William 361 Reputation points
2021-01-29T16:07:55.79+00:00

Dear All,

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

61924-image.png
61810-image.png

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

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
859 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. C Data 6 Reputation points
    2021-02-02T23:30:39.997+00:00

    (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...

    0 comments No comments