Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Show new fields from query on form/report (Acc2000)

    I have a cross-tab query that collects annual data on number of tests performed. Of course each year a new field shows up. I made a form to show this, as well as a report, but I have to add each new year manually or it won't show on the form/report. Are there any articles that tell how to add the new annual field to the form automatically (programmatically). I can't seem to find this in a book, and probably am not looking for the right terminology.

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

    Re: Show new fields from query on form/report (Acc2000)

    This is a well known problem. It takes VBA to handle it. A search for Dynamic crosstab reports in this forum will turn up many threads; see for example the thread starting at <post#=365323>post 365323</post#>. My first reply in that thread contains some links, and in my last reply I attached a demo database.

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show new fields from query on form/report (Acc2000)

    Thanks! I'll try his out.

Posting Permissions

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