I just posted an upload in my folder to demonstrate making graphs with Access.
https://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/Crystal/GraphExample_Crystal_140811_10p_accdb.zip
There is a form called f_Graph that has the Microsoft Graph control and a couple other controls that get modified. The menu form is called f_Graph_Menu. The button that opens the graph is captioned "Chart". The time frame can be changed from Days to Weeks to Months. On the right are other properties such as Chart Title, format for X and Y axes, X-Axis Title, and Minimum and Maximum Scale for the Y-Axis.
What makes the data work is modifying the SQL of the query that the graph is based on, qGraph.
This example also illustrates the method I use to cascade comboboxes. I put the SQL with no criteria in the Tag property of each respective combo then send the criteria and the control to a function I wrote called SetControl_RowSource, which is usually a public function. This example, however, embeds it behind the form that uses it and declares it to be private.
Double-click a date to popup a calendar form called f_PopupCalendar. If a date OpenArg is sent to the form, it will set the calendar to that date and not store it. This is done on the second date of the date range for cases when Date1 is specified but not Date2.
Warm Regards,
Crystal
Through sharing, we will all get better
~ have an awesome day ~
Posted by: strive4peace2008@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar