Results 1 to 3 of 3
  1. #1
    jptros is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2012
    Posts
    9

    Get objects selected in the database window

    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.

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    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.

  3. #3
    jptros is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2012
    Posts
    9
    Quote Originally Posted by ssanfu View Post
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can't save database objects when changes made
    By stanley721 in forum Access
    Replies: 8
    Last Post: 10-12-2015, 08:51 PM
  2. Replies: 5
    Last Post: 05-17-2012, 06:23 PM
  3. Replies: 4
    Last Post: 02-09-2012, 10:05 PM
  4. Cannot import objects from secured database
    By focosi in forum Security
    Replies: 2
    Last Post: 09-10-2011, 02:33 AM
  5. Linked OLE Objects bloating size of database
    By Nosaj08 in forum Database Design
    Replies: 18
    Last Post: 07-09-2009, 05:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums