Syntax error

[nate0057]

Hi everybody,

I have a problem when I launch my program, this error appears:

"Syntax error (missing operator) in query expression 'AMFLIBP_MOROUT.ORDNO="M794840" AND AMFLIBP_MOROUT.PRVAL='

What can I do?
What's the problem?

Thanks a lot

 

[pr2-eugin]

The only explanation that seems fair here is that the default Form, that is set to be loaded on start up is looking into a Query that is causing this error..
Or there is a AutoExec Macro that is running the Query that has the error..

Try SHIFT+Double Clicking the application to bypass AutoExec Macro.. (Keep holding the SHIFT until the Access application loads).. Post back if this is of any success..

 

[boblarson]

It night be a query or a filter or a rowsource of a combo or list box, or code in an event on the opening form. But whatever it is, is trying to do so with something that doesn't have a value at the time.

 

[nate0057]

It doesn't work but thanks.

Does it help you If I post a screen shot about the local table to see what's happened?

 

[boblarson]

It doesn't work but thanks.

Does it help you If I post a screen shot about the local table to see what's happened?

What doesn't work? Please be more specific.

 

[nate0057]

What doesn't work? Please be more specific.

I've tried that pr2-eugin adviced me and nothing changed.
The term 'PRVAL' is often equal to zero in my table, so maybe it's the reason of my problem.

 

[pr2-eugin]

Is it possible to post a stripped down version of your DB? Are you able to get inside your DB? If so check the Query..