Open Query

[Bill]

Hi everyone,

I'm able to open the query by clicking "Ok" command button but I am trying
to make the pop up from the list of tables on Query Screen automaticly
rather than clicking a button to get a list of tables.

After running the query, is there a way to turn the query into snapshot
without edit the query like READ only.

Your help would be much appreciated.

Thanks.

 

[John Vinson]

Hi everyone,

I'm able to open the query by clicking "Ok" command button but I am trying
to make the pop up from the list of tables on Query Screen automaticly
rather than clicking a button to get a list of tables.

After running the query, is there a way to turn the query into snapshot
without edit the query like READ only.

Your help would be much appreciated.

Thanks.

Could you explain what you're trying to *accomplish*? I very rarely
"run a query" in the sense of opening a query datasheet; if I want to
present data to a user I'll open a Form based on the query (and that
Form's Allow Updates property can be set to FALSE); if I want to
export or use the data otherwise, I'll create a Recordset based on the
query in VBA code.