Date: Thu, 14 Sep 2000 09:41:29 -0400 From: Donna Rae Subject: Access Day - 9/20/00 Hello Everyone, Next Wednesday, September 20, 2000 is "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! Our next OFFICE DAY is scheduled for Wednesday, October 18, 2000, 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 next Wednesday's "MS OFFICE DAY" is as follows: ************************************ MICROSOFT WORD User Group 9:30 am to 11:00 am ************************************ "DATA MERGE" Presented by: Dean Serrentino, (d.serrentino@ai-host.net) In this session, Dean Serrentino, will show you the various ways you can merge data into Word documents. ************************************ MICROSOFT FRONTPAGE User Group 11:00 am to 12:30 pm ************************************ "FRONTPAGE 101" >From the Boston FrontPage User Group Tom Lee, Jr. will return for an Encore presentation of "FrontPage 101." The demonstration will be based on FrontPage 2000 but will be geared towards going over the basics of initial Web layout and design including the all important relationship of Tables and Cells and their use in positioning objects. A good intro session for first-time users of FrontPage 98 or 2000. (www.FrontPageBoston.com) *********************************************************** MICROSOFT ACCESS 1:00 pm to 4:00 pm *********************************************************** "INTRODUCTION TO MICROSOFT ACCESS VBA", Part I of a multi-part section. (formerly called Introduction to MS-Access Basic) Presented by: Rick Lunetta, Luna Systems Corporation, (RickL@lunasystems.com) If you are a Microsoft Access Power User and you want to take it to the next level or if you want to learn to write commercially viable Microsoft Access applications then you need to attend this session. Luna Systems has previously presented this course on a charge only basis and is now offering it at no charge to all who attend. ***************************************** 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 User Group 6:00 pm to 8:30 pm ************************************ "DISTRIBUTED FRONT END MANAGEMENT" Presented by: Jim Connell, Custom Software, (Jconnell3@aol.com) When you are using a front-end/back-end model with the front end residing on multiple machines, updates can become cumbersome. Jim Connell of Custom Software will demonstrate a method to automate this process. By using self-referential front ends he will show how an application can detect that a new version is available and automatically update itself. The above sessions are subject to change. ********************************************************** * * * * * * SEPTEMBER USER TIP * * * * * * ********************************************************** "WORD USER TIP" sent to us by Dean Serrentino ---------------------------------------------------------------------------- ----------- I was quite surprised the 1st time I tried using Word form fields. I first filled in the fields, then unprotected the document, so the text body could be edited. I later noticed a mistake in one of the fields; so I again unprotected the document to correct it. When I re-protected the document, to continue editing, I was horrified to see that the contents of every form field had been erased. I later discovered that this is Word's default behavior. During the last Office day, Arnold Bilansky and I put our heads together, and came up with the solution listed below. The code checks whether the document is currently protected or unprotected, and toggles its state without resetting the form fields. This procedure can be run by a single mouse click, by assigning it to a toolbar button. Public Sub subProtect() On Error GoTo Err_subProtect With ActiveDocument If .ProtectionType = wdNoProtection Then .Protect wdAllowOnlyFormFields, noreset:=True, Password:="" Else .Unprotect End If End With Exit_subProtect: Exit Sub Err_subProtect: MsgBox Err.Description, vbOKOnly, APP_NAME Resume Exit_subProtect End Sub **************************************************************************** ********************************** **************************************************************************** *********************************** ***************************SPECIAL REQUEST********************** Our 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. 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, 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 **************************************************************************** **************************************** **************************************************************************** ****************************************