Get Access Attribs of a Project Such as Form,model,report and so on

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • qhdzqx
    New Member
    • Apr 2014
    • 1

    Get Access Attribs of a Project Such as Form,model,report and so on

    I think through VB or VB.net access to an object, such as forms, queries, macro properties.

    I want to know the content of the query.
    What are the form control object,such as what attribute is the name of a text-box in the form.

    thinks
  • mcupito
    Contributor
    • Aug 2013
    • 294

    #2
    Can you provide some more clarity? I don't really understand your question. You want to know the content of the query? What query? Where is it? Do you mean QBE or SQL?

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32633

      #3
      Office and Access expose many collections of objects to the VBA code. If you have an object, such as a form, then you can use
      Code:
      For Each X In ObjectName.CollectionName
          ...
          Debug.Print X.Name
      Next X
      to cycle through each item in the collection. X refers to each item in turn as it iterates through the collection.

      Comment

      Working...