Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    anyplace, anywhere, anytime
    Posts
    3

    Question Unanswered: How do I get the list of all forms existing in another adp project

    Hi everyone,

    After many searches on different forums and groups finally I decide to post on this forum.

    Problem: from an Access Project (.adp) i need to get the list of forms names which exist in another Access Project.

    It seems that DAO doesn't open access projects, only .mdb files, to use container, document, etc

    Also, Jet too.

    Any suggestion???

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi LordSith

    Glad you chose us

    A little automation seems to do it:
    Code:
    Sub GetForms()
     
    'Iterant
        Dim i As Integer
    'Access object
        Dim oAcc As Access.Application
        
    'Instantiate
        Set oAcc = New Access.Application
    
    'Open the project
        oAcc.OpenAccessProject ("C:\MyADP.adp")
       
    'Loop through forms collection using iterant
        For i = 0 To oAcc.CurrentProject.AllForms.Count - 1
    
    'Print off the form names
            Debug.Print oAcc.CurrentProject.AllForms.Item(i).Name
        
        Next i
            
    End Sub
    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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