report concept help

[mustangcoupe]

I have a project I am working on... It is going to be used to save me hours of work when complete... this will have multiple reports. one such report will depend on the information that myself or coworkers enter. I currently fill out a bunch of forms by hand, what I want to happen is to have most of the information filled out for me. what I have a problem with is that to get the report correct I beleive I need 10 or so diffrent reports maybe more depending on the customer and type of project(some reports may be duplicates with diffrent information pulled from the recordset)! Then combine them into one final ouptut (printed or saved im not sure yet) can I have it create the report export to word, and then export another report to the same open word document (after the first?) I was thinking of creating a new word document, exporting the first report, then second, third, ect..... all processes would be hidden to the user (maybe a progress bar or something for them to look at)

Is this possible and could you give me ideas on how to do it?

--Todd


TechnicalUser pretending to be a programmer(shhh… the boss doesn’t know yet)

 

[GingerR]

This is totally doable. Once you have data in the database, you can slice it and dice it however you want, with no extra time involved re-entering the same info.

As for exporting to Word: You can do this too. It's a standard feature in Access. It's pretty fast so you probably won't need a progress bar. Probably an hourglass at most. But--i'm not sure what you mean by exporting more and more reports to the same Word document? Maybe you could just create one long Access report that exports to Word? Is that not feasible for some reason?

hope this helps--g

 

[mustangcoupe]

Well I thought about one LONG report but some days the report is made from ALL pages 1-10, but other days it may need pages 1,2,3,5,10 and then agian on day 3 it may be 1,2,3,4,5,5 (with a diffrent records information on it), and agian 5 (with a diffrent records information on it)...ect so I wont know what days which report pages I will need the standard information will be one long report then all the "add in pages" would be seperate reports Unless you think I can do it another way... So I figured I would need to export it to word or something to "compile" it togather...( and I figured a progress bar because I would be opening one line of a recordset, populating the report and outputting it to word and I didnt know how long it would take.... an hourglass would be just fine! make it look as it is doing something)

--Todd


TechnicalUser pretending to be a programmer(shhh… the boss doesn’t know yet)