Results 1 to 16 of 16

Thread: Finding system objects - Access 2K [Resolved]

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Resolved Finding system objects - Access 2K [Resolved]

    I'm populating a listbox with the names of the tables, queries, forms, etc, in the database. The eventual goal is to be able to make changes in one template database and have a form that will copy the changes to about sixty other db's automatically.
    Anyway, I don't want the (normally) hidden system objects to appear in the listbox. I know I could check Left(tbl.Name, 4) for "Msys", but is there a more OOP way, like checking for a system or hidden property?
    Also, is there a reason that there's no .AddItem property for a standard listbox?
    Thanks.
    VB Code:
    1. Dim ObjAO As AccessObject
    2.       Dim Obj As Object
    3.       Dim s As String
    4.            
    5.       Set Obj = Application.CurrentData
    6.       lstObjects.RowSourceType = "Value List"
    7.      
    8.       For Each ObjAO In Obj.AllTables
    9.             If Not ObjAO.blah = vbSystem Then   'This is where I want a check
    10.                s = s & ObjAO.Name & ";"
    11.             End If
    12.       Next
    13.      
    14.       lstObjects.RowSource = s
    Last edited by salvelinus; Jul 31st, 2005 at 11:01 AM.
    Tengo mas preguntas que contestas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width