Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    CAll the Report Wizard (2K XP)

    Is there a runcommand to call the report wizard using a specfic query as the basis for it.
    thanks

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

    Re: CAll the Report Wizard (2K XP)

    I don't know the answer for Access XP, but maybe somebody knows how to adapt the following.

    In Access 97, the report wizard is stored in Wzmain80.mde.
    To call the report wizard in code, you can use

    <pre>Run "wzmain80.frui_Entry", "QueryName", acReport</pre>

    where QueryName is the name of an existing query.

    If you set a reference to Wzmain80.mde, you can use

    <pre>wzmain80.frui_Entry "QueryName", acReport</pre>

    instead.

    I don't know whether XP works the same way. At the least, the file name will be different (probably Wzmain90 for Access 2000, but for XP ?)

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: CAll the Report Wizard (2K XP)

    it looks like its name acwzmain.mde. I set a reference but the part you called does not exist and there are about 400 possibilities and I could not figure out which one it is.
    If anyone knows, Help!
    Thanks
    Zave

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

    Re: CAll the Report Wizard (2K XP)

    I have to point out that even if you make this work, you can't distribute a wizard with an application, so it will break on a target machine if their installation doesn't include the wizards.
    Charlotte

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: CAll the Report Wizard (2K XP)

    It is for a specific person who cannot figure out (!) how to choose which query to base the wizard on. They have a full install of Access.
    thanks for the reminder though.

Posting Permissions

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