Gary,
Thanks for the instructions! Works well! One question, though. When I used [FORMS]![frmPARAMETER]![FIELD] option in the query, it comes up with a prompt box, but the prompt box's text is the same as the parameter.
Is there a way to change the text for the parameter box when it appears...
Gary,
I'm rather new to Access DBs. Could you give an example of the syntax for the control name box? I'm having the same problem as Shelton, and it's a feature I desperately need to work at the moment.
I'm assuming you mean create a form to enter the parameter needed to run the report...
I've tried every placement trick I know, including overlapping, to stop it from pushing the subreports around. That's why I thought there might be a wrapping function in Access I was missing.
I had a hunch that there was no exact science to keep this from happening, but I thought I'd throw it...
Gave it a try, but I get a nesting error because Access has a fit with 3-level subreports.
Each subreport at the highest level contains two individual subreports. So, in essence, I am putting 10 separate reports in one main report, each subreport containing two subreports.
Am I just pushing...
I have a report that contains upwards of five subreports of required information in two columns (two on the left, three on the right). However, when I try to put all of them into a report using landscape orientation on the page so that I only get one page, I find that some of the subreports on...
Currently, the date range is query-based, because each report was written on an as-needed basis. Now, the PTB want it all-inclusive. (This is more a laziness issue than a functional issue <g>). So, everything was put in on the pop-up.
I think I was wondering if there's more a code solution...
I need to run several reports using one date range for all of them. Is there a command button or routine I can make to do all that instead of entering a date for each report? Each report is currently set to accept a user's date range using:
Between [Enter Start Date:] And [Enter End Date:]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.