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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Evaluate Open Table

Status
Not open for further replies.
MJPPaba

MJPPaba

MIS
May 28, 2003
142
GB
I need Access VBA to evaluate whether a table is open. Your assistance is gratefully appreciated.

Cheers,
Matthew

The only bad question is the question you dont ask!
 
Sort by date Sort by votes
If sysCmd(acSyscmdGetObjectState, acTable, "MyTable") = acObjStateOpen
Then
'Do whatever
else
' do something else
End If


 
Upvote 0 Downvote
Thankyou lupins46

Works like a dream.

Cheers

Matthew

The only bad question is the question you dont ask!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

A
  • Locked
  • Question
Print Table attachment
Replies
2
Views
297
andre.meyer
A
ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
1K
Andrzejek
Andrzejek
ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
982
ameedoo3000
ameedoo3000
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
4K
OCM
OCM
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
938
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top