mischief911
Technical User
Is there a simple way to determine the name of the currently open Query (select query) and then close it on the on_click event of a command button?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Detect and then Close the Open Query
- Thread starter mischief911
- Start date
- Status
Probably the easiest way to do that is to remeber what query you opened in the first place! Have a look at thread:thread705-296120 about saving a global variable, then when you open the query, save the query name as well.
B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------
B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question