Is it possible to get the selected object in the database window? In the end I'm looking to have a tool bar item that runs a vba function against the table that is selected in the database window when the button is clicked.
Is it possible to get the selected object in the database window? In the end I'm looking to have a tool bar item that runs a vba function against the table that is selected in the database window when the button is clicked.
Not that I am aware of. But since the database window gets the object names and object types from the system tables, you can create a list box that lists the table names just like the database window.
Select the tables name and run the VBA code.
Yeah, was aware of that way, was hoping to do it without a form but no big deal. Thanks for taking the time to respond.