Open Query

  • Thread starter Thread starter Bill
  • Start date Start date
B

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.
 
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.
Click to expand...

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.
 
Back
Top