my report is controled by a query which looks for the a start date and end date of the week and by the shift,<br>every time i open the report i have to put in the begining date, end date and the shift three times for the report and the two charts in it <br>i would like to know is there any way i could link the charts to the report, i have tried using the link masterfields option but it says the charts are unbound <br>and it won't like or else i am not doing it right<br>please help as i am at my wits end<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
charts which are unbound in reports
- Thread starter johnoc
- Start date
I have had similar issues with charts and reports for my Access programs. This issue revolves around the way Access queries handle the parameter inputs. Everytime the data is sorted, queried, or refreshed the parameters need to be input again. The best work-around I found was to use input boxes on a form that hold the values needed to run the report or chart and all the queries behind them.
I used a combo-box with the indexed values behind it to solve the issues that arise from user input to display the chart.
1) Redundant entries aren't user-friendly
2) What if they enter the data differently the second or third time?
3) What if they enter a value that is the wrong data type or isn't a valid entry?
By giving the user a list to choose from, the value is in place and can be passed to the criteria for the query. It has to be a valid entry if selected from the list. This eliminates the user having to enter the data more than once. On the form I created with the combo-boxes for user selection, I placed a button that opens the report or chart and passes the value to the criteria input based on the combobox value.
I hope this points you towards a solution for your issues.
Bryan Meek
bmeek@pacbell.net
A TC in your corner gives you the personal attention you need to find the right technology solutions for your business.
I used a combo-box with the indexed values behind it to solve the issues that arise from user input to display the chart.
1) Redundant entries aren't user-friendly
2) What if they enter the data differently the second or third time?
3) What if they enter a value that is the wrong data type or isn't a valid entry?
By giving the user a list to choose from, the value is in place and can be passed to the criteria for the query. It has to be a valid entry if selected from the list. This eliminates the user having to enter the data more than once. On the form I created with the combo-boxes for user selection, I placed a button that opens the report or chart and passes the value to the criteria input based on the combobox value.
I hope this points you towards a solution for your issues.
Bryan Meek
bmeek@pacbell.net
A TC in your corner gives you the personal attention you need to find the right technology solutions for your business.
- Status
Similar threads
- Locked
- Question
- Locked
- Question