Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I need Post-its(tm)! (A2K)

    I've created a series of queries to feed a subreport. I have 3 such subreports with 3-4 queries crunching the data. Oh how I wish I could insert comments into queries!

    Any good ideas on how to document these suckers? I thought of creating a table that pulls in all my queries, fields, etc. but it smacked of recursion. Would this work?

    <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>Suzanne

  2. #2
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts

    Re: I need Post-its(tm)! (A2K)

    If you right-click a query in the database window and select Properties, you can add a free-text description to the query. Is this sufficient for your purposes?

    Jeremy

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I need Post-its(tm)! (A2K)

    Actually, I was looking for more space than that, so 6 months from now I can recall that fieldA is used later for report X and that [ChargeID]=26 deals with meal charges, etc. etc.

    And queries have all those lovely blank rows at the bottom - just begging for me to stick some comments in. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: I need Post-its(tm)! (A2K)

    Then you'll have to build a table that contains the query name in one field, perhaps the SQL of the query in another, and a memo field to hold comments.
    Charlotte

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: I need Post-its(tm)! (A2K)

    ... Another way to help remember things on a form is to insert labels on the form itself next to the data. The label could contain the query name and brief description of what the query does. Of course, you would set the label to invisible so when the form is active you wouldn't see it. However, to see the label, switch to design mode and your labels with comments become visible. This may not be what you are looking for but it helps me to remember things.

    HTH
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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