Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: where can i find info on the application.forms collection

    any one know where i can find information on the application.forms collection?

    please help

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by DackJaniels
    any one know where i can find information on the application.forms collection?

    please help
    Access help pages ...

    Ex:

    Show All

    Forms Collection
    See Also Properties Methods Events Specifics
    Application
    Forms
    Form


    The Forms collection contains all of the currently open forms in a Microsoft Access database.

    Using the Forms Collection
    Use the Forms collection in Visual Basic or in an expression to refer to forms that are currently open. For example, you can enumerate the Forms collection to set or return the values of properties of individual forms in the collection.

    Tip The For Each...Next statement is useful for enumerating a collection.

    You can refer to an individual Form object in the Forms collection either by referring to the form by name, or by referring to its index within the collection. If you want to refer to a specific form in the Forms collection, it's better to refer to the form by name because a form's collection index may change.

    The Forms collection is indexed beginning with zero. If you refer to a form by its index, the first form opened is Forms(0), the second form opened is Forms(1), and so on. If you opened Form1 and then opened Form2, Form2 would be referenced in the Forms collection by its index as Forms(1). If you then closed Form1, Form2 would be referenced in the Forms collection by its index as Forms(0).

    Note To list all forms in the database, whether open or closed, enumerate the AllForms collection of the CurrentProject object. You can then use the Name property of each individual AccessObject object to return the name of a form.

    You can't add or delete a Form object from the Forms collection.

    I found this in the help ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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