Strange query behaviour

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that will not run, it does save ok with no syntax error. When I open it nothing happens and I get no error message. Any ideas?

When I run it in code, I have a docmd.close after the query runs and it displays a message "you can't do this at this time", no other information.

Anyone got a clue?
 
I have a query that will not run, it does save ok with no syntax error. When I open it nothing happens and I get no error message. Any ideas?

When I run it in code, I have a docmd.close after the query runs and it displays a message "you can't do this at this time", no other information.

Anyone got a clue?
Click to expand...

Could you please give us a little help?

Please open the query in SQL view and post the SQL text here; and
describe what you want/expect the query to do - is it a select query
that you want to open as a datasheet, an action query that you want to
update something, or what?
 
Back
Top