Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Referencing 2 query name instances

    Seemingly simple and, again I know I
    Cheers,
    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Referencing 2 query name instances

    Both should work. The period <big>.</big> is used to denote a property, and the bang <big>!</big> to denote a member of a collection. But since the Fields collection is the default property of a table/query, and the Controls collection is the default property of a form/report, the period and bang are often interchangeable.

    If you have problems, check if there are inconsistencies in the name and control source of controls. For instance, if you have a control whose name is just ProjectName, this might confuse Access.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Referencing 2 query name instances

    Hans,

    Thanks as always for your quick response. You were right, I was right with respect to my formatting. What I did not even consider as the problem was the fact that I was also trying to put a 'literal tag' as part of the name, so that I had =" " & [qry Projects_1].[PJ_ProjectName] and the system did not recognize [qry Projects_1]. When I got rid of the =" " & all worked perfectly. I'll just stick a label in front and that should do the trick. Again, many thanks as I quietly record this in my "Treepad".

    Andy
    Cheers,
    Andy

Posting Permissions

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