Create my own "Report WIzard" in a form???

[mehgan]

Hello! I was wondering if there was a way that I could create a "Report Wizard" of my own in the form I created? Right now I have created my own reports but there is TOO MUCH information to fit in ONE report so I have to make multiple reports...but this makes it very confusing for those that will later have to use my program. So, I thought if I could just create a "Report Wizard" of my own that allows them to pick and choose the the tables and queries they would like to print from and then even more detailed the fields in these tables and queries it would be the simplest method. I would prefer them to access this button from the form that I have created rather than going behind the scenes to create a report, because they may then create problems or lose information in the program. BUT if I could walk them step-by-step (like the report wizard) through making a report this would solve everything?? Is this a possibility??? Thank you for any help that you can offer me

--mehgan

 

[dearabby]

I have been trying to figure this out as well!! I hope someone responds SOON!

 

[NewfieSarah]

I have been trying to find out the same thing. That would be a great thing did you find anyhting yet??

 

[Crowley16]

the simplest way is just to activate the report wizzard with some code...

however if you want to completely build your own report wizzard, then it's a HUGE task! although not technically impossible...

it would be much easier to create a general form and just edit the underlying query and control record sources/properties...

--------------------
Procrastinate Now!

 

[PHV]

Some starting points:
CreateReport and CreateReportControl methods of the Application object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MajP]

Get yourself a copy of Access Desktop Developers Handbook by Litwin and Getz et al. There is a whole chapter on it. Not as hard as you think.

 

[DJN]

DoCmd.RunCommand acCmdNewObjectReport
will open the Report Wizard Dialog box

 

[NewfieSarah]

WOW thanks for all the replies! So it is possible to creat your own! PHV I am not sure what your post is suppose to mean??Thanks for th heads up on the book, although I am not sure my funds will all me to get it at this time, however I am going to see what I can find on these posts and others before going to the book. Okay lets start over. I have the report wizard figured out. I dont know the best way to accomplish this but I am going to give it a try and i hope someone can help me out with it. okay. I have a database where form is filtered with specific data. This data is what i would like to make reports with. Since I dont need all the fields on my form for reports all the time I want to be able to choose on the fly what i want. I though it would be a good idea to use a report wizard. However that uses all the data in my table, and I would only like the filtered data that I have on my form to be used. Anyone have any ideas for this one?? thanks

 

[MichaelRed]

search these fora for the keyword terms "CreateReport" and / or "CreateReportControl". Been there. Done That. At least a starting point.

within some parameters, it is not a huge deal





MichaelRed

 

[FancyPrairie]

I have built wizards to create forms and reports for me. I sometimes hook into some of the Access Wizards to do some of my work. Here's one that will create a report (it will also do forms). That last argument (3) indicates report. The type of report (column, tablular) is the 2nd to the last argument. You can run the following command from debug's immediate window for a quick check of how it works.

application.Run "acwzmain.auto_entry","NameOfYourQueryOrTableThatWillBeTheRecordSourceForTheReport",2,3