Date: Tue, 20 Feb 2001 14:19:28 -0500 From: Donna Rae Subject: Access Day - 2/21/01 Hello Everyone, Our next session of "MS ACCESS DAY" will be held tomorrow, February 21, 2001 at Microsoft in Waltham, MA. Here are the session details and topics that will be discussed. All events are free and do not require pre-registration. Seating is based on a first come basis... so it pays to be early! Door prizes will be available! Our next ACCESS DAY is scheduled for Wednesday, March 21, 2001, please mark your calendars! We are in search of User Tips! If you have a USER TIP you would like to share please send it to me at the following address: DonnaR@lunasystems.com and who knows it may just show up on a future announcement! The agenda for Wednesday's "ACCESS DAY" is as follows: ************************************ INTRODUCTION TO ACCESS 9:30 am to 12:00 noon ************************************ "INTRODUCING THE BEGINNING USER TO ACCESS", "Building Data Access Pages" Part V of a multi-part series. Presented by: Dean Serrentino, (d.serrentino@ai-host.net) In part V of this series, Dean will explain how this new feature in Access 2000, Data Access Pages, provides an alternative to forms and reports. Learn what they are; how they work; how to create them, and when it is appropriate to use them. ************************************** MICROSOFT ACCESS 1:00 pm to 4:00 pm ************************************** "Intermediate Programming in Visual Basic for Applications (VBA):" "Control Structures" Presented by: Dean Serrentino, (d.serrentino@ai-host.net) Control Structures are the base of all programming and allow the programmer to control the flow of code through their application. Learn about the different structures available in VBA, and how and when to use each of them for effective program control. ***************************************** THE ACCESS TRAUMA CENTER 4:30 pm to 5:30 pm ***************************************** Presented by: John Giuliano, Stone-Crowne Associates, (Stone-Crowne@msn.com) Does Access depress you at times? Do you bang your head against the wall trying to get Access to do things that are common functions in other applications? Does your blood pressure rise trying to format reports to look just like the boss's old favorites? Does the mere thought of opening the code window give you anxiety attacks? We have just what the doctor ordered. -- "The Access Trauma Center" Each month from 4:30 to 5:30 we will solve (or try to solve) problems posed by the audience. The hour will be broken up into different segments: 'Triage' (5 minutes) -- Here we poll the audience for pressing and perplexing problems to solve. (Please no "nice to know" questions. Our goal will be to help the suffering victims of Access.) ***PLEASE REMEMBER TO BRING YOUR DISKS FOR TRIAGE*** 'Emergency Surgery' (45 minutes) - Here we diagnose the problems and find working solutions. We will build forms, reports, and code modules that demonstrate methods discussed. No cosmetic surgery will be performed here. Emergency surgery is not pretty. Expect ugly forms and reports. If you have a weak stomach, it may be best to retire to the waiting room. Copies of the working solutions and code will be available for any who request such. 'Is The Patient Still Breathing?' (5 minutes) - Q&A dealing with quick verbal solutions to problems that did not require on-screen demonstrations of solutions. 'Doctor, It Hurts When I Do This...' (5 minutes) - A short session on things to watch out for as you develop applications. Each month we will discuss different topics. Did we mention we are also a research facility? In the event of too few questions, a topic vital to the health and well-being of all intermediate level Access Users will be covered. ************************************ MICROSOFT ACCESS User Group 5:30 pm to 6:00 pm ************************************ "Pre-Game Show" ************************************ MICROSOFT ACCESS Main Meeting 6:00 pm to 8:00 pm ************************************ "MICROSOFT ACCESS LIBRARIES" Presented by: Jim Rand of Rand & Associates (jimrand@ix.netcom.com) Jim will discuss how to Use Microsoft Access Libraries as an alternative to Dynamic Link Libraries. ********************************************************** * * * * * * USER TIP * * * * * * ********************************************************** This month's User Tip is sent to us by Mike Murphy of Cambridge. Thanks again Mike! ************************************************************************ ** Add an interactive graph to your Access 97 application ** ************************************************************************* A popular feature that we often add to our applications is the ability to display a graph of any of several statistics that the user chooses. It is fairly easy to program using the MSGraph8 miniserver application included in Access 97. You will not get proper credit for the really difficult features you had to code, so you might as well take a bow once in a while for something that was easy. In this example, we had set up a query that totals various health care statistics by the Region of the provider. We will display a form includes a graph of the regions, with an option group of several other available statistics. When the user picks a stat then presses a "redraw" button, the graph changes to display the new variable. Instructions: Open a new form. It will have an option group, a chart, and a button. Click the "option group" tool and draw a new option group: - with three label names (Visits, Patients, Total Charges) - with values 1, 2, 3 - with caption "Select Statistic, Then ReDraw" - name it intStatVar Make sure that the "control wizards" tool is on. >From the menu, select "insert" and "chart" and draw a new chart. Let the Chart Wizard create a default graph. - point to a source table or query (for this, we had made a totals query of various statistics by region) - select the classification field "strRegion" and any of the statistics - format the graph as you like - give it the name "chtRegion" Now, add a button, named "cmdReDraw", and enter the following code in the "On Click" property ------------------------------------------------------------------ Private Sub cmdReDraw_Click() On Error GoTo Err_cmdReDraw_Click ' Replace graph rowsource with selected variable Dim strStatVar As String Dim intResponse As Integer Select Case Me.intStatVar ' strStatVar names are those you calculated in the source query Case 1 strStatVar = "SumOfintVisit" Case 2 strStatVar = "SumOfintPersID" Case 3 strStatVar = "SumOfdblCharges" Case Else intResponse = MsgBox("Please select a Statistic", vbExclamation, "Which Stat?") goto Exit_cmdReDraw_Click End Select Me.chtRegion.RowSource = "SELECT [tblRegion].[strRegion],Sum([" & strStatVar & "]) AS [SumWhatever] FROM [qryGraphStats];" Exit_cmdReDraw_Click: Exit Sub Err_cmdReDraw_Click: MsgBox Error$, 0, APP_NAME Resume Exit_cmdReDraw_Click End Sub ------------------------------------------------------------------ Go as far as you like with the source query on which the chart is based. Calculate many different statistics in the query and enable the user to draw them as graphs by adding them to the option group that drives the graph source. **************************************************************************** We are always in search of User Tips to add to the monthly meeting announcement. If you have something of interest and would like to share it....please email your user tip to DonnaR@lunasystems.com. **************************************************************************** **************************************************************************** ************************SPECIAL REQUEST********************** Our MS Access User Group is looking for speakers to round out our schedule of presenters for MS Access Day. The audience typically ranges from beginners to advance level people. The speaker will need to be available in the evening on the date they are speaking at Microsoft in Waltham for a presentation. This is your chance to help the user group and get a little personal speaking experience at the same time. . . If you are interested please contact Donna Rae at Luna Systems, DonnaR@lunasystems.com, and let her know when you are available and what subject you would like to cover. Pat, Phil, Rick and John will be available to help you prepare for the session. Please check Luna Systems website: www.lunasystems.com for up to date information on all of the sessions scheduled for "MS ACCESS DAY" and also for any cancellations due to weather conditions and/or unforeseen circumstances. See you in Waltham, Donna Rae Luna Systems Corporation 2 Dundee Park, Suite 103 Andover, MA 01810-3725 DonnaR@lunasystems.com www.lunasystems.com All events take place at: Microsoft 230 Third Avenue Waltham, MA For directions: www.microsoft.com/newengland/waltham.htm If you have a change of email address or wish to be removed from this mailing, please contact me: Email: DonnaR@lunasystems.com Phone: 978-749-9600