Check to see if a query or table is open

M

Mark

Is it possible in VB to check to see if a query or table
is currently open in a window, and if so, how could I
close if from within another form?

Thanks,

Mark
 
M

MacDermott

Look at SysCmd; I think it's got an option for object state.
DoCmd.Close [ObjectType],[ObjectName] should close it.

HTH
- Turtle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word OLE to check spelling in text box 1
Append Crosstab Query to Existing Table 0
OLE Word spelling 0
Incone & Expenses Statement 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2010 DB not fuctional with multiple users 2
Adding data to MS Access from csv file 0
Populate a table based on check box status 2

Top