From: "Donna Rae" Subject: Access Day - 12/19/01 Date: Thursday, December 13, 2001 8:48 PM Hello Everyone and Happy Holidays to all, Our next session of "MS ACCESS DAY" is scheduled for Wednesday, December 19, 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! Next "year's" Access Day is scheduled for Wednesday, January 16, 2002. 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! *****We are also in search of speakers for the evening sessions of Access Day. If you are interested please do not hesitate to send me an email at donnar@lunasystems.com or to speak to Pat, Phil, Rick, John or Dean. They would be more than happy to help you prepare for your talk. P.S. We really need some help here, so please feel free to try out your presentation skills during a future evening session!***** The agenda for next week's "ACCESS DAY" is as follows: ************************************ INTRODUCTION TO ACCESS 9:30 AM to 12:00 NOON ************************************ "INTRODUCING THE BEGINNING USER TO ACCESS", "Macros and Modules" Part V of a multi-part series. Presented by: Dean Serrentino, (d.serrentino@ai-host.net) Dean will explore the differences between these seemingly similar Access components. Learn when and where to use each; and more importantly, when not to. ************************************** MICROSOFT ACCESS 1:00 PM to 4:00 PM ************************************** "ACCESS SECURITY" Presented by: Dean Serrentino, (d.serrentino@ai-host.net) Learn about the various security options built into Access, and how to implement them in your own applications. ***************************************** THE ACCESS TRAUMA CENTER 4:30 PM to 5:30 PM ***************************************** Presented by: John Giuliano, Stone-Crowne Associates, (jgiuliano@stowne-crowne.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: Evening Session User Group Meeting 5:30 PM to 6:30 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 6:30 PM to 7:00 PM ************************************ "OPEN FORUM" Stand Up and be heard... general announcements, suggestions, etc. ************************************ MICROSOFT ACCESS Main Meeting-Session I 7:00 PM to 7:30 PM ************************************ "UTILITIES I HAVE KNOWN AND LOVED" Presented by Frank Butash, (FrankButash@email.msn.com) ACCESS is an excellent platform to use to easily gather information from almost any source of data. VB Script programs can efficiently pre-process data in the WINDOWS environment and prepare it for use by ACCESS. This presentation demonstrates a neat set of generalized VB Script programs that process TEXT files for input to ACCESS. Handouts will provide attendees with a copy of source code and VB instruction materials. ************************************ MICROSOFT ACCESS Main Meeting-Session II 7:30 PM to 8:30 PM ************************************ "EVERYTHING YOU NEED TO KNOW ABOUT MULTI-SELECT LIST BOXES...AND THEN SOME" Presented by Alex Giuliano of Stone-Crowne Associates, (agiuliano@stowne-crowne.com) Alex takes us through the basics of using Multi-Select List Boxes in your Microsoft Access applications. He helps us to understand the programming differences between a default List Box and a Multi-Select List Box, and how to take advantage of them. After demonstrating the basics using a simple form, he will show us a more complex example of using layered Multi-Select List Boxes. The Access MDB will be available via Email after the session. **************************************************************************** **************************************** *********************U S E R T I P****************U S E R T I P******************U S E R T I P************ **************************************************************************** **************************************** This month's User Tip was sent to us by Pat Tormey of Foursquare Solutions Incorporated. Thanks Pat! This Single Subroutine copies the structure of local OR attached tables to an Excel Spreadsheet. You'll find it handy for searching and documenting your work.. Or somebody else's. Please see the attachments to this email message for the complete User Tip! **************************************************************************** ********************* 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. Also, please note Luna Systems' new address and phone number in North Andover. Happy Holidays and a safe, healthy and Happy New Year to all! See you in Waltham, Donna Rae Luna Systems Corporation 1000 Osgood Street No. Andover, MA 01845 DonnaR@lunasystems.com www.lunasystems.com All events take place at: Microsoft 230 Third Avenue Waltham, MA For directions: http://www.microsoft.com/usa/offices/waltham.asp 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-327-6400 ****************************************************************************