Jessica,
Apparently you are using parameter prompts. Parameter prompts in the criteria of queries is fairly common but have too many limitations. IMHO, users should never be subjected to them.
Use controls on forms for all user interaction other than simple yes, no, cancel, etc.
Regarding Problem #2, I expect you have too much level of detail in the record source of the main report. If a detail/child table is included in a subreport, it should not be included in the main/master record source.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Fri, 19 Dec 2014 05:31:23 -0800
Subject: [MS_AccessPros] report trouble
Good Morning group! I have two questions/problems:
I have built a report (again, much thanks to the group for your help) that uses subreports. This report pulls information from several tables tied to my main form/subforms.
Problem #1: I can get the report to work but it asks for the parameters twice when I open the report - I get that it would ask once since it's tied to a query but I don't understand twice since it's asking for the same info in a different way.
Problem #2: The main form has tab controls for three subforms. Two of the subforms are continuous forms so the user can add multiple selections and the matching explanation for each selection. When I run the report for incidents the have mutliple selections entered the report that is created is perfect, but appears 4 times - all identical and all in one lengthy PDF document. When it should be only two pages, it appears as 8 pages. I know this is related to the multiple selections but how do I make it stop?
Thank you!
Jessica
Apparently you are using parameter prompts. Parameter prompts in the criteria of queries is fairly common but have too many limitations. IMHO, users should never be subjected to them.
- They don't allow defaults
- They don't allow picking from a list
- They don't allow seeing multiple values at once
- They aren't easily re-used
- You can't check their integrity
- You can't limit one based on the value of another
- They don't support input masks or formats
- Their values can't be displayed in a report that returns no records
- They are annoying like pop-ups
- They are difficult to query with a foreign key value that has no meaning
- You rarely if ever find a parameter prompt type interface in any decent software application
Use controls on forms for all user interaction other than simple yes, no, cancel, etc.
Regarding Problem #2, I expect you have too much level of detail in the record source of the main report. If a detail/child table is included in a subreport, it should not be included in the main/master record source.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Fri, 19 Dec 2014 05:31:23 -0800
Subject: [MS_AccessPros] report trouble
Good Morning group! I have two questions/problems:
I have built a report (again, much thanks to the group for your help) that uses subreports. This report pulls information from several tables tied to my main form/subforms.
Problem #1: I can get the report to work but it asks for the parameters twice when I open the report - I get that it would ask once since it's tied to a query but I don't understand twice since it's asking for the same info in a different way.
Problem #2: The main form has tab controls for three subforms. Two of the subforms are continuous forms so the user can add multiple selections and the matching explanation for each selection. When I run the report for incidents the have mutliple selections entered the report that is created is perfect, but appears 4 times - all identical and all in one lengthy PDF document. When it should be only two pages, it appears as 8 pages. I know this is related to the multiple selections but how do I make it stop?
Thank you!
Jessica
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar