If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Parameters keep repeating
I have created a graph report . When I ask for the report from the
switchboard, I have to enter the date parameter associated with the query more than once. I have to also enter the day again before I print. And if I cancel. it prints a blank report. Is there a way I can view the report, enter the dates, and print without repeated requests. I have battle with this for months. I did try creating a form to associate with it and this still happens -- Thanks, Linda |
#2
|
|||
|
|||
Parameters keep repeating
IMHO, parameter prompts in queries are not good user interface
http://www.tek-tips.com/faqs.cfm?fid=6763. Consider creating a form with controls that can be used for filtering. Add a command button to open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I have created a graph report . When I ask for the report from the switchboard, I have to enter the date parameter associated with the query more than once. I have to also enter the day again before I print. And if I cancel. it prints a blank report. Is there a way I can view the report, enter the dates, and print without repeated requests. I have battle with this for months. I did try creating a form to associate with it and this still happens -- Thanks, Linda |
#3
|
|||
|
|||
Parameters keep repeating
I created a form I have to texts boxes , begin and end date. when I click my
report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph then appears. If I cancel, a blank prints out. When I select the print button, I am asked once again for the dates, it then prints. I have been at this since August. . When I open the report from the switchboard, (directly to the report) the same thing happens. I don't know what to do. I have been stumped by this one and could use all the help. -- Thanks, Linda "Duane Hookom" wrote: IMHO, parameter prompts in queries are not good user interface http://www.tek-tips.com/faqs.cfm?fid=6763. Consider creating a form with controls that can be used for filtering. Add a command button to open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I have created a graph report . When I ask for the report from the switchboard, I have to enter the date parameter associated with the query more than once. I have to also enter the day again before I print. And if I cancel. it prints a blank report. Is there a way I can view the report, enter the dates, and print without repeated requests. I have battle with this for months. I did try creating a form to associate with it and this still happens -- Thanks, Linda |
#4
|
|||
|
|||
Parameters keep repeating
You should first open the form and enter the criteria/date values. Then open
your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I created a form I have to texts boxes , begin and end date. when I click my report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph then appears. If I cancel, a blank prints out. When I select the print button, I am asked once again for the dates, it then prints. I have been at this since August. . When I open the report from the switchboard, (directly to the report) the same thing happens. I don't know what to do. I have been stumped by this one and could use all the help. -- Thanks, Linda "Duane Hookom" wrote: IMHO, parameter prompts in queries are not good user interface http://www.tek-tips.com/faqs.cfm?fid=6763. Consider creating a form with controls that can be used for filtering. Add a command button to open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I have created a graph report . When I ask for the report from the switchboard, I have to enter the date parameter associated with the query more than once. I have to also enter the day again before I print. And if I cancel. it prints a blank report. Is there a way I can view the report, enter the dates, and print without repeated requests. I have battle with this for months. I did try creating a form to associate with it and this still happens -- Thanks, Linda |
#5
|
|||
|
|||
Parameters keep repeating
In my last message I noted : when I click my
report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph report then appears. I click the -- Thanks, Linda "Duane Hookom" wrote: You should first open the form and enter the criteria/date values. Then open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I created a form I have to texts boxes , begin and end date. when I click my report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph then appears. If I cancel, a blank prints out. When I select the print button, I am asked once again for the dates, it then prints. I have been at this since August. . When I open the report from the switchboard, (directly to the report) the same thing happens. I don't know what to do. I have been stumped by this one and could use all the help. -- Thanks, Linda "Duane Hookom" wrote: IMHO, parameter prompts in queries are not good user interface http://www.tek-tips.com/faqs.cfm?fid=6763. Consider creating a form with controls that can be used for filtering. Add a command button to open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I have created a graph report . When I ask for the report from the switchboard, I have to enter the date parameter associated with the query more than once. I have to also enter the day again before I print. And if I cancel. it prints a blank report. Is there a way I can view the report, enter the dates, and print without repeated requests. I have battle with this for months. I did try creating a form to associate with it and this still happens -- Thanks, Linda |
#6
|
|||
|
|||
Parameters keep repeating
What are the parameters your record and row sources are looking for? What are
the SQL views of your Record Sources and Row Sources? These should identify why you are being prompted. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: In my last message I noted : when I click my report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph report then appears. I click the -- Thanks, Linda "Duane Hookom" wrote: You should first open the form and enter the criteria/date values. Then open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I created a form I have to texts boxes , begin and end date. when I click my report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph then appears. If I cancel, a blank prints out. When I select the print button, I am asked once again for the dates, it then prints. I have been at this since August. . When I open the report from the switchboard, (directly to the report) the same thing happens. I don't know what to do. I have been stumped by this one and could use all the help. -- Thanks, Linda "Duane Hookom" wrote: IMHO, parameter prompts in queries are not good user interface http://www.tek-tips.com/faqs.cfm?fid=6763. Consider creating a form with controls that can be used for filtering. Add a command button to open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I have created a graph report . When I ask for the report from the switchboard, I have to enter the date parameter associated with the query more than once. I have to also enter the day again before I print. And if I cancel. it prints a blank report. Is there a way I can view the report, enter the dates, and print without repeated requests. I have battle with this for months. I did try creating a form to associate with it and this still happens -- Thanks, Linda |
#7
|
|||
|
|||
Parameters keep repeating
the record source for the report is :
SELECT(Format([admissiondate],"MMM'YY")),Count([admissiondate]) AS [CountOfadmissiondate]FROM[ALF admissions by month que] GROUP BY (Year([admissiondate])*12+Month([admissiondate])-1),(Format([admissiondate],"MMM'YY")); the query source for the report is: field:admission date; criteria: Between [begin date] and [end date] The SQL view for the query is: SELECT TBLRESIDENTINFO.unittype, TBLRESIDENTINFO.admissiondate FROM TBLRESIDENTINFO WHERE(((TBLRESIDENTINFO.unittype)="ALF")AND((TBLRE SIDENTINFO.admissiondate) Between [begin date] And [end date])); The SQL statement for the report is displayed in the RecordSource -- the report was created with the wizard. The report works fine except for the problems noted. A form to open the report has not been created (even though I tried) I do thank you in advance for your help and pray this makes sense. Thanks, Linda "Duane Hookom" wrote: What are the parameters your record and row sources are looking for? What are the SQL views of your Record Sources and Row Sources? These should identify why you are being prompted. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: In my last message I noted : when I click my report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph report then appears. I click the -- Thanks, Linda "Duane Hookom" wrote: You should first open the form and enter the criteria/date values. Then open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I created a form I have to texts boxes , begin and end date. when I click my report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph then appears. If I cancel, a blank prints out. When I select the print button, I am asked once again for the dates, it then prints. I have been at this since August. . When I open the report from the switchboard, (directly to the report) the same thing happens. I don't know what to do. I have been stumped by this one and could use all the help. -- Thanks, Linda "Duane Hookom" wrote: IMHO, parameter prompts in queries are not good user interface http://www.tek-tips.com/faqs.cfm?fid=6763. Consider creating a form with controls that can be used for filtering. Add a command button to open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I have created a graph report . When I ask for the report from the switchboard, I have to enter the date parameter associated with the query more than once. I have to also enter the day again before I print. And if I cancel. it prints a blank report. Is there a way I can view the report, enter the dates, and print without repeated requests. I have battle with this for months. I did try creating a form to associate with it and this still happens -- Thanks, Linda |
#8
|
|||
|
|||
Parameters keep repeating
You shouldn't use
Between [begin date] And [end date] I would expect to see some references to the controls on your form like: Between Forms!frmDates!txtBeginDate And Forms!frmDates!txtEndDate -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: the record source for the report is : SELECT(Format([admissiondate],"MMM'YY")),Count([admissiondate]) AS [CountOfadmissiondate]FROM[ALF admissions by month que] GROUP BY (Year([admissiondate])*12+Month([admissiondate])-1),(Format([admissiondate],"MMM'YY")); the query source for the report is: field:admission date; criteria: Between [begin date] and [end date] The SQL view for the query is: SELECT TBLRESIDENTINFO.unittype, TBLRESIDENTINFO.admissiondate FROM TBLRESIDENTINFO WHERE(((TBLRESIDENTINFO.unittype)="ALF")AND((TBLRE SIDENTINFO.admissiondate) Between [begin date] And [end date])); The SQL statement for the report is displayed in the RecordSource -- the report was created with the wizard. The report works fine except for the problems noted. A form to open the report has not been created (even though I tried) I do thank you in advance for your help and pray this makes sense. Thanks, Linda "Duane Hookom" wrote: What are the parameters your record and row sources are looking for? What are the SQL views of your Record Sources and Row Sources? These should identify why you are being prompted. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: In my last message I noted : when I click my report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph report then appears. I click the -- Thanks, Linda "Duane Hookom" wrote: You should first open the form and enter the criteria/date values. Then open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I created a form I have to texts boxes , begin and end date. when I click my report command button created on the form to open a report, it asks for the parameter values twice(dates). The graph then appears. If I cancel, a blank prints out. When I select the print button, I am asked once again for the dates, it then prints. I have been at this since August. . When I open the report from the switchboard, (directly to the report) the same thing happens. I don't know what to do. I have been stumped by this one and could use all the help. -- Thanks, Linda "Duane Hookom" wrote: IMHO, parameter prompts in queries are not good user interface http://www.tek-tips.com/faqs.cfm?fid=6763. Consider creating a form with controls that can be used for filtering. Add a command button to open your report. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "Georgie047" wrote: I have created a graph report . When I ask for the report from the switchboard, I have to enter the date parameter associated with the query more than once. I have to also enter the day again before I print. And if I cancel. it prints a blank report. Is there a way I can view the report, enter the dates, and print without repeated requests. I have battle with this for months. I did try creating a form to associate with it and this still happens -- Thanks, Linda |
Thread Tools | |
Display Modes | |
|
|