This will be a 101 level introduction to VBA class modules and how they can be used in Access. Sco will start by comparing class modules and standard modules which will include their relationship with objects. Then he'll cover the special events, Initialize and Terminate, that are associated with class modules. Next, Sco will show how to create properties and events in a class module.
Join us for what will be an interesting discussion of this rarely feature of VBA and Access.
Our presenter, M. L. "Sco" Scofield is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and past officer of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0. Sco spends a large amount of his time as an instructor training all levels of Access from the introductory level all the way through advanced programming. When he is not training or consulting, Sco spends time helping other Access users in the Access newsgroups on the Internet. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award for his fourth consecutive year this past October in recognition of the time he spends helping Access users.
See Sco's company profile on our DAAUG web site in the Consultant list and on his web site at www.ScoBiz.com.
"It's a Date" by Jim Pilcher
One thing that all Access developers struggle to master is date manipulation. Whether it be in a simple select query or complicated mental gymnastics inside a code module, dates have puzzled even the best of programmers. Come to the February edition of the Denver Area Access Users Group. Your presenter, Jim Pilcher, promises his fingers will never leave his hand as he performs date magic right before your eyes.
Jim Pilcher is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. A Microsoft Certified Professional, Jim’s company, DataOne, Inc., maintains a broad clientele base providing Access & SQL Server solutions for local enterprises and large international companies. He is currently serving his sixth year as President of the Denver Area Access Users Group.
See Jim’s company profile on our DAAUG web site in the Consultant list and on his web site at www.DataOneDenver.com .
"The Data Veg-A-Matic" by M. L. "Sco" Scofield
A common situation that Access developers encounter is having to import data from other sources like old databases, spread sheets, text files, etc. The problem is that the data is never in the format that you need for your database tables. Sco will show some techniques to "slice and dice" the imported data into bits and pieces so that it can be moved into your database's tables. See how functions and update queries can be used to "fix" the data.
Our presenter, M. L. "Sco" Scofield is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and Vice President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0. Sco spends a large amount of his time as an instructor training all levels of Access from the introductory level all the way through advanced programming. When he is not training or consulting, Sco spends time helping other Access users in the Access newsgroups on the Internet. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award for his fourth consecutive year this past October in recognition of the time he spends helping Access users.
See Sco's company profile on our DAAUG web site in the Consultant list and on his web site at www.ScoBiz.com.
Have you ever fully explored all of the settings available to you in the Tools/Options menu selection in Access? What does the "Default database folder" setting do for you? What are the ramifications of "Compact on Close"? Discover the value of manipulating Access options both interactively and in VBA code.
Jim Pilcher is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. A Microsoft Certified Professional, Jim’s company, DataOne, Inc., maintains a broad clientele base providing Access & SQL Server solutions for local enterprises and large international companies. He is currently serving his sixth year as President of the Denver Area Access Users Group.
See Jim’s company profile on our DAAUG web site in the Consultant list and on his web site at www.DataOneDenver.com .
Have you ever heard about splitting a database? Wondered what it meant? Do you know about "front-ends" and "back-ends?" Do you know the pros and cons? Did you know that it’s absolutely critical to split your database if the data is to shared?
Learn the answers to these questions and more! Learn about the splitter wizard. Learn about re-linking tables. Learn about why to keep a table in the back-end open. Learn about keeping the front-end updated. Learn about a technique to reduce front-end bloat. Come spend an informative and entertaining evening with our resident MVP and current Vice President for this and more!
Our presenter, M. L. "Sco" Scofield is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and Vice President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0. Sco spends a large amount of his time as an instructor training all levels of Access from the introductory level all the way through advanced programming. When he is not training or consulting, Sco spends time helping other Access users in the Access newsgroups on the Internet. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award for his fourth consecutive year this past October in recognition of the time he spends helping Access users.
See Sco's company profile on our DAAUG web site in the Consultant list and on his web site at www.ScoBiz.com.
NOTE: This presentation will be a little different this month. Viki will be giving her presentation via Live Meeting from Microsoft in Redmond, Washington.
In this presentation, you will learn how to link to, edit, and report on data stored on a Windows SharePoint Services site. We will cover features that make SharePoint sites powerful sites for collaboration, including: document libraries, calendars, announcements, built in and custom lists.
Our presenter, Viki Selca is Program Manager on the Access team who focuses on ease of use features in Access 12. Viki's interests include accessibility, application deployment, and schema creation.
Your clients most likely have Office on their desktop. Have they asked you how to get information from their database into a Word or Excel document? Specifically into the task pane along side their document. The mystery will be exposed. It is easy using the Office Research Pane SDK, and Visual Studio Tool for Office 2005, but can also be done using VB6 implementing the ISmartDocument interface. We will look at these tools and technologies. Presenter is Mel Harris, long time DAAUG user group supporter and the founder of the “Toolman” educational series for Microsoft. He has presented many times at this and other user groups as well as for major Microsoft events. He in a MVP and MCSD and is the principle presenter for the OnLion Training Group LLC which hosts online training on the practical use of Microsoft tools and technologies to improve productivity.
Large and small enterprises respond to Requests for Proposals (RFP) in order to win business contracts. In this presentation to DAAUG, you will see how MS Access has been used to develop a knowledgebase that ensures that corporate, industry and competitive information is readily accessible to business development teams. The application uses functionality built into Access to view, query, and output information (sometimes data) to MS Word, Excel, Project, Outlook, and MapPoint. The app makes extensive use of memo and date fields.
The presenter will be David Nealey, a business and proposal consultant. He has been an Access user and DAAUG member for the past three years. He has taken Access classes from Scofield Business Services of Denver and Red Rocks Community College. David has consulted on numerous proposals for companies in Colorado, Florida, Virginia, and Texas. He recently supported a Geographic Information Systems Needs Assessment for a major water-electric-fiber utilities company in Florida using Six Sigma and "Voice of the Customer" principles. He enjoys playing with his first grandson and vacationing in Florida.
Learn how to add, change, and delete records in an Access database using unbound forms. Yes, unbound forms are a secret weapon for advanced developers who want ultimate control over database manipulation and multi-user issues. Jim Pilcher will show you some simple examples of how you can implement this flexible and powerful method of development.
Jim Pilcher is president of the Denver Area Access Users Group, currently in his sixth year in office. Jim is also Senior Partner of DataOne, Inc. www.dataonedenver.com, an Access and SQL Server consulting firm with clientele throughout the Colorado Front Range and Wyoming.
This presentation will be a complete look at a mini, one-form application starting with the original concept and taking it all the way through turning it into an Access add-in so that it is always available. What's the application? It's a designer utility that sends the basic information about all of the table designs in a database to an Excel workbook.
This presentation will be an advanced presentation with lots of VBA code. You will see how to extract table information using DAO, how to control Excel using Automation, and how to make a user interface to control the application and provide user information. The presentation will wrap up with a few techniques to put the final "polish" on the application and what it takes to turn a project like this into an Access add-in.
Come spend an informative and entertaining evening with our resident MVP and current Vice President!
Our presenter, M. L. "Sco" Scofield is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and Vice President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0. Sco spends a large amount of his time as an instructor training all levels of Access from the introductory level all the way through advanced programming. When he is not training or consulting, Sco spends time helping other Access users in the Access newsgroups on the Internet. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco has received the prestigious "Microsoft MVP" award every year since 2001 in recognition of the time he spends helping Access users.
See Sco's company profile on our DAAUG web site in the Consultant list and on his web site at www.ScoBiz.com.
NOTE: This presentation will be a little different this month. Like our May meeting, Tim will be giving his presentation via Live Meeting from Microsoft in Redmond, Washington.
Explore several ways in which XML will unlock new scenarios. Learn how to generate HTML reports via XML and how to generate Word and Excel files via XML and XSL transforms. Also see how XML data can be imported into Access.
As a program manager on the Access team, Tim Getsch is responsible for features going into the next release of Access. Tim has been at Microsoft for five years and has worked on Access 2003 and Excel 2002. Prior to Microsoft, Tim developed database applications in VB, PowerBuilder, and Clarify. Tim holds a bachelor's of science degree in mathematics and a master's degree in computer science both from the Institute of Technology at the University of Minnesota.
Presentation One: The Access Sub-way by Jim Pilcher
Subforms in Microsoft Access are possibly the most effective way to represent one-to-many relationships to your users. DAAUG President, Jim Pilcher, will show you some of the standard practices and hidden surprises that are part of using Access subforms.
Our first presenter, James Pilcher, is a prominent Microsoft Access developer in the Colorado–Wyoming region, having worked with Access professionally since its inception in the early 1990s. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local enterprises and large international companies. A frequent presenter at DAAUG, Jim is currently serving his sixth term as President of your Denver Area Access Users Group.
See Jim’s company profile on our DAAUG web site in the Consultant list and on his web site at www.DataOneDenver.com .
Presentation Two: DAO Transactions by M. L. "Sco" Scofield
An "all or nothing" presentation! Be prepared for some VBA!
Our second presenter, M. L. "Sco" Scofield is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and Vice President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0. Sco spends a large amount of his time as an instructor training all levels of Access from the introductory level all the way through advanced programming. When he is not training or consulting, Sco spends time helping other Access users in the Access newsgroups on the Internet. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 2001 to 2005 in recognition of the time he spends helping Access users.
See Sco's company profile on our DAAUG web site in the Consultant list and on his web site at www.ScoBiz.com.
The Denver Area Access User Group hosts its annual Holiday party on December 15th. This is the annual "let your hair down" user group meeting. Holiday refreshments and goodie give-aways rule the evening.
This meeting is for members and visitors to meet, relax, and chat. Door prizes and an evening-long drawing highlight the gathering.