I made a video today showing how to use the Graph menu and form tool. In doing so, I discovered a few bugs ... oops!
20-minute video tutorial on YouTube:
Tool and Code: Graphs and Charts in Microsoft Access (cc)
http://www.youtube.com/watch?v=Zc5WAPderyQ
Tool and Code: Graphs and Charts in Microsoft Access (cc)
http://www.youtube.com/watch?v=Zc5WAPderyQ
I uploaded an update into my folder ~
Warm Regards,
Crystal
Remote Programming & Training -- connect to me, let's built it together
Through sharing, we will all get better
~ have an awesome day ~
Crystal
Remote Programming & Training -- connect to me, let's built it together
Through sharing, we will all get better
~ have an awesome day ~
On Monday, August 11, 2014 10:44 PM, "strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
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: Crystal <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Yahoo Groups
Instantly Explore All Attachments Within Each Group Conversation
You can now explore files, preview and download photos directly within each conversation.
.
__,_._,___
Tidak ada komentar:
Posting Komentar