From: Donna Rae To: Access User Group Subject: Access Day - 1/19/00 Date: Thursday, January 13, 2000 3:29 PM Hello Everyone, Next Wednesday, January 19, 2000 is our third official "MS OFFICE DAY" 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! Please note our new USER TIP feature at the end of this announcement. If you have a USER TIP you would like added to the monthly announcement please send it to me at the following address: DonnaR@lunasystems.com. ***SPECIAL ANNOUNCEMENT*** Our very own Phil Denoncourt will be presenting FrontPage for Access Users on Tuesday, January 18, 2000 at the FrontPage User Group Meeting at Microsoft, Waltham. Please see the end of this announcement for a special request! Our agenda for next Wednesday's "MS OFFICE DAY" is as follows: ************************************ MICROSOFT WORD User Group 9:30 am to 11:00 am ************************************ "Using Word with Excel" Session Presented by: Pat Tormey, P.E., Foursquare Solutions, Inc., tormey@foursquare.com ************************************ MICROSOFT EXCEL User Group 11:00 am to12:30 pm ************************************ "Using Excel with Word" Session Presented by: Pat Tormey, P.E., Foursquare Solutions, Inc., tormey@foursquare.com ************************************ MICROSOFT FRONTPAGE User Group 1:00 pm to 2:30 pm ************************************ "FrontPage 101" Session Presented by: Tom Lee, Jr., Director of the FrontPage User Group, Tomleejr@aol.com Session focus will not be FrontPage 97, not FrontPage 98 nor FrontPage 2000 but "FrontPage 101". A look at a real business web created from scratch, by a very non-technical business person: concept to implementation. We will walk through and talk about not only the "how and what" we did but also the "why" we chose certain layouts and information during building. ************************************ MICROSOFT ACCESS User Group 2:30 pm to 4:00 pm ************************************ "Introduction to Access 2000" Presented by: Rick Lunetta, President of Luna Systems Corporation: RickL@lunasystems.com ************************************ MICROSOFT ACCESS User Group 5:30 pm to 6:00 pm ************************************ "Pre-Game Show" Bring your Access problems and questions! Bend the ear of an experienced Access developer or power user to get "real-life" answers to your "real-life" database problems! ************************************ MICROSOFT ACCESS User Group 6:00 pm to 8:30 pm ************************************ "Main Meeting" Session Presented by: Rick Lunetta, President of Luna Systems Corporation: RickL@lunasystems.com (The above session's are subject to change.) ********************************************************* JANUARY'S USER TIP: "Excel Keystrokes" ********************************************************* sent to us by: Pat Tormey, tormey@foursquare.com 'Access user Group Boston 01/00 'Use this technique with a continuous form in Access (all Versions?) 'to make the arrow up and down keys look like an excel spreadsheet ' See www.foursquare.com ("Cheap Tricks" for more samples and downloads Private Sub Form_Load() 'this makes sure that the form "Sees" the key stoke 'OR You can also just set the KeyPreview Property manually Me.KeyPreview = True End Sub Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) On Error Resume Next Select Case KeyCode Case vbKeyUp DoCmd.GoToRecord , , acPrevious Case vbKeyDown DoCmd.GoToRecord , , acNext End Select End Sub ***SPECIAL REQUEST*** Our new MS Office Day event is looking for speakers from our user groups to round out our schedule of presenters for any and all tools in the MS Office Suite. The audience is typically beginners with some intermediate level people. The speaker will need to be available during the day on the third Wednesday of each month at Microsoft in Waltham for a 1 1/2 hour presentation. This is your chance to help our 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. The above sessions are subject to change. Please check Luna Systems website: www.lunasystems.com for up to date information on all of the sessions scheduled for "MS OFFICE DAY" and also for any cancellations due to weather conditions and/or unforeseen circumstances. See you in Waltham, Lisa Hall VP, Luna Systems Corporation 2 Dundee Park, Suite 103 Andover, MA 01810-3725 lisah@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: lisah@lunasystems.com Phone: 978-749-9600