Alright i'm wondering about the best method of having multiple pages on a report. Currently the case managers use corel and another program and merge data from one to another to get their forms. Since we're designing this new database to basically do away with the old methods I figured access would provide an easy way to go about accomplishing the same goal.
What I planned on doing: I was going to run a querry to search for the clientid. Than I want to place the 'static' data around the report similiar to their current forms... IE: Name, Address, Programs their currently in, etc.. It really seems like it should be pretty basic but i'm unsure how to make it so 1 report becomes multiple pages. The reports seem to be maxed out at 22" vertical and horizontally so my first though of placing the data where it 'should go' for each page on 1 report doesnt look like a very smart method. I've considered just creating 10 seperate reports off of one querry with each report laid out to 1 of their forms. That seems like the smart way to do it but than i'm curious how/if I can add to my switchboard for them to select Reports--->Assessment Package and have it so once they enter the client ID give them a method to print all 10 reports at the click of 1 button. It would also be nice if they could see all 10 reports somehow without having to type in the client ID 10 seperate times *the main reason why I was going to simply put everything into 1 report at first*.
Another thing I was curious about is if there is any way they could be prompted to select which reports they want printed if for whatever reason they didnt need form 7y or 8 but need 1-6, 9 and 10. If i'm not making sense i'm sorry! Any help would be greatly appreciated. Here is an emoticon story of how my day has gone thus far...
Wake up to the wife and baby:
Come to work:
Get stumped over this seemingly simple problem:
Go home on lunch break attempting to think of a solution:
Come back... no solution:
Remember the great gods on UA that get me out of all my database related jams:
You guys solve my seemingly simple problem in no time without breaking a sweat while i'm:
I come back to find a boatload of solutions that I feel dumb for not knowing in the first place *but am very very thankful for!*:
Finish up this seemingly easy project with 5 minutes to go in the day:
Go home without a worry in the world *work related ofcourse*: o!
Few days later...
-----> -----> -----> -----> -----> -----> -----> -----> -----> -----> -----> o! ----->
Yes besides this problem i'm having today has been a very boring day..