Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    61

    Question Unanswered: Invoke the Report Wizard using VBA

    I have a crosstab query that displays data by years i.e.

    Item 2002 2003
    Apples 12 13
    Oranges 66 61
    Pears 71 10

    This query must be able to display data by the dates that the user selects meaning that the field names will change. Now I want to display this data graphically using a bar graph. But when I create the graph it runs fine until I change the dates of the query. Now I was wondering if there is a way to have the Report Wizard create the report on the fly using VBA? I remember reading something a few years ago about this but at the time I didn't need to use the function.

    Thanks in advance,

  2. #2
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168

    answer...


Posting Permissions

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