Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is is true that if a form/report is not open yet, its objects (methods/properties) are invisible and thus can't be referenced?
    Does the same rule apply to tables and queries as well?
    Armstrong

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Yes, a form (or report) needs to be open if you want to refer to its properties and methods.

    Tables and queries aren't objects in Access in the same sense as forms and reports. If you want to manipulate their properties, you have to use an object model such as DAO, which has TableDef and QueryDef objects.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='780438' date='18-Jun-2009 14:02']Yes, a form (or report) needs to be open if you want to refer to its properties and methods.

    Tables and queries aren't objects in Access in the same sense as forms and reports. If you want to manipulate their properties, you have to use an object model such as DAO, which has TableDef and QueryDef objects.[/quote]
    Your explanation makes a lot of sense to the failures which I encountered recently.
    Thanks a lot.
    Armstrong

Posting Permissions

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