General Meeting Presentations

Upcoming Presentations

Tuesday, November 7, 2017

Jim Pilcher

Data-Bound Gantt Charts in Access

Jim Pilcher

One of the many reasons Access has been such a popular application development environment is the wealth of rich user experience options available to power users and developers. One example of this is the ability to draw charts and graphs directly in Access reports.

DAAUG Vice-President Jim Pilcher will present his development of data-bound Gantt charts. Jim developed the charts as part of an Access application for the City of Denver to track and report project progress over time. The application and charts were recently featured in a session at Microsoft's 2017 Ignite conference. Join us for an evening of camaraderie and cutting-edge Access charting!

Tuesday, December 5, 2017

Annual Christmas Holiday Party

No Main Presentation - It's the Annual Christmas Holiday Party! The majority of the meeting is for members and visitors to meet, eat well, relax, and chat.

Past Presentations

Tuesday, October 3, 2017

Lee Milligan

Certifiably Access: An overview of Access certification via the MOS (Microsoft Office Specialist) program.

Lee Milligan

DAAUG Treasurer Lee Milligan will show how one of the most recognized and relevant certifications for Microsoft Access can be obtained and the steps of preparing for the exam process, with related resources. We will also briefly cover Certiport, the main administrator of testing solutions, and its role in the overall process.

Lee entered the IT/Software Development market in 1999 with an emphasis on Microsoft Access database creation and support of existing network distributed database applications. He soon began VBA (Visual Basic for Applications), SQL Server, and .NET development as technologies evolved. Several of his Microsoft Access database applications are still deployed in production after 18 years and have stood the test of time through over five versions of Microsoft Access.

Tuesday, September 5, 2017

Member Show and Share

DAAUG Members

Come see what your fellow members have been up to with Access! Join us for an evening of folks sharing cool features of their Access applications. We'll have four or five 20-minute presentations, with Q&A.

Tuesday, August 1, 2017

Michal Bar, Microsoft Access Program Manager and Jun Yong Kim, Microsoft Access Senior Developer

Microsoft Access: Past, Present and Future

Michal Bar, Microsoft Access Program Manager and Jun Yong Kim, Microsoft Access Senior Developer

Microsoft Access Program Manager Michal Bar and Senior Developer Jun Yong Kim join us to talk about the current state of Microsoft Access and plans for the future. They'll also demo some new and upcoming features in Access, and take your questions. Please plan to join us for this special occasion! (Note: this will be our first of four meetings at the Park Meadows Microsoft Store, while the Microsoft DTC offices are being remodeled).

Michal is a program manager in Microsoft and the product lead and champion for Access since 2014. Prior to Microsoft, Michal spent 10 years at Intel’s mobile division, mainly focused on SQL based solutions for microprocessors validation processes. She has served as a press non-commissioned officer in the IDF, and holds a B.Sc. in Information Systems engineering from the Technion institute of Technology in Israel. She feels honored to be part of the Access team, with the opportunity to make an impact on the product and millions of engaged customers all over the world.

Jun Yong is a Senior Software Engineer in Microsoft, joined Access team in 2013 and have spent most of his time to make Access Services on SharePoint Online work better with SQL Azure. He has been with Microsoft for 13 years and has worked on SharePoint Designer and Workflow before joining Access team. Jun Yong holds M.S in Computer Engineering from Seoul National University in Korea and Architecture and Performance are his topics of interests ever since then. His day to day mission, which he is proud of, is to keep Access Web App customers connected to their apps without concerning what’s happening behind the scene.

Tuesday, July 4, 2017

July Meeting Cancelled Due to July 4 Holiday

Due to our July meeting falling on July 4th, we have cancelled the July meeting this year. Enjoy your holiday, and see you in August!

Tuesday, June 6, 2017

Brandon Smith

Bridging Technologies: Leveraging the Power of Access and Modern Cloud Infrastructure to Delight Users

Brandon Smith

How can you bring the power of your database to users via the web browser? How can you bring the power of a web experience to MS Access desktop forms? In this session we'll look at several ways deploy solutions that are available to any user via responsive web application while still having the familiarity of MS Access desktop for your power users. We'll discuss the pros and cons of various approaches (file server front-end/back-end, Office 365, Amazon RDS) and some live case studies that include deployment, security, and maintenance. We'll also look at ways to revamp your existing MS Access applications to give users a more web-like experience on the desktop.

Brandon has been working with Access since 2.0, founding OpenGate Software in 2001 to offer MS Access tools that streamline development and make it easier for general business users to create powerful database applications without years of experience.

Tuesday, May 2, 2017

George Young

Access.NET: How we built daaug.org from a set of Access databases

George Young

DAAUG President and Webmaster George Young will present how we created our new mobile-friendly daaug.org website from a set of Access databases. We'll walk through combining the databases into a single accdb, upsizing the database to SQL Server, auto-generating an ASP.NET MVC website from the database, and using Access forms to administer the site content.

Join us for this step-by-step journey into Access working in the brave, new cloud-first, mobile-first world!

George first encountered Microsoft Access when using the thirty-plus floppy disk versions of Office to teach Statistics and MIS in the early 1990’s. It’s been true love ever since. George has worked as a software developer for the past twenty years, including twelve at Microsoft (in just about every group other than Office). He is the founder and president of Dawson Butte Software, working primarily on .NET applications (often with Access somewhere in the mix). George still has a commercial site or two that is driven by an Access database sitting in the server file system.

Tuesday, April 4, 2017

Tom Vincent

Everything You Need to Know About Numeric Rounding Functions

Tom Vincent

Microsoft Access, SQL Server, and Excel all provide one function for rounding numbers called ROUND. This implements a rounding algorithm commonly know as the Banker’s Round (AKA Round Half Even). Excel also provides two other versions called ROUNDUP and ROUNDDOWN.

But there are many different ways to round numbers. If you are getting your data from another source and you need your calculations to match that source’s calculations, you may need to use a different algorithm. Indeed, you may need to contact the source to find out what algorithm they have used. Also, errors can creep in when you need to implement multiple rounds e.g. a further round of an already rounded value.

A sample database will be provided on the DAAUG website that contains a VBA code module which implements a dozen different algorithms. You can use this directly in your own projects by importing the module!

A ‘gotcha’ and work around will be discussed concerning using DoEvents inside (math) functions that are going to be called thousands of times at a pop.

Download the presentation materials

Tuesday, March 7, 2017

Christian Steppat

How to Sell an Application Based on Microsoft Access as a Product

Christian Steppat

Have you considered developing an Access application for sale? If so then this is the DAAUG meeting for you. Come and learn the marketing, advertising and application maintenance issues that will help you operate a profitable company.

Christian Steppat, database developer and owner of the CRM (Customer Relations Management) application called SuccessControl (CRM) will talk us through the various aspects of selling your application to individuals and companies who need it. Christian sells his SuccessControl (CRM) to customers in Germany, Austria and Switzerland. His main marketing tool is a website where interested parties can download a trial version of his application. The website is also where his customers can watch instructional videos showing the benefits and functionality of the application, and learn about recent releases. He supplements the website with a newsletter that is sent to his customers.

To limit the use of the application to the trial period, Christian uses a sophisticated technique way that is similar to cryptography. Christian will also walk us through his process for securing the application from even the likes of the NSA. And you will also learn how to interrogate a user’s computer to determine which version of Access they have installed: 2007 to 2016, 32 or 64 bit.

Tuesday, February 7, 2017

Paul Schnitzler

Crosstab Query Tips and Tricks

Paul Schnitzler

See how to summarize data so it easier to read and understand using crosstab queries. We will start with the very basics of using the Wizard and Designer to create a simple crosstab. Then explore a half a dozen crosstab tricks and methods that you will want to know… some commonly known and 3 that are less common / more advanced. We will end with a real-life example of a review dashboard that uses a dynamic crosstab.

Paul Schnitzler if a fulltime Access & SQL Server developer serving a wide variety of business. He has over 17 year of experience with Access and SQL Server. Visit his web site at www.gearitservices.com

Tuesday, January 3, 2017

Jim Pilcher and George Young

Real-Life Access and SQL Azure – Live Demo and Lessons Learned

Jim Pilcher and George Young

So, you’ve heard that Access front-ends with cloud-based SQL database back-ends are the future, but how does it all actually work out in a real-life enterprise application? Join DAAUG President Jim Pilcher and Vice-President George Young as we dig into the details on the real-life implementation of migrating a large all-Access database to an Access front-end using an Azure SQL Database back-end. We’ll go through the migration process, the challenges faced, and some general rules of thumb for a successful transition. We’ll have a live demo of the application, as well as a detailed look at some of the changes required in Access to optimize performance. We’ll also look at some additional benefits of having the database in SQL Azure, including a live web site and Power BI reports.

Download the presentation materials

Tuesday, December 6, 2016

Annual Christmas Holiday Party

No Main Presentation - It's the Annual Christmas Holiday Party! The majority of the meeting is for members and visitors to meet, eat well, relax, and chat.

Tuesday, November 1, 2016

Dax Sapien

The DAAUG Access Report Writer

Dax Sapien

DAAUG recently took ownership of the Access Report Writer, donated to the group by Mike Hnatt of Gladstone, Inc. This Access add-in automates the generating of custom reports within your Access application. Dax Sapien will walk us through downloading and installing the add-in, and using it in an Access application.

Dax is a Telecom industry professional with 17 years experience. He is currently working with Ecova Inc. as a TEM Engineer developing solutions to automate the telecom expense management processes with MS Access.

Time permitting, George Young will give a quick overview of using the Access Table Analyzer to quickly create a set of related tables from a single flat file.

Tuesday, October 4, 2016

Paul Schnitzler

Consuming Web Services in Access

Paul Schnitzler

Access developers can leverage all the power of the Internet from the comfort and convenience of their familiar VBA code modules. We will review a real life application that processes credit cards in Access with no storage of credit card data… so it is PCI Compliant. You will see how 9 web calls to Authorize.net work together with Access. See how XMLHTTP and XML are used to tie Access to the web.

Paul Schnitzler if a full time Access & SQL Server developer serving a wide variety of business. He has over 16 year of experience with Access and SQL Server. Visit his web site at www.gearitservices.com.

Tuesday, September 6, 2016

Rod Stephens

Database Design Scenarios

Rod Stephens

In this talk, C# and Visual Basic author Rod Stephens will walk through a group discussion leading to the design of some practical databases. He’ll first discuss three general approaches to database design: existing data centered, UI centered, and database centered.

Then Rod will lead the group in several attempts to design several databases from scratch. As a group, we’ll think of database scenarios and develop robust and flexible designs to handle them. We’ll normalize (and denormalize) them as necessary to prevent data anomalies as the databases are used and modified over time.

Rod Stephens started out as a mathematician, but while studying at MIT, discovered how much fun programming is and has been programming professionally ever since. During his career, he has worked on an eclectic assortment of applications in such fields as telephone switching, billing, repair dispatching, tax processing, wastewater treatment, concert ticket sales, cartography, and training for professional football players.

Rod has been a Microsoft Visual Basic Most Valuable Professional (MVP) for more than 12 years and has taught introductory programming. He has written 30 books that have been translated into languages from all over the world, and more than 250 magazine articles mostly covering Visual Basic, C#, Visual Basic for Applications, Delphi, and Java.

Rod’s popular VB Helper web site (http://www.vb-helper.com) receives several million hits per month and contains thousands of pages of tips, tricks, and example programs for Visual Basic programmers, as well as example code for this book. His C# Helper web site (http://www.csharphelper.com) contains similar material for C# programmers.

You can contact Rod at Rod Stephens at C# Helper or Rod Stephens at VB Helper.

Tuesday, August 2, 2016

George Young

PowerApps: A Tour of Microsoft's new data-driven cross-device RAD environment

George Young

Microsoft PowerApps has just gone into public preview. Join us as we introduce this new platform and walk through creating a couple of data-driven apps that run on iOS and Windows, as well as the web, from an Access developer's perspective.

PowerApps is a service for creating, managing and using custom business apps across platforms. PowerApps connects to your existing systems and data sources securely, allows you to build apps, forms, and workflows without writing code, and lets you publish apps instantly for web and mobile.

Download the presentation materials

Tuesday, July 5, 2016

Cancelled Due to July 4 Holiday

Due to our July 5th meeting falling at the tail end of the long July 4th weekend, and because July is usually a lightly-attended DAAUG meeting, we have cancelled the July meeting this year. Please join us for our July 15th Access Fridays III meetup -- Web Database Development if you are looking for some good database camaraderie during July!

Tuesday, June 7, 2016

Member Show and Share

DAAUG Members

Come see what your fellow members have been up to with Access! Join us for an evening of folks sharing cool features of their Access applications. We'll have four or five 20-minute presentations, with Q&A.

Tuesday, May 3, 2016

Mike Hnatt

Gladstone, Inc. ShoWorks: A Real-Life Access Success Story

Mike Hnatt

ShoWorks is the leading fair management software in North America, with a 75% market share. Mike Hnatt developed the application in 1996 with Access skills and industry knowledge, and has grown his company and software into a market leader now generating $1 million in annual sales. Still a classic Access desktop application at its core, ShoWorks now additionally supports iPad and web browser access. Please see a video demo of ShoWorks here: www.fairsoftware.com

Mike will be joining us to talk about his experience making an Access application into an industry-leading software program. We’ll hear about how he developed the software, some of its great features, how he marketed and grew his business, and his thoughts about Access going forward. There will be plenty of time for questions, as well.

Please join us for this very special presentation and discussion!

Tuesday, April 5, 2016

Jim Pilcher

It’s a Matter of Form

Jim Pilcher

There are myriad ways to accept and present Access data on your screen through creative form design using Microsoft Access’ powerful form builder. DAAUG president, Jim Pilcher, will guide you through the common form types, some uncommon implementations, and a number of important form events that macro and VBA programmers need to understand. We may even discuss Access reports and ReportView, which is a special case of an Access form. At the end of this presentation, you will be loaded with new and creative form ideas for your own projects and those of your clients.

Tuesday, March 1, 2016

Patrick Headley

Create ODBC Connections the Easy Way

Patrick Headley

Discover the little known RegisterDatabase() function within Microsoft Access. This function allows you to create ODBC connections without the need to write an installation script. It makes it so easy, even your application users will be able to create ODBC connections and they won't even know they did it. The presentation will describe the RegisterDatabase() function and then show you how to combine it with global variables and compiler arguments to create a flexible application that can automatically select the right data source for the environment it is placed in.

Tuesday, February 2, 2016

Cancelled Due to Weather

A winter storm has caused us to reschedule this presentation to a future date.

Tuesday, January 5, 2016

Susan Mathison

Functions, Functions & More Functions!

Susan Mathison

After board member elections, Sue Mathison will talk about functions and how they work inside Access databases. We will cover a good variety of built-in functions as well as how to create your own custom VBA functions. We’ll also look at how functions can be used in all types of Access objects.

Tuesday, December 1, 2015

Annual Christmas Holiday Party

No Main Presentation - It's the Annual Christmas Holiday Party! The majority of the meeting is for members and visitors to meet, eat well, relax, and chat.

Tuesday, November 3, 2015

Jim Pilcher

Home-Grown Developer Tools for Microsoft Access

Jim Pilcher

Your DAAUG President, Jim Pilcher, will show you some of his simple hand-rolled VBA utilities that he uses to help with his Access development projects. We will also write a small tool on the spot to show just how quickly a bit of VBA can be written and used in the midst of a project.

Tuesday, October 6, 2015

George Young

Microsoft Access Power BI

George Young

Microsoft’s free data analytics and reporting tool, Power BI, has just released to general availability, and now supports Microsoft Access databases as a data source! Come find out how to quickly and easily build rich, dynamic, interactive reports and dashboards on your Access databases.

Download the presentation materials

Tuesday, September 1, 2015

Susan Mathison

VBA 102

Susan Mathison

This is a follow-on to Susan's wildly popular introductory July, 2015 presentation for everyone who wants to know how to unleash the power of VBA behind Microsoft Access, but is afraid to get started. Look for information on looping, arrays, data types, debugging tools, intrinsic VBA functions, and much more.

Susan Mathison is new to our group this year and a new presenter for us. Please give her another warm welcome for her second presentation at DAAUG.

Tuesday, August 4, 2015

Patrick Headley

Use Pass-through Queries for a More Robust Database Solution

Patrick Headley

You’ve created a database application in Microsoft Access and you used a database server, as the back-end in order to achieve a high level of performance but there are still some complex processes in your application that take a long time to complete. For example, maybe there’s a report with a large amount of aggregated data that takes a long time to display, even though you used a server View for performance. Don’t lose hope. Maybe all you need is a Pass-through Query and some code.

In this presentation you will see how Microsoft Access Pass-through Queries are different from the queries that you normally see in Microsoft Access and how they can make even the most complicated features of your application run quickly. While the focus of the presentation is on Pass-through Queries, you will also see some database server code. This presentation begins with some basic query concepts and finishes with some complex procedures that take advantage of Pass-through queries. So, whether you are new to Microsoft Access or a seasoned pro, there is something in it for you.

Patrick Headley is the President of Linx Consulting, Inc., serving as a database, web and application developer/consultant. He uses various database and application development products, including Microsoft Access, Microsoft SQL Server and .Net. Patrick creates databases and applications from the ground up and also fixes and improves upon databases and applications that were written by other developers; working for for-profit and non-profit organizations. Patrick is the current Web Master of the Denver Area Access Users Group and a Past President of the group. He can also be seen on a regular basis at the DAAUG lab meetings. Please visit the Linx Consulting, Inc. website at www.linxco-inc.com for more information.

Tuesday, July 7, 2015

Susan Mathison

VBA 101

Susan Mathison

This will be an introductory presentation for everyone who wants to know how to unleash the power of VBA behind Microsoft Access, but is afraid to get started.

Susan Mathison is new to our group and a new presenter for us. Please be prepared to give her a warm welcome as she discusses her first topic at DAAUG!

Tuesday, June 2, 2015

Andy Tabisz

Real-World Forms Automation

Andy Tabisz

Andy's company (WorkSmart Database Masters) focuses on providing automated, easy to use user interfaces designed to help companies achieve more in less time.

He will be demonstrating many of his strategies to accomplishes this objective, including dynamic data-driven combo boxes based on tables instead of value lists, with different options to make it easy for users to add choices. This is especially important in cases where clients need to see different combo box options based on which customer they are viewing at the time.

You will also learn how to add a << Select All >> option into the top of a combo box list to make that control more intuitive for users. And, Andy often uses cascading filters, list box group selection and full form calendars, to his databases. Additionally, you'll learn how to dynamically test for and re-attach back end databases and even quickly swap back ends based on project, client or year.

Andy Tabisz, MCAS, MOS, is the owner of WorkSmart Database Masters, LLC, a Michigan-based technology firm focused on providing custom database and web app solutions designed to increase productivity. He has been developing databases since 1983 and is a frequent speaker at Microsoft Access and SQL conferences across the country. Andy is also very involved in the user group community and was recently awarded the 2015 Microsoft MVP Award.

Andy earned an Associates in Business 1987, then pursued a career in IT. His roles have included Software Support, Director of Training, Regional Director or Sales, Hardware & Networking Manager, Director of Automation/IT and Owner of 3 tech companies. Andy founded WorkSmart in 2008, offering software and app development to clients across the U.S. WorkSmart has consultants in Grand Rapids, MI, Detroit, MI, Florida and Arizona.

Andy enjoys traveling with his wife Marcia and his interests include golfing, movies and mentoring others. He also is a huge Dave Ramsey fan and an avid reader of business and marketing books.

Tuesday, May 5, 2015

George Young

Windows 10 and Office 2016

George Young

Windows 10 and Office 2016 previews have been released! Over the coming months, Microsoft will be rolling out periodic updates to both Windows and Office. Want to try the latest and see how Office and Windows are changing? Want to do this without endangering your work machine or buying a test machine? You’ve come to the right place. We’ll walk through setting up a Virtual Hard Disk (VHD) using a PowerShell script from a Windows 10 Preview DVD image (ISO) in a matter of minutes, and then adding this to the boot manager so that we can dual boot any machine to either our primary OS or to the Preview. We’ll also install the Office 2016 Preview and have a quick look!

George first encountered Microsoft Access when using the thirty-plus floppy disk versions of Office to teach Statistics and MIS in the early 1990’s. It’s been true love ever since. George has worked as a software developer for the past twenty years, including twelve at Microsoft (in just about every group other than Office). He is currently an independent consultant living at 7000 feet in Larkspur, Colorado, working primarily on .NET applications. George still has a commercial site or two that is driven by an Access database sitting in the server file system.

Download the presentation materials

Tuesday, April 7, 2015

George Young

Remote Access Access

George Young

In an era of increasing diversity of devices, there are some interesting options for providing full Access client access to all users, regardless of device or operating system. Two of these, both available today on Microsoft Azure, are a Virtual Machine hosting Access 2013 with Remote Desktop Services used to access the shared resource; and, RemoteApp, a new offering on Azure that offers some interesting differences compared to a straight VM. We’ll take a look at both of these, setting up a fully-running instance of each, and evaluate pros and cons of each approach.

George first encountered Microsoft Access when using the thirty-plus floppy disk versions of Office to teach Statistics and MIS in the early 1990’s. It’s been true love ever since. George has worked as a software developer for the past twenty years, including twelve at Microsoft (in just about every group other than Office). He is currently an independent consultant living at 7000 feet in Larkspur, Colorado, working primarily on .NET applications. George still has a commercial site or two that is driven by an Access database sitting in the server file system.

Download the presentation materials

Tuesday, March 3, 2015

Jim Pilcher

The Power of Report View

Jim Pilcher

An evening of discovery of the widely misunderstood Microsoft Access Report View, first introduced in Access 2007. Your presenter, Jim Pilcher, will show you how to leverage the similarities and differences that Report View has with the tried-and-true Print Preview in Microsoft Access. Jim will also show you advanced users the VBA report events gotchas when you first begin exploring Report View for serious applications.

Jim Pilcher, the current DAAUG President, is a prominent Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since its introduction in 1992. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local and state-wide enterprises, as well as large international companies. A frequent presenter at the Denver Area Access Users Group, Jim has served eight terms as its President, and five terms in other DAAUG capacities. Visit his web site at www.dataonedenver.com

Tuesday, February 3, 2015

Rod Stephens

Algorithms 101

Rod Stephens

Many people believe that algorithms are magical creations anointed by famous developers of yore. In fact, an algorithm is simply a recipe for doing something useful on a computer. In this talk, algorithm expert Rod Stephens demystifies some of his favorite algorithms. Using intuitive concepts (without a lot of math), he’ll explain:

  • Quicksort (The most commonly used sorting algorithm)
  • B-trees (Which databases use to manage indexes)
  • Shortest path algorithms (Similar to the ones used by Google Maps. Maybe. They’re not telling.)
  • The police donut routing problem (Sometimes called the traveling salesman problem.)
  • The booty division problem (Sometimes called the partition problem.)
  • Other algorithms if time permits
Rod Stephens started out as a mathematician, but while studying at MIT, discovered how much fun programming is and has been programming professionally ever since. During his career, he has worked on an eclectic assortment of applications in such fields as telephone switching, billing, repair dispatching, tax processing, wastewater treatment, concert ticket sales, cartography, and training for professional football players.

Rod has been a Microsoft Visual Basic Most Valuable Professional (MVP) for more than 12 years and has taught introductory programming. He has written 28 books that have been translated into languages from all over the world, and more than 250 magazine articles mostly covering Visual Basic, C#, Visual Basic for Applications, Delphi, and Java.

Rod’s popular VB Helper web site (http://www.vb-helper.com) receives several million hits per month and contains thousands of pages of tips, tricks, and example programs for Visual Basic programmers, as well as example code for this book. His C# Helper web site (http://www.csharphelper.com) contains similar material for C# programmers.

You can contact Rod at Rod Stephens at C# Helper or Rod Stephens at VB Helper.

Tuesday, January 6, 2015

Patrick Headley

Access, Meet Your Data: Connecting Microsoft Access to Various Data Sources

Patrick Headley

Did you know Microsoft Access can connect to databases other than Access and SQL Server? Did you know that Access allows you to connect to multiple database engines at the same time? Join Patrick Headley this month at the Denver Area Access Users Group and learn how you can use Access to:

  • Connect to many different database engines, all at the same time.
  • Use Access to aid in moving data from one database to another.
  • Find out how Access can help you manage data for analysis and reporting in real-time.
  • Learn some of the finer points of working with non-Access data.
  • Get your connectivity questions answered.
Patrick Headley is the President of Linx Consulting, Inc., serving as a database, web and application developer/consultant. Patrick is the current Web Master of the Denver Area Access Users Group and a Past President of the group. Patrick has written new applications from the ground up and has fixed and improved upon pre-existing applications for clients in a wide variety of for-profit and non-profit organizations using Access, plus several database and Web technologies. Visit the Linx Consulting, Inc. website at www.linxco-inc.com.

Tuesday, December 2, 2014

Annual Holiday Party

No Main Presentation - It's the Annual Christmas Holiday Party! The majority of the meeting is for members and visitors to meet, eat well, relax, and chat.

Tuesday, November 4, 2014

Constance Wells, MS, PMP, CPD

Write a Best Seller: Creating Application User Guides

Constance Wells, MS, PMP, CPD

This presentation will show the planning process, made repeatable, for software-application programmers and their team in creating and publishing Application User Guides for their customers.

There are many types of support documentation and this presentation's focus is on the Application End User Guide.

Having good User Guide software documentation frees up the time which programmers usually use to answer real-time end users questions when the user encounters application errors or has questions. A User Guide helps an end user accomplish their work quickly without having to call a developer. A developer is then free to build better, more efficient algorithms.

In the framework of end user application support, there exists Tier I, Tier II, and Tier III, end user support. These tiers help identify the support given to end users with problems and questions when using an application. Programmers usually help solve Tier III or IV level software problems and questions, depending on the size of the company. A User Guide provides Tier I help to the end user.

Overall, good software documentation is specific, concise, and relevant, providing all the information important to the person using the software. The Tier I support level User Guide documentation contains answers for end users of the most frequently asked questions and provides solutions to the most frequently occurring problems. Offloading a programmer from these recurring interruptions is best when provided by a professional technical writer who creates User Guides and other support documentation.

Constance Wells is a leading expert on technology management of large-scale efforts comprising portfolios of projects for government and business requiring contractual documentation (System Guides, User Manuals, Quick Guides, Help Desk Guides, End User Appl Training, etc.). As the owner of Business Intell Technology, Wells partners with executives to meet performance goals, drive change management efforts across the enterprise, write proposals and respond successfully to RFPs. She manages IT portfolio project budgets from $500K to $300 million, builds and leads teams, and recommends the appropriate staff and resource for global IT projects.

Tuesday, October 7, 2014

Alison Balter

Class Modules

Alison Balter

Access offers two kinds of modules: standard modules and class modules. A class module is a great way to encapsulate related functions into a portable, self-contained object. Most developers don’t make use of what class modules have to offer. In this session you will learn why class modules are important. You’ll see how easy it is to create custom objects, properties, methods, and events. You’ll leave the session with several practical examples of how you can benefit from class modules.

Alison Balter is the president of InfoTech Services Group, Inc., a computer consulting firm based in Venice Beach, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 28 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly InfoTechnology Partners) in 1990, its client base has expanded to include major corporations and government agencies such as Cisco, Shell Oil, Accenture, AIG Insurance, Northrop, the Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the United States Navy, University of Southern California, Massachusetts Institute of Technology, and others.

Alison specializes in teaching others how to develop Windows and Web applications. She is a leading author of 15 Microsoft Access books and SQL Server books, including Alison Balter's Mastering Access 2003 Development, Alison Balter's Mastering Access 2007 Development, Teach Yourself SQL Server 2005 Express in 24 Hours, Using Access 2010, and Access 2013 Absolute Beginners Guide. Alison is also featured in numerous training videos for both SAMS and Experts Exchange.

Most recently, Alison was given the honor of Microsoft Access MVP for the third year in a row, an honor bestowed on a select few individuals who have donated their time to bettering the development community. She was also selected as 2012/2013 Ventura County Woman Business Owner of the Year. Alison can be reached at alison@techismything.com.

Tuesday, September 2, 2014

Jim Pilcher

Let’s Fix Everything

Jim Pilcher

DAAUG President, Jim Pilcher, has a favorite saying: “Code fixes everything!” So, this month let’s get down and dirty with VBA and fix it all! Jim will demonstrate several VBA solutions for common problems and situations encountered by an Access developer. At the end of this presentation, you will never have Access problems again, because everything will be fixed!

Jim Pilcher, the current DAAUG President, is a prominent Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since its introduction in 1992. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local and state-wide enterprises, as well as large international companies. A frequent presenter at the Denver Area Access Users Group, Jim has served eight terms as its President, and five terms in other DAAUG capacities. Visit his web site at www.dataonedenver.com

Tuesday, August 5, 2014

Juan Soto

Wish you could live the glamorous consulting life?

Juan Soto

NOTE: Meeting location change. Due to construction at the Microsoft office, we will be meeting at the Rox Bar & Grill in Littleton at the intersection of C-470 and West Ken Caryl Avenue.

Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job).I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way.

In this session you will learn sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out. For a preview of this chat please visit Presentation Preview and click on the video halfway down the page.

Juan Soto is the President of IT Impact Inc. and a Microsoft Access MVP. He is also the co-founder of AccessUserGroups.org, an online virtual organization of Access User Groups worldwide. He specializes in Access with SQL Server databases and is a frequent blogger for Microsoft's official Access blog at http://blogs.office.com/?s=juan+soto and at SQL Saturday's across the US. Having the practice since 1994 has taught him to deal with a wide range of issues: managing growth, employees and clients. To learn more about Juan, please visit his blog at AccessExperts.com/blog.

Tuesday, July 1, 2014

"Lab at a Meeting"

NOTE: Meeting location change. Due to construction at the Microsoft office, we will be meeting at the Southglenn Library at Arapahoe and University. ("Granting of permission by the Arapahoe Library District to use library facilities does not constitute endorsement by the Library District Staff or Board of Trustees.") Map The library is located across from the parking garage next to the theater. Although we do plan to have pizza, you will need to bring your own drink.

Lab attendance has been down a bit lately so we're trying an experiment this month. We're having a "Lab at a Meeting" night. Except for our "normal formalities," the entire night will be devoted to helping each other. An advantage of having a lab at our regular meeting place will be our ability to put interesting problems on the "big screen" for the whole group to see.

So, as we say in our regular lab announcement:

Do you have a challenging Microsoft Access project that you could use some help with? Would you like to share your Access programming insights and suggestions with others who could use your help? Would you just like to spend an evening talking with other Access users and developers?

Well, if you answered yes to any one of these questions, come to DAAUG Lab Night.


Microsoft Access solutions are just waiting for you. Bring your laptop computer and/or your USB flash drive. There is certain to be a guru there that can help you solve your most difficult Access problem. Don’t hesitate and don’t be late! And, if you know everything there is to know about Microsoft Access and relational databases, please come and help out someone in need.

Tuesday, June 3, 2014

Armen Stein

Access Tips and Tricks

Armen Stein

Armen will present tips and tricks for making your Access applications more robust and easier for your users. Topics covered will include navigation techniques, database design ideas and UI improvements. Example code will be available to attendees.

Armen Stein is the founder and president of J Street Technology, a Microsoft Partner located near Seattle. J Street is a team of developers with expertise in custom Access desktop and ASP.NET web applications. Armen is a Microsoft Certified Professional and an Access MVP, and has spoken at many user groups and conferences, including Microsoft TechEd, Office DevCon in Australia, the PAUG Conference, and the UK Access User Group in London. He also organizes Access Day, a one-day conference devoted to Microsoft Access, and is co-author of Access 2007 VBA Programmer’s Reference (Wrox). His other interests include travel, photography, backgammon, movies, and driving his 1969 Ford Bronco in the sun.

Tuesday, May 6, 2014

Randy Guthrie, PhD, 
Microsoft Technology Evangelist

Making Great Windows Phone and Windows 8 Apps

Randy Guthrie, PhD, Microsoft Technology Evangelist

Successful mobile app development is becoming less about programming skill and more about good design and execution. Microsoft has recently released a browser-based mobile app development tool for Windows Phone and Windows 8. In this workshop Microsoft Technical Evangelist Randy Guthrie will show how quick and easy it is to get your first app into the marketplace, and along with it share the essentials of app marketing and key strategies for driving downloads.

Randy Guthrie is a Technical Evangelist for Microsoft Corporation. In this role, Randy provides academic and research support to faculty and students at schools in the western United State. Randy’s research interests include Human Computer Interaction (HCI) and Technology Pedagogy and his current technology passion is Windows 8 app development. Prior to his working at Microsoft, Randy was a professor at Cal Poly Pomona, where he taught software engineering, programming and information systems courses. During his tenure at Cal Poly, Randy was also the volunteer Director of a community employment center, which helps explain why he commonly can be found giving career workshops to tech students and IT professional groups. Before his appointment at Cal Poly, Randy spent thirteen years working for the Northrop Grumman Corporation, where he was a contract manager on the Stealth Bomber project, a project manager, and financial analyst. Randy earned his Bachelor’s Degree in Business from the University of La Verne in 1991, an MBA in 1998 from the Peter F. Drucker School of Management, and a PhD in Information Science in 2007 from the School of Information Science and Technology at Claremont Graduate University. Randy currently resides in Denver, Colorado with his wife Jane and daughter Molly, where he can be found training for sprint triathlons when it’s warm and skiing when it’s cold.

Tuesday, April 1, 2014

Rod Stephens

To Normalize, or Not to Normalize, That is the Question

Rod Stephens

In this talk, C# and Visual Basic author Rod Stephens discusses some database design issues. In the first half of the talk, Rod will review database normalization. He’ll describe the first, second, and third normal forms. He’ll explain how they help make a database powerful and flexible while preventing potentially disastrous problems. He’ll also explain situations where you may prefer to live on the edge and partly denormalize a database. If time permits (and anyone is still awake), he’ll briefly describe elusive higher degrees of normalization.

After a break for cookies and caffeine, the second part of the talk will begin with a brief summary of three general approaches to database design: existing data centered, UI centered, and database centered. He’ll then lead the group in an attempt to design a database from scratch.

Rod Stephens started out as a mathematician, but while studying at MIT, discovered how much fun programming is and has been programming professionally ever since. During his career, he has worked on an eclectic assortment of applications in such fields as telephone switching, billing, repair dispatching, tax processing, wastewater treatment, concert ticket sales, cartography, and training for professional football players.

Rod has been a Microsoft Visual Basic Most Valuable Professional (MVP) for more than 12 years and has taught introductory programming. He has written 28 books that have been translated into languages from all over the world, and more than 250 magazine articles mostly covering Visual Basic, C#, Visual Basic for Applications, Delphi, and Java.

Rod’s popular VB Helper web site (http://www.vb-helper.com) receives several million hits per month and contains thousands of pages of tips, tricks, and example programs for Visual Basic programmers, as well as example code for this book. His C# Helper web site (http://www.csharphelper.com) contains similar material for C# programmers.

You can contact Rod at Rod Stephens at C# Helper or Rod Stephens at VB Helper.

Tuesday, March 4, 2014

George Young

Access Web Apps - Just the Beginning

George Young

Access Web Apps present a challenge for many developers. How do they fit into the spectrum of business solutions? In this talk, DAAUG member George Young will review the critiques of Access Web Apps. He will demonstrate various ways to extend Access Web Apps well beyond SharePoint/Office 365, including a full Access 2013 Client application, an Excel Workbook, an ASP.NET MVC Web Application, and an ASP.NET Web API service driving a Windows 8 application.

George Young first encountered Microsoft Access when using the early versions of Office to teach Statistics and MIS in the early 1990’s. It’s been true love ever since! George has worked as a software developer for the past twenty years, including twelve at Microsoft (in just about every group other than Office). He is currently an independent consultant living at 6700 feet in Castle Rock, Colorado, working primarily on .NET applications. George still has a commercial site or two that is driven by an Access database sitting in the server file system.

Download the presentation materials

Tuesday, February 4, 2014

Meeting Canceled Due to Weather

A winter storm has caused us to reschedule this presentation to a future date.

Tuesday, January 7, 2014

Robert Miller

Full Microsoft Access Over the Internet

Robert Miller

Learn about the existing option of deploying the full richness of MS Access using your existing Desktop Application. This covers existing Microsoft technologies used by many companies today. Hear how this option can lower the Total Cost of Ownership for Access applications. It also streamlines MS Access desktop deployment and increases security.

The presentation will cover actual MS Access Developer’s history of deploying Access 97 through Access 2013 over Citrix. It includes the concept of split-databases with MS Access Databases and SQL Server Database. We will cover the lessons learned for successful deployment. Expect a top-level design concept geared for Access Programmers. There will be useful code tips and tricks that enhance the thin-client experience.

Robert Miller was one of the early MCSD, MCT, MCP in Office 95, 97, and 2000 with SQL Server and Citrix experience. As a MCP, one of his specialties was the Excel Object Model Programming. He traveled an average off 32 weeks per year around the country for six years. His consulting experience typically includes SQL Server, MS Access, Excel Objects, and Citrix (Cloud) applications used nationally. In his spare time, he authored a popular interactive Test Preparation for MS Access and the Windows Architecture I & II that was required for the Microsoft Certified Solution Developer. His latest project is developing a Rules Based Engine for Compliance Management in a SQL Server / Access national application that is rich in customized Excel reports.

Tuesday, December 3, 2013

Annual Holiday Party

No Main Presentation - It's the Annual Christmas Holiday Party! The majority of the meeting is for members and visitors to meet, eat well, relax, and chat.

Tuesday, November 5, 2013

Alison Balter

Developing Client/Server Apps with Microsoft Access

Alison Balter

Most people underestimate the power of Microsoft Access. If used properly, Access can be an excellent player in the enterprise world of client/server development. This talk will show you how you can develop robust, powerful client/server applications that take advantage of all that Microsoft Access has to offer.

During the talk we will begin by exploring when it is appropriate to move an Access application to a client/server environment. We will upsize an application to SQL Server and will talk about the gotchas involved in the upsizing process. Finally, you will learn how to build queries, forms, and reports that optimize performance in a client/server environment. Included in this portion of the talk is how and when to take advantage of SQL Server views, stored procedures, and functions. After attending this presentation those new to client/server development will be ready to take the plunge, and those experienced with client/server development will learn new techniques to incorporate into their toolboxes.

Alison Balter is the president of InfoTech Services Group, Inc., a computer consulting firm based in Newbury Park, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 27 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly InfoTechnology Partners) in 1990, its client base has expanded to include major corporations and government agencies such as Cisco, Shell Oil, Accenture, AIG Insurance, Northrop, the Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the United States Navy, University of Southern California, Massachusetts Institute of Technology, and others.

Alison specializes in teaching others how to develop Windows and Web applications. She is a leading author of 15 Microsoft Access books and SQL Server books, including Alison Balter’s Mastering Access 2003 Development, Alison Balter’s Mastering Access 2007 Development, Teach Yourself SQL Server 2005 Express in 24 Hours, Using Access 2010, and Access 2013 Absolute Beginners Guide. Alison is also featured in several training videos for both SAMS and Experts Exchange.

Most recently, Alison was given the honor of Microsoft Access MVP 2013, an honor bestowed on a select few individuals who have donated their time to bettering the development community. She was also selected as 2012/2013 Ventura County Woman Business Owner of the Year. Alison can be reached at alison@techismything.com.

Tuesday, October 1, 2013

Danny Lesandrini

Build Your Own Excel Import Wizard

Danny Lesandrini

Working with Excel spreadsheets is a natural evolution for any Microsoft Access solution. The Import Wizard that comes with Access works with simple files but if the spreadsheet is irregular in any way, you're going to need to use Automation. This demo will show you how to interrogate a spreadsheet to make importing the data simple. Also included is an explanation of how to build a table for your import using DDL SQL statements. When we're done, you'll have an Import Wizard on Steroids.

Danny Lesandrini, a former member of DAAUG and amateur astronomer is currently semi-retired and living the dream in Tucson Arizona. Prior to that, he designed Microsoft Access and SQL Server solutions in Denver for over 14 years. A dozen years of published articles is available at his website, http://www.lesandrini.com/datafast/articles.

Tuesday, September 3, 2013

Armen Stein

Managing Access Projects

Armen Stein

As an Access database developer, managing a project can be more difficult than coding it! Armen will present techniques and tools for estimating projects, managing the phases, and communicating with your clients. Example documents will be available to attendees.

Armen Stein is the founder and president of J Street Technology, a Microsoft Partner located near Seattle. J Street is a team of developers with expertise in custom Access desktop and ASP.NET web applications. Armen is a Microsoft Certified Professional and an Access MVP, and has spoken at many user groups and conferences, including Microsoft TechEd, Office DevCon in Australia, the PAUG Conference, and the UK Access User Group in London. Armen is co-author of Access 2007 VBA Programmer’s Reference (Wrox). His other interests include travel, photography, backgammon, movies, and driving his 1969 Ford Bronco in the sun.

Tuesday, August 6, 2013

Robert Miller

Excel Object Model Programming with Access VBA

Robert Miller

The Microsoft® Excel object model contains several dozen objects that you can manipulate through Microsoft® Visual Basic® for Applications (VBA) code from MS Access. Almost anything you can do with Excel from its user interface, you can do by manipulating its objects through VBA. In addition, you can do things through VBA that can't be done through the user interface. When using MS Access VBA to work with Excel objects, you have access to every part of Excel. This demonstration will work with objects that include cells, ranges, sheets, workbooks, charts, and more. In other words, every element in Excel can be represented by an object that you can manipulate through VBA.

More importantly, the SQL Statements used in MS Access can be directly used in Excel VBA code. This unleashes Excel to replace MS Access Reports and provide a new level of reports for Network, Web, and Citrix environments.

Lean the basics of programming custom Excel reports including custom formulas and formatting based on the record count. See how to automatically organize each report in custom user named folders under each report's name, with custom naming identifies. Automation and Work Flow Management are popular for high-profile, rapid decision making organizations.

Robert Miller was one of the early MCSD, MCT, MCP in Office 95, 97, and 2000 with SQL Server and Citrix experience. As a MCP, one of his specialties was the Excel Object Model Programming. He traveled an average off 32 weeks per year around the country for six years. His consulting experience typically includes SQL Server, MS Access, Excel Objects, and Citrix (Cloud) applications used nationally. In his spare time, he authored a popular interactive Test Preparation for MS Access and the Windows Architecture I & II that was required for the Microsoft Certified Solution Developer. His latest project is developing a Rules Based Engine for Compliance Management in a SQL Server / Access national application that is rich in customized Excel reports.

Tuesday, July 2, 2013

Kevin Bell

The Best of Both Worlds: Hybrid Apps with Access 2013

Kevin Bell

Access 2013 web applications allow you to quickly create a database in Office 365, but if you are familiar with traditional Access development, you may find some limitations. One of the best features in Access 2013 are databases created on Office 365 use SQL Azure. Unlike traditional SQL Server, SQL Azure is cloud based so your data can be accessible anywhere. However, every byte of data requested from the Access client is now traveling over the internet, so you need to be very diligent about returning the least amount of data possible. Kevin will show several techniques to help you covert your existing applications to an Access 2013 ‘hybrid’ app.

Kevin Bell is a test engineer on the Microsoft Access team in Redmond Washington. Prior to joining Microsoft in 2008, Kevin was a partner in a consulting practice in Colorado that specialized in building software solutions for small businesses and departments in large corporations, primarily working with Microsoft Access and SQL Server. Over a 15+ year consulting career he has created a variety of custom applications from a management system for a small drapery shop with a hand full of users to a compliance tracking system for a large insurance company with hundreds of users in multiple locations.

Over the years Kevin has been a member, officer and frequent presenter at the Denver Area Access User Group and now regularly presents at the Seattle Access User Group and the annual Portland Database Designers Conference. This November he had the pleasure of presenting at the 2012 UK Access Groups National Seminar in London.

After Meeting / After Party - From 9 PM until ???

Plan to stay late after the meeting. Kevin has promised to stick around for an after-meeting/after-party/meet-and-greet. We're just going to kick back, sit around, and have an informal chat until???

Tuesday, June 4, 2013

David Nealey

Effective Use of Multivalue Fields

David Nealey

David Nealey will describe ways to effectively use Access multivalue fields (MVF) in business applications. MVFs were added to ACCDB files in Access 2007. They are a quick and easy way to add multi-selections to questionnaires and other business applications. The method creates many-to-many relations using lookup tables embedded in master tables.

David will show how to store several professional certifications (e.g., PMP, LEED AP, CFP); technical terms; and, company names in MVFs. When the values are displayed in a form, they appear on different lines with Access-generated checkboxes. In a report, multiple values can be comma separated, semicolon separated, or displayed on separate lines. Developers can set various formatting properties to produce very attractive reports for users.

Many developers consider MVFs to break database design rules. With a clear understanding of MVFs, developers can use them effectively.

David Nealey is a retired geologist who has used versions of Access since Access 95. As a geologist he conducted extensive fieldwork and geochemical research on volcanic rocks in Arizona, Utah and Nevada. David also mapped rocks in Colorado using Geographic Information Systems, and he studied fossils and geologic features (e.g., sinkholes) in Florida. David has been a DAAUG member since 2000 and he has made presentations about several of his Access business applications.

Bonus: Report from the Portland Database Conference

DAAUG President Jim Pilcher, will offer a brief recap of the Portland Database Conference he attended during the first week of May. He will also share a few photographs from the experience. If anything interesting from Microsoft appears at the conference, you will hear all about it! Be prepared to ask questions! Jim, and member Ken Mulvihill also attending the Portland conference, will try to answer them the best that they can.

Jim Pilcher, the current DAAUG President, is a prominent Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since its introduction in 1992. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local and state-wide enterprises, as well as large international companies. A frequent presenter at the Denver Area Access Users Group, Jim has served eight terms as its President, and five terms in other DAAUG capacities. Visit his web site at www.dataonedenver.com.

Tuesday, May 7, 2013

Randy Guthrie, PhD, 
Microsoft Technology Evangelist

Windows 8 App Development: An Unprecedented Opportunity for All Developers

Randy Guthrie, PhD, Microsoft Technology Evangelist

In 2012, Microsoft shipped new versions of every major product line including Windows, Office, Windows Server, Visual Studio, and Xbox. Windows 8 in particular is a paradigm shift, and while many of the redesigned features will improve productivity over the long run, figuring them out on your own is difficult.

In this session, Randy Guthrie, Microsoft Technical Evangelist, will show some of the new features and “secrets” that will help you unlock the potential of Windows 8. Also, in this session, Randy will describe the unique opportunity that Windows 8 App development presents to developers of all types. He will walk through some simple templates that will help anyone get their first couple of apps into the store in just a few hours with virtually no programming.

Randy will wrap-up the presentation by discussing Office 365's place in the Office product offerings.

Randy Guthrie is a Technical Evangelist for Microsoft Corporation. In this role, Randy provides academic and research support to faculty and students at schools in the western United State. Randy’s research interests include Human Computer Interaction (HCI) and Technology Pedagogy and his current technology passion is Windows 8 app development. Prior to his working at Microsoft, Randy was a professor at Cal Poly Pomona, where he taught software engineering, programming and information systems courses. During his tenure at Cal Poly, Randy was also the volunteer Director of a community employment center, which helps explain why he commonly can be found giving career workshops to tech students and IT professional groups. Before his appointment at Cal Poly, Randy spent thirteen years working for the Northrop Grumman Corporation, where he was a contract manager on the Stealth Bomber project, a project manager, and financial analyst. Randy earned his Bachelor’s Degree in Business from the University of La Verne in 1991, an MBA in 1998 from the Peter F. Drucker School of Management, and a PhD in Information Science in 2007 from the School of Information Science and Technology at Claremont Graduate University. Randy currently resides in Denver, Colorado with his wife Jane and daughter Molly, where he can be found training for sprint triathlons when it’s warm and skiing when it’s cold.

Tuesday, April 2, 2013

Open Meeting

Jim Pilcher

An open meeting discussion lead by DAAUG President Jim Pilcher.

Tuesday, March 5, 2013

Rod Stephens

Design or Die! or Design in Haste, Repent at Leisure

Rod Stephens

In this talk, C# and Visual Basic author Rod Stephens discusses database design. Rod will begin by discussing semantic and entity-relationship object models that you can use to study the objects in an application and the relationships among those objects. He’ll then explain how you can convert those models into relational models and normalize the result to provide maximum flexibility while ensuring data integrity. The talk will finish with a description of several useful database design patterns and pitfalls, and a fairly complete example.

During the talk, Rod will tackle such controversial issues as hyper-normalization, the opposite issue of data de-normalization, and the fact that there’s no such thing as 2. Cookies will be served.

Specific topics will include:

  • Semantic data models
  • Entity-relationship (ER) models
  • Converting semantic and ER models into relational models
  • Implementing business rules
  • Normalization and de-normalization
  • Designing a database to support programming
  • Common database design patterns
  • Common database design pitfalls
Rod Stephens started out as a mathematician, but while studying at MIT, discovered how much fun programming is and has been programming professionally ever since. During his career, he has worked on an eclectic assortment of applications in such fields as telephone switching, billing, repair dispatching, tax processing, wastewater treatment, concert ticket sales, cartography, and training for professional football players.

Rod is a Microsoft Visual Basic Most Valuable Professional (MVP) and has taught introductory programming at ITT Technical Institute. He has written more than two dozen books that have been translated into languages from all over the world, and more than 250 magazine articles covering Visual Basic, C#, Visual Basic for Applications, Delphi, and Java.

Rod’s popular VB Helper web site (http://www.vb-helper.com) receives several million hits per month and contains thousands of pages of tips, tricks, and example programs for Visual Basic programmers, as well as example code for this book. His C# Helper web site (http://www.csharphelper.com) contains similar material for C# programmers.

You can contact Rod at Rod Stephens at C# Helper or Rod Stephens at VB Helper.

Tuesday, February 5, 2013

Jim Pilcher

Functional VBA

Jim Pilcher

In this session, Jim Pilcher will take you on a guided tour of some of the more interesting and esoteric functions built into the VBA language. Not only will his guidance make your VBA life easier and cleaner, but you will also learn about some important VBA functions that simplify Access query design. At the end of the presentation, there will be a prize for the first DAAUG member that can stump Jim with a VBA function that he does not know.

Jim Pilcher is a prominent Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since its introduction in 1992. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local and state-wide enterprises, as well as large international companies. A frequent presenter at the Denver Area Access Users Group, Jim served eight terms as its President, and five terms in other DAAUG capacities. Visit his web site at www.dataonedenver.com

Tuesday, January 8, 2013

Generating Paperless Legal Documentation from Access

Paul Schnitzler

This will be a real life example of a recently developed database that documents’ signing a wavier of responsibility form. See how you can go paperless by utilizing Access with a signature capture pad and a magnetic card reader. It not your typical database application but Access is a great cost effective tool to makes it happen.

Paul Schnitzler is a full time Access & SQL Server developer serving a wide variety of businesses. He has over 10 years of experience with Access and SQL Server. Visit his web site at www.gearitservices.com

Tuesday, December 4, 2012

Annual Holiday Party

No Main Presentation - It's the Annual Christmas Holiday Party! The majority of the meeting is for members and visitors to meet, eat well, relax, and chat.

Tuesday, November 6, 2012

Access 20th anniversary "World Tour”

Kevin Bell

Join us for this special evening to take a look back at the origins of Access, how it evolved and where it is going. We will start by looking back 20 years ago at the first release of Microsoft Access, and how it has evolved over the years into a robust client server front-end. Then we will explore the 11th release of Access, the new Access 2013. Access 2013 takes a dramatic new approach to creating databases application and we will explore its architecture and features. We will also discuss how your existing Access skills can be leveraged with Access 2013.

Kevin is a testing software engineer on the Microsoft Access team in Redmond Washington. Prior to joining Microsoft in 2008, he spent 15 years running a consulting practice that specialized in creating custom client server applications for small businesses. Kevin has been working with Microsoft Access since version 1.0 and SQL Server since version 4.21.

Tuesday, October 2, 2012

Ribbons Redux

Jim Pilcher

This month we take another look at the Microsoft Office Ribbon object model. Jim Pilcher will show you how to use the IDE Ribbon Creator as a creative tool, but will then venture into custom hand-written ribbons. Ribbons and VBA are tightly associated in Microsoft Access.Jim will show you some common techniques to get ribbons and VBA talking to each other. Jim will also provide an impressive and daunting list of web resources that can help you become the Office UI guru you always wanted to be.

Jim Pilcher is a prominent Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since its introduction in 1992. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local and state-wide enterprises, as well as large international companies. A frequent presenter at the Denver Area Access Users Group, Jim served eight terms as its President, and five terms in other DAAUG capacities. Visit his web site at www.dataonedenver.com

Tuesday, September 4, 2012

Show and Tell of 3 Real Life Databases

David Nealey, M. L. "Sco" Scofield and Paul Schnitzler

Presentation #1

David Nealey has been using MS Access as a business management tool since 2000. As a business consultant he has in-depth experience with the proposal development life cycle. David has used his business experience to build an Access 2007 application that features executive dashboards, text-to-speech, addresses-to-Bing maps, questionnaires, and checklists. The application generates numerous company-branded resumes and project descriptions based on the government's Standard Form 330 (SF330). The power of the application is enabled through linkages between modules (e.g., corporate, client, contracts, competitor, and industry). For example, a person's jobs can be linked to specific contracts (also called projects), and partners can be linked to specific contracts. The application currently contains almost 200 tables, about 200 forms, and a similar number of reports. The application supports each phase of proposal development: pre-proposal (capture), proposal development, proposal review, production, orals proposal, and post-proposal. The application ensures that users have access to high-quality and up-to-date information. The tool allows proposal managers to manage the proposal development process from start to finish using industry best practices.

Presentation #2

Brad Critchfield, President of KeepTraK Corporation, will be presenting his company’s facilities and equipment maintenance software, KeepTraK. Like so many programs, KeepTraK started life as an in-house application. It was originally written by Brad’s father, Jerry, when he worked at the Rocky Mountain Newspaper. Jerry originally wrote KeepTraK in Dartmouth Basic. Over the years it was converted to dBase and then Paradox. In 1997 KeepTraK was converted to Microsoft Access where it currently remains. Unlike so many programs that remain in-house applications for their entire lifetime, KeepTraK became a commercial program that has been sold for many years starting with its dBase version back in the 1980s. Brad will be assisted by long time DAAUG member Sco Scofield that has been helping Brad with several enhancements over the past year.

Presenter Brad Critchfield, President of KeepTraK Corporation, has been working with Access since 2002. He has worked on KeepTraK with his dad for many years. To learn more about KeepTraK, see their website at www.KeepTraK.com.

Co-presenter, M. L. "Sco" Scofield, is a Microsoft Access consultant and trainer in Denver, Colorado. You can see Sco's company profile on our DAAUG web site consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Presentation #3

Paul Schnitzler will show a recent application that he put together if time allows. The whole program was completed is less than 40 hours… simple but with some unique requirements for a Colorado mine. It replaced an out of control Excel work book the was used by 3 to 4 users and automated a graphical report that was being done manually

Paul Schnitzler if a full time Access & SQL Server developer serving a wide variety of business. He has over 13 year of experience with Access and SQL Server.

Tuesday, August 7, 2012

Patrick Saves The Day

Patrick Headley

Patrick stepped up and covered a last minute cancelation…. showing us an Access SQL server solution that he is working on.

Patrick Headley is a database application consultant developing applications in Microsoft Access, .Net, ColdFusion, PHP, SQL Server, PostgreSQL, and MySQL. He has been in the Microsoft Access development world since 1997 and has had his own company, Linx Consulting, Inc., since 2003. Patrick is also the current president of the Denver Area Access Users Group.

Tuesday, July 3, 2012

<font color="red">No Meeting due to the 4th of July</font>

Uncle Sam

With this being the evening before the 4th of July we expected a very low attendance. At the June meeting we discussed and decide to cancel this meeting. Have a happy 4th and we will see everyone at the August meeting.

Tuesday, June 5, 2012

Google Maps from Access

Paul Schnitzler

Due to a family emergency our original presenter had to cancel. Paul Schnitzler put together a last minute presentation on how to generate Google maps from Access. Several examples were presented from basic single address to an advanced process that he recently deployed that generates points and routes

Paul Schnitzler is a full time Access & SQL Server developer serving a wide variety of businesses. He has over 10 years of experience with Access and SQL Server. Paul is frequent presenter at the Denver Area Access Users Group and in his second term as DAAUG Vice President. Visit his web site at www.gearitservices.com

Tuesday, May 1, 2012

The SideMenu

Phillip Ferrero

Phil found a very neat menu system on www.utteraccess.com that he has deployed into an application. He will show you how you can integrate it into your own programs.

Phil Ferrero

IT professional with a public health, accounting, finance, operational, and managerial background. I design database applications for small to mid-size organizations that need a simple solution for integrating technology into their business processes.

~ Microsoft Access Database Design and Programming

~ Relational Database Design

~ VBA, DAO and ADO, MS Office integration

~ XML data manipulation and integration

~ 10 years of MS Access development experience and 15+ years of IT-related experience.

Tuesday, April 3, 2012

Access Excel Automation

Keith Poulin

Microsoft Excel spreadsheets are a common interface for importing/exporting data into/from Microsoft Access. This presentation will cover the basic Excel capabilities that Access provides out of the box, as well as more advanced techniques for importing flexible spreadsheet formats and producing richly formatted Excel reports.

Keith is a software engineering consultant and co-founder of LKA Micro Services, Inc. located in Northern Colorado. Keith specializes in data driven application design and development using various technologies including .Net, Java, Access, SQL Server and Oracle.

Tuesday, March 6, 2012

Form Events

Jim Pilcher

Last month you saw many of the new features of forms in Access 2010. In March, Jim Pilcher will take you under to hood of Access forms and discuss the power of event procedures. This will be a VBA-centric discussion about how to harness the ultimate power hidden within Access forms. Jim will lead you through the most common and most powerful event procedures along your path from power user to experienced Access developer. Don't miss this presentation!

Jim Pilcher is president of DataOne, Inc., serving database clients in the Colorado Front Range and across the United States since 1997. Jim also served as DAAUG president from 2000 through 2007 and continues to do regular presentations at the DAAUG monthly meetings.

Tuesday, February 7, 2012

Building Great Looking Forms with Access 2010

Paul Schnitzler

Take a look at forms that were developed with older versions of Access and then compare to ones that were built with 2007 or 2010. The newer forms generally have a cleaner more modern look. We will take an in depth look at several new features that were introduced in 2007 and 2010…. Using Themes, The New Image Gallery, Control Grouping / Table Layout, Anchoring and Alternate Row Colors. I will also show a recent 2010 application that I put together in 20 hours. It is amazing what you can you can do with the power of Access.

Paul Schnitzler is a full time Access & SQL Server developer serving a wide variety of businesses. He has over 10 years of experience with Access and SQL Server.

Tuesday, January 3, 2012

Access and Email: BFF’s (Best Buddies Forever)

Aaron Kogan

During this presentation we will explore several ways of integrating email into Microsoft Access. Included in this will be the new Access 2010 ‘Collect data by using e-mail messages’ feature (and one that Aaron custom built), Outlook integration, Gmail integration and how to send text messages (to a cell phone) from Access /email.

YOUR PARTICIPATION IS REQUESTED!: Please bring your laptop to the January meeting. Aaron will need people to send ‘reply responses’ during his presentation. You will be rewarded for you efforts.

Our presenter, Aaron Kogan, is the owner of SLM Data LLC. He has been developing databases for the National Park Service, The Nature Conservancy, The Maui Invasive Species Committee and many other companies since 2000. Aaron also dabbles in Geographical Information Systems (GIS) when he has a free moment. Aaron can be contacted at Aaron@SLMData.com or check out SLM Data LLC’s website at www.SLMData.com.

Tuesday, December 6, 2011

Annual <font color="red">Holiday Party</font>

Kris Kringle

No Main Presentation - It's the Annual Holiday Party!

The majority of the meeting is for members and visitors to meet, relax, and chat. Door prizes and an evening-long drawing highlight the gathering.

Tuesday, November 1, 2011

Microsoft Access Logging

Lindsay Wert

Discover an approach for consistently and easily logging run-time information from Access and VBA. We will discuss a flexible implementation for logging information from any MS Access application that is based on previous implementations used for other development environments, including .NET, C++, and Java.

Lindsay Wert is a consulting product development manager and engineer with extensive experience managing and participating in engineering development of multiple-technology electro-mechanical devices and software applications, including applications for small business based on MS Access and Java web platforms.

Tuesday, October 4, 2011

SharePoint 2010 + Access 2010 = Instant Web Database!

Paul Schnitzler

Microsoft has been working to integrate Access and SharePoint for several versions and it has blossomed with 2010. We will explore Web Database, Client Applications and Hybrid Applications. Discuss how to provide low cost hosting solutions for small business and leverage corporate IT commitment to SharePoint Enterprise. We will build a simple database… tables, forms and reports and then publish it to SharePoint. We will then look at some more involved examples to show how you can leverage this new technology.

Paul Schnitzler is a full time Access & SQL Server developer serving a wide variety of businesses. He has over 10 years of experience with Access and SQL Server.

Tuesday, September 6, 2011

Fun with Functions

Jim Pilcher

Come to the September DAAUG meeting and join Jim Pilcher as he shows you some common, obscure, and (of course!) useful VBA functions that you can employ in your Access queries, control properties, and VBA code. Jim will show you how knowledgeable and creative use of built-in VBA functions can save you time, coding, and aggravation.

Jim Pilcher is a prominent Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since its introduction in 1992. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local and state-wide enterprises, as well as international concerns. A frequent presenter at the Denver Area Access Users Group, Jim has served eight terms as President, and five terms in other DAAUG capacities. Visit his web site at www.dataonedenver.com

Tuesday, August 2, 2011

XML Interaction with Access - XML Data Manipulation Using The DOM

Phillip Ferrero

Topics covered:

~ What is XML?

~ XML interaction through Access menus (2007,2010)

~ DOM object

~ Using the DOM for XML /Access interactions – code examples of XML file confirmation, importing, exporting, creation, transformation, and web file downloads

~ Real-world examples of XML Access interactions

Phil Ferrero

IT professional with a public health, accounting, finance, operational, and managerial background. I design database applications for small to mid-size organizations that need a simple solution for integrating technology into their business processes.

~ Microsoft Access Database Design and Programming

~ Relational Database Design

~ VBA, DAO and ADO, MS Office integration

~ XML data manipulation and integration

~ 10 years of MS Access development experience and 15+ years of IT-related experience.

Tuesday, July 5, 2011

Importing Data From Excel, Make List Box and Combo Box controls work better and Visual Studio LightSwitch and Kexi

Patrick Headley

Importing Data From Excel

Have you ever tried to import data from Excel into Access and not all of your data was imported or you received type mismatch errors? With the procedures shown in this presentation you will be able to get your data into Access and take control of data inconsistency issues.

Make List Box and Combo Box controls work better.

In Microsoft Access, when you scroll down a List Box or the list of a Combo Box control that has many items in it, scrolling doesn’t work as expected until you reach the bottom of the list. In addition to that, when you requery the contents of a List Box control, say after returning from a detail form that may change the values displayed in the list, you loose your previous selection. This presentation uses a List Box control to show you how to make lists behave as you would expect, from the start.

Visual Studio LightSwitch and Kexi

There are some new kids on the block that compete with Microsoft access. Neither product completely clones the features and ease of use that Access offers but they are close enough that you should at least be aware of what they are. You will eventually have to face them. This will be a high-level overview of both products but you will be able to see what they are and decide how pertinent they are to the work you do. If there is enough interest in either product we could have a more detailed presentation in the future.

Patrick Headley is a database application consultant developing applications in Microsoft Access, .Net, ColdFusion, PHP, SQL Server, PostgreSQL, and MySQL. He has been in the Microsoft Access development world since 1997 and has had his own company, Linx Consulting, Inc., since 2003. Patrick is also the current president of the Denver Area Access Users Group.

Tuesday, June 7, 2011

Discover the new Navigation Control in Microsoft Access 2010

Jim Pilcher

Jim Pilcher will show you how to create a contemporary menu and forms navigation system using this exciting new feature in Access 2010. Jim will discuss the various properties of this control and how you might use it creatively in your own applications. Believe it or not, the Navigation Control is relatively easy to use and offers the opportunity for a shorter presentation, so there will be a question and answer session following, as time allows.

Jim Pilcher is a prominent Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since its introduction in 1992. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local and state-wide enterprises, as well as large international companies. A frequent presenter at the Denver Area Access Users Group, Jim served eight terms as its President, and five terms in other DAAUG capacities. Visit his web site at www.dataonedenver.com

Tuesday, May 3, 2011

Focus on Access 2010: Table Macros

Paul Schnitzler

Developers have screamed for this capability for several versions of Access. Find out how to use table macros to automate common database tasks at a table level. We will look at the before & after data macro events as well as named macros. Here are some of the examples that you will see… keeping track of who last updated a record, writing to a history table after a delete or change, maintain a de-normalized total on a parent table. Access 2010 has put a new face on the macro designer and added new functionality like parameter support, IntelliSense and copy and paste.

Paul Schnitzler is a full time Access & SQL Server developer serving a wide variety of businesses. He has over 10 years of experience with Access and SQL Server.

Tuesday, April 5, 2011

Special Presentation: Luke Chung of FMS, Inc.

Luke Chung

Luke Chung visits DAAUG again to discuss Microsoft Access in 2011

Tuesday, March 1, 2011

A Generic Lookup Table Editing Form

Jim Pilcher

Many attempts have been made over the years to provide a single form that allows the end user to manage all lookup tables in a database. Most attempts fall short of what a developer wants to provide a client. Jim Pilcher will show you such a form which reads table structures and configures itself to provide a more pleasant and professional experience for the client.

Tuesday, February 1, 2011

Access 2010 Web Apps 101

Paul Schnitzler

Access 2010 has given us a great new power to push our applications into a web browser. Is this round two for data access pages or a true game changer? In this meeting we will begin to explore the differences between Access 2010 web apps (via SharePoint 2010) and client apps. We will discuss… how the design interface changes, what environments are best for Access 2010 web apps, strategies for deployment and how to make your tables web compliant. Paul Schnitzler if a full time Access & SQL Server developer serving a wide variety of business. He has over 10 year of experience with Access and SQL Server.

Tuesday, January 4, 2011

Focus on Access 2010

Kevin Bell

Kevin Bell, former VP and DAAUG member, now working on the Access Development team for Microsoft, will visit Denver this month and discuss Access 2010 from a developer's point of view.

Tuesday, December 7, 2010

Toy Manufacturing and Inventory Control @ 90º N Latitude<br/><br/><font color="red">Holiday Party</font>

Kris Kringle

Find out how reindeer and senoir elves use Microsoft Access to track all aspects of toy manufacturing and inventory control at the North Pole.

Tuesday, November 2, 2010

The Many Faces of QBF - Part 2

M.L. "Sco" Scofield

Continuing his July presentation, Sco will demonstrate the technique of using a form to enter query criteria which is commonly know as "query by form" (QBF.) In its simplest form, QBF is an extension of using parameters in a query. In its more complex implementations, QBF can involve using a lot of code to construct an SQL statement out of thin air. QBFs can be used as sources of datasheets, forms, reports, and most anything else that a normal query can be used for.

The presentation will start out with a view of the material covered in the July 2010 presentation. In this presentation Sco will take a deeper look into the VBA code used in the examples.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access consultant and trainer in Denver, Colorado. He is an active member and past President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0 and has been in the beta programs for the last four versions. When not consulting and building applications using Access, Sco is also an instructor that trains all levels of Access from the introductory level all the way through advanced programming. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time that he spent helping Access users in the Access newsgroups on the Internet.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Tuesday, October 5, 2010

Let’s Build an Application from Scratch - Part 5

Jim Pilcher and Patrick Headley

Continuing an interactive discussion and design of a "Video Library" database from previous meetings . . . Join us to understand how to design an Access database. This month we will concentrate on forms and, time permitting, reports.

Tuesday, September 7, 2010

Real-Life Access

M.L. "Sco" Scofield

Come see a demonstration of a production application developed by member Sco Scofield. This application was developed for Special Products Co. in Golden, Colorado. The application creates and tracks serial numbers for products produced in their Golden, Colorado, plant. On the assembly floor, the application assigns a serial number, prints a unit label, and a shipping crate label. The application also tracks when a unit is loaded onto a truck for shipping and the order that the unit is assigned to.

Sco will also talk about the planning and development of the application along with problems encountered along the way.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access consultant and trainer in Denver, Colorado. He is an active member and past President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0 and has been in the beta programs for the last four versions. When not consulting and building applications using Access, Sco is also an instructor that trains all levels of Access from the introductory level all the way through advanced programming. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time that he spent helping Access users in the Access newsgroups on the Internet.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Tuesday, August 3, 2010

Draw Yourself a Report

Jim Pilcher

Learn to use the Microsoft Access report writer drawing tools at run time using VBA. Take complete control of boxes, circles, lines, ovals, text, fonts, colors and more. Jim Pilcher will give you a full demonstration of a real-life application that uses these little-noticed capabilities in Access reporting.

Jim Pilcher is the premier Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since since its introduction almost 20 years ago. He is an active member, past President, and current Vice President of your group. Jim’s company, DataOne, Inc., maintains a broad clientele base providing Access & SQL Server solutions for local enterprises and large international companies. See Jim's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.DataOneDenver.com.

Tuesday, July 6, 2010

The Many Faces of QBF - Part 1</br><font color="red" size="-2">Last-Minute Change</br>DAAUG apologizes for any inconvenience.</font>

M.L. "Sco" Scofield

The technique of using a form to enter query criteria is commonly know as "query by form" (QBF.) In it's simplest form, QBF is an extension of using parameters in a query. In it's more complex implementations, QBF can involve using a lot of code to construct an SQL statement out of thin air. QBFs can be used as sources of datasheets, forms, reports, and most anything else that a normal query can be used for.

The presentation will start out with a basic parameter query. Then a form will be "glued" to the query to turn it into a simple, no-code, QBF. The magic of connecting a query to a form without code will be explained. Next, the presentation will cover creating a more complex QBF using VBA code to create SQL on-the-fly. The problem of using quotes when producing SQL with VBA will be explained and several solutions will be shown. The presentation will wrap up by showing several different QBF implementations in some of the presenter's production applications.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access consultant and trainer in Denver, Colorado. He is an active member and past President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0 and has been in the beta programs for the last four versions. When not consulting and building applications using Access, Sco is also an instructor that trains all levels of Access from the introductory level all the way through advanced programming. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time that he spent helping Access users in the Access newsgroups on the Internet.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Tuesday, June 1, 2010

VBA Table Wrapper Classes

Lindsay Wert

Discover an approach for using VBA classes as wrappers to provide consistent, extendable, and repeatable table interfaces in Access and VBA. As a further demonstration of the power of VBA class modules, Lindsay will provide a demonstration of VBA extensions for table summary and related information.

Tuesday, May 4, 2010

How to Make New Buddies

Aaron Kogan

Aaron starts off with an appetizer: He will finish off his February presentation by showing how he creates multiple instances of a form using his Search Buddy as an example. For the main course, Aaron will talk about all the pieces that go into making a new Add-in. Then we will create a new Add-in from scratch. After all, who couldn’t use another buddy? If there is time for dessert, Aaron will share some extra tips, tricks & utilities he has discovered during his exploits in ‘Buddyville’.

Tuesday, April 6, 2010

Planning and Structuring Data

Crystal Long

Planning a database is often rushed in order to get the User Interface (UI) done faster. UI is the stick frame, paint, wallpaper, windows and skylights...what the homeowner sees in his new home. In database development, this is not where you start. The structure of a database is the foundation below that new home. It is what needs to be strong in order to support and enjoy everything else. This is the most important part of a database to get right. You are encouraged to bring your ideas for database applications so that we can discuss tables and relationships for different scenarios in Access and then contrast and compare them. What do they have in common? How do you approach design from a generic perspective and ensure that your application will be solid with flexibility for future growth? Bring your own laptop computer so you can look at and modify your own application and notes during the presentation.

Tuesday, March 2, 2010

Search Pane: Back from the Future

Aaron Kogan

Our presenter, Aaron Kogan, has grown fond of the searchable navigation pane (database window) in Access 2007. In his presentation this month he brings you this functionality in Access 2003 by way of an Access Add-In.

Tuesday, February 2, 2010

Nobody Told Me There Would Reports Like These!

Jim Pilcher

Your Client Wants What???

Perennial DAAUG presenter Jim Pilcher will show you how to dynamically vary the columns in a report at run time. You will work through an example of how the visibility, width, and position of various columns change from section to section based upon information in the source records.

Jim Pilcher is the premier Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since since its introduction almost 20 years ago. He is an active member, past President, and current Vice President of your group. Jim’s company, DataOne, Inc., maintains a broad clientele base providing Access & SQL Server solutions for local enterprises and large international companies. See Jim's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.DataOneDenver.com.

Tuesday, January 5, 2010

Tips and Tricks Inspired by Student Questions (rescheduled from August)<br/><br/><font color='red'><b>Annual DAAUG Board Elections</b></font>

M. L. "Sco" Scofield

Rescheduled from last August, M. L. "Sco" Scofield will be presenting a collection of small "demo" databases that he's used to answer questions and solve problems for his Access students. All of the bases will get covered from forms and reports to queries and even a macro. And of course there will be code. Because, as we all know; "Code fixes everything!" Always entertaining and informative, come join us this month for another one of Sco's excellent presentations.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and "Consiglierie" 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. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time that he spent helping Access users in the Access newsgroups on the Internet.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Tuesday, December 1, 2009

Let’s Build an Application from Scratch - Part 5<br/><br/><b><font color="red">Note December meeting and Holiday Party</font><br/><font color="red">(Tuesday after Thanksgiving)</font></b><br/>

Jim Pilcher and Patrick Headley

Back by popular demand!

This month, Jim Pilcher and Patrick Headley will continue with the development of the DAAUG DVD/Movie database. This month we will look at Access forms and subforms. Bring a USB flash drive if you want a copy of the database as it exists at the end of the presentation.

Our first co-presenter, Jim Pilcher, is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. He is an active member, past President, and current Vice President of your group. 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. See Jim's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.DataOneDenver.com.

Our second co-presenter, Patrick Headley, is a developer and consultant for several Microsoft products, including Microsoft Access. He is an active member and the current President of our group. See Patrick's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.LinxCo-Inc.

Tuesday, November 3, 2009

Access and a Paperless Office

Paul Schnitzler

How many files revolve around your Access applications? Example in Northwinds… is there a signed PO for each order? ...is there a filled out credit application for each customer? ... is there an email in Nancy Davolio’s Outlook that should be come part of the customer record? In this presentation you will see how to manage window files with your Access application and have them be click away. Go green…save a tree and recycle a file cabinet with your Access applications. Paul Schnitzler if a full time Access & SQL Server developer serving a wide variety of business. He has over 10 year of experience with Access and SQL Server.

Tuesday, October 6, 2009

Table Interface Classes and Automated VBA Code Generation

Lindsay Wert

Development of any non-trivial MS Access application can involve generation of a variety of VB code elements. Some of these elements may feel repetitive because the pattern is the same, but the details are different. In this discussion, we will explore an area where such repetition is advantageous, but repetitive nonetheless, namely VB classes to interface with Access tables. In addition, an add-in method for automatically generating the VB code for these classes will be discussed. The discussion will include:

Table interface classes, what they are, their purpose, and examples of their use

Automated VB code generation based on templates and table definition extracted using DAO, and implemented as an add-in.

Lindsay Wert is a consulting product development manager and engineer with extensive experience managing and participating in engineering development of multiple-technology electro-mechanical devices and software applications, including applications for small business based on MS Access and Java web platforms.

Tuesday, September 1, 2009

Ribbons without Bows - Access 2007

Chuck Robbins

Beginning Ribbons for MS Access 2007. We will develop an application that utilizes the new ribbon navigation and control functionality available in MS Access 2007. We will start out with the basics of XML used for the ribbon and progress into third party applications that manipulate the ribbon.

Tuesday, August 4, 2009

Advanced Query Use with VBA

Jim Pilcher

Jim Pilcher will show you how to integrate Access queries into your VBA with special attention paid to action parameter queries.

Tuesday, July 7, 2009

Create a Winning Application<br/><br/><b><font color="red">Note New Meeting Week and Night</font><br/><font color="red">(First Tuesday)</font></b><br/>

Patrick Headley

Patrick Headley has created a drawing application that we use at the DAAUG meetings. Patrick’s presentation will begin with an overview of the features of the application. He will then answer your most asked question; how does the application make random selections of prize winners. After that, Patrick will go into some of the more interesting programming details of the application, such as Relationships, form Open events, and error handling and logging. If time permits we will cover other parts of the application that you are interested in.

Tuesday, June 2, 2009

Everyday VBA for Really Smart People<br/><br/><b><font color="red">Note New Meeting Week and Night</font><br/><font color="red">(First Tuesday)</font></b><br/>

Jim Pilcher

Let your former DAAUG president, Jim Pilcher, show all of you really smart people some everyday solutions he’s crafted with VBA. Learn about compiler directives, conditional formatting controls with code, changing table structures with VBA/DAO, the difference between the various DAO recordset types, and oh so much more. As an added bonus, every member attending will be eligible for a copy of the presentation database with all of the code and examples discussed during the evening. Just bring your USB flash drive and Jim will burn you a copy to cherish and treasure. Don’t miss this opportunity to be a really smart person.

Our presenter, Jim Pilcher, is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. He is an active member and past President of our group. 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. See Jim's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.DataOneDenver.com.

Tuesday, May 5, 2009

Let’s Build an Application from Scratch - Part 4<br/><br/><b><font color="red">Note New Meeting Week and Night</font><br/><font color="red">(First Tuesday)</font></b><br/>

Jim Pilcher and Patrick Headley

This presentation has just been so darn popular that we're doing it again!

This month, Jim Pilcher and Patrick Headley will continue with the development of the DAAUG DVD/Movie database. Now that the table design is complete, we will look at setting a few validation rules and default values for various fields and discuss the relative merits of incorporating lookups directly into Access tables. Time-permitting, we will also begin looking at Access forms. Bring a USB flash drive if you want a copy of the database as it exists at the end of the presentation.

Our first co-presenter, Jim Pilcher, is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. He is an active member and past President of our group. 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. See Jim's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.DataOneDenver.com.

Our second co-presenter, Patrick Headley, is a developer and consultant for several Microsoft products, including Microsoft Access. He is an active member and the current President of our group. See Patrick's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.LinxCo-Inc.

Tuesday, April 7, 2009

Access Add-Ins and Code Snippets<br/><br/><b><font color="red">Note New Meeting Week and Night</font><br/><font color="red">(First Tuesday)</font></b><br/>

Aaron Kogan

This month, Aaron will describe more of the time-saving and dynamic code snippets that he has developed over the years. The "Little Buddies" from his code library are more than worth their weight in gold if you develop Access applications for your clients or for fun. Add-ins allow easy access to tools, created by you or someone else, in virtually all of your database projects. Aaron will be showing some Access add-ins that he has created. (And maybe a couple that he stole.) After his presentation, the Group will continue discussing the new features in Access 2007, if there is time. It seems that the more we use Access 2007, the more we find new and valuable features.

Aaron Kogan is the owner of SLM Data, LLC. He has been developing databases for the National Park Service, The Nature Conservancy, The Maui Invasive Species Committee and many other companies since 2000. Aaron also dabbles in Geographic Information Systems (GIS) when he has a free moment. Aaron can be contacted at Aaron@SLMData.com or check out SLM Data LLC’s website at www.SLMData.com.

Thursday, March 19, 2009

Advanced Features in Access 2007<br/><br/><font color="red">Meeting Night Change Next Month!<br/>Note the New Week and Night<br/>(First Tuesday)<br/>The April meeting will be on Tuesday, April 7th, 2009<br/></font>

Luke Chung, FMS, Inc.

The Denver Area Access Users Group is proud to present Luke Chung. Luke is President of FMS, Inc. He was recognized by the Microsoft Corporation as an Access Hero on the 10th anniversary of Access’ existence and is a popular speaker in the US and Europe. Luke will discuss advanced database features in Microsoft Access 2007. His presentation will concentrate on new and innovative features in Access 2007 that developers and users need in order to make the most effective use of the new data types and capabilities in Access 2007. He will discuss the features in Microsoft Access 2007 that should compel you and your users to migrate, Access products from FMS, and a variety of ways you can be more productive with Access. He’ll also answer any questions he can regarding Access, future trends, and how you can best handle these challenging times.

FMS has tens of thousands of customers in over 100 countries, including most major organizations. FMS also offers a custom database application development services though its Professional Solutions Group (http://www.fmsinc.com/Consulting/), and solutions for the intelligence, defense and law enforcement communities through its Advanced Systems Group (http://www.fmsasg.com).

Thursday, February 19, 2009

Let’s Build an Application from Scratch - Part 3

Jim Pilcher and Patrick Headley

Continuing an interactive discussion and design of a "Video Library" database from previous meetings . . . Join us to understand how to design an Access database.

Thursday, January 15, 2009

Deployment Strategies for an Access Application

Paul Schnitlzer

Paul will talk about the strategies of how to deploy and update Access applications in a network and distributed environment. He will show what Microsoft gives us, an overview of third party tools and scripts, and some home grown solutions. Paul will also talk about some specific challenges with deploying 2007 applications.

Our presenter, Paul Schnitzler, has been working with Access and SQL server for the last 8 years. Starting as a corporate developer in the construction field for 5 years. And as an independent developer for the last three years in construction, commercial real estate, non-profits, manufacturing, health care, trucking and variety of other fields.

Thursday, December 18, 2008

<font color='red'><b>No Meeting - Happy Holidays</b></font>

N/A

No Meeting - Happy Holidays



January Presentation
Paul Schnitzler
Deployment Strategies for an Access Application

Thursday, November 20, 2008

Annual Holiday Party

N/A

The Denver Area Access User Group hosts its annual Holiday party on Novenber 20th. 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.

Thursday, October 16, 2008

My Lil’ Buddies

Aaron Kogan

In March, Aaron showed us some of his Access Add-ins. Add-ins allow easy access to tools, created by you or someone else, in virtually all of your database projects. This month, Aaron will be showing some more of the Access add-ins that he has created.

Our presenter, Aaron Kogan, is the owner of SLM Data LLC. He has been developing databases for the National Park Service, The Nature Conservancy, The Maui Invasive Species Committee and many other companies since 2000. Aaron also dabbles in Geographical Information Systems (GIS) when he has a free moment. Aaron can be contacted at Aaron@SLMData.com or check out SLM Data LLC’s website at www.SLMData.com.

Thursday, September 18, 2008

What Would Like to See in a Future Version of Access?

Kevin Bell

Long-time member Kevin Bell is joining the Microsoft Access Development Team in Redmond this November and he has offered to listen to our opinions about where we think the future of Microsoft Access should take us. If you have an idea that would make Access easier for developers or users or if there is a great feature that you’ve seen in other products that is missing from Access, let Kevin know. While there is no guarantee of adding any idea or suggestion to Access, Kevin will take your feedback with him and do his best to get them implemented.

Our speaker, Kevin Bell, has been developing custom business solutions for over 15 years, since the days of Access on 1.0 and SQL Server 4.21. Over the years he and his partner Wendell, have deployed more than 100 production databases in Colorado and other cities around the world. Visit his web site at www.accessui.com to learn more.

Thursday, August 21, 2008

Rapid Prototyping with Access

Kevin Bell

Learn how to use Access to rapidly prototype applications that can save the world! OK maybe they won’t save the world, but they can impress your clients or boss. This month Kevin will show off a prototype he worked on for a local franchise with 70 locations across the US and soon Canada. By combining several different Access tools, creating a few custom forms, and focusing on the short comings of the current platform they created an impressive demo that went well beyond the traditional smoke and mirror presentation.

Our speaker, Kevin Bell, has been developing custom business solutions for over 15 years, since the days of Access on 1.0 and SQL Server 4.21. Over the years he and his partner Wendell, have deployed more than 100 production databases in Colorado and other cities around the world. Visit his web site at www.accessui.com to learn more.

Thursday, July 17, 2008

What is SQL Server and What is new in SQL 2008<br><font color="red">Rescheduled From April and May</font>

Kevin Cox, Microsoft<br/> Principle Program Manager <br/> SQL Server Product Group<br/> Customer Advisory Team<br/>

Kevin will give a brief overview of what comes in the package with SQL Server. Then he will dive into What’s new in SQL 2008.

Our presenter, Kevin Cox, Microsoft, has been working in the database field for over 30 years, of which the last 20 with SQL Server. He is currently a member of the Microsoft SQL Server product group in the Customer Advisory Team. In this job, Kevin feels very lucky to be able to work on the largest database projects in the world.

Thursday, June 19, 2008

Collaborative Application Design with Quiz Professor

Louie Walker Jr.

See a demonstration of the various techniques used in creating an automatic-grading educational application. Some of the topics discussed will be: How to use unbound forms, and how to process data imported from other applications, and how to create and export objects into VBA created databases.

Our presenter, Louie Walker, Jr., is an Accounting Professor Specializing in teaching Accounting Information Systems. Currently developing an Access 2007 automatic grading application to be used by college/University Professors. Louie Walker, Jr. was founder, President and CEO of TriSys Software Solutions, Inc. He has over 25 years of business and IT industry experience. He has a BA, from Colorado State University and a MBA in information systems from Regis University. He was a two-time president of the Denver Area Access Users Group. He has been using and developing with MS Access since version 1.0 and developing with SQL Server since version 7.0.

Thursday, May 15, 2008

The Story of the Ribbon

Jensen Harris, Principal Group Program Manager Office User Experience Team, Microsoft Redmond

Due to an unexpected, last minute trip to Redmond, our presenter, Kevin Cox, will be unable to provide our presentation this month. He hopes to be able to reschedule later this year.

Have you ever wondered how the Office Fluent interface can into being? Jensen Harris, Principal Group Program Manager Office User Experience Team, made a presentation at Microsoft's MIX08 conference this year titled "The Story of the Ribbon." He talked about the general design process they used to come up with the Office 2007 user interface, to iterate on it, and to evaluate it. As part of the discussion, he showed for the first time some of the early prototypes they worked on (and abandoned or refined) along the way.

We will be playing the video of Jensen's presentation this month.

Thursday, April 17, 2008

Access 2007 and SharePoint, the Beginning of a Beautiful Friendship

Cliff Burton

No member of the traditional Microsoft Office suite of products has been affected more by SharePoint integration capabilities than Access 2007. Developers have a whole new set of tools at their disposal to share, collect, or store Access data on corporate SharePoint web sites. New SharePoint integration abilities make an entirely new type of solution possible where Access 2007 serves as a desktop client for information and workflows stored on a SharePoint server. These Access/SharePoint solutions will be easy to build, offer a wide range of desktop and browser functionality and provide powerful off-line capabilities. The presentation will include:

   ♦ An Overview of Access 2007 and Windows SharePoint Services 3.0 (WSS 3.0) Integration capabilities
   ♦ An Access 2007 / WSS 3.0 Application Demo
   ♦ A Summary of Lessons Learned while building Access/SharePoint Applications

Our presenter, Cliff Burton, has enjoyed a career spanning twenty years of Information Technology experience as a developer and consultant. He has been an architect for SharePoint solutions and implementations since 2004, but his current focus is on providing business process automation solutions based on the Microsoft Office 2007 and SharePoint platform. He has created a company, BPFast LLC, dedicated to rapidly delivering cost effective custom business solutions with Office 2007 and SharePoint and is actively involved in providing services, managing, and developing people for BPFast LLC. His web site is www.BPFast.com.

Thursday, March 20, 2008

Add-ins and Your Mama<br/> Another Real World Application<br/>

Aaron Kogan<br/> M. L. “Sco” Scofield<br/>

This month we will be having two main presentations.

Presentation One
Title: Add-ins and Your Mama
Presenter: Aaron Kogan

If “necessity is the mother of invention,” then Microsoft Access add-ins should be getting a Mother’s Day card this year. Add-ins allow easy access to tools, created by you or someone else, in virtually all of your database projects. Aaron will be showing some Access add-ins that he created. (And maybe a couple that he stole.)

Our first presenter, Aaron Kogan, is the owner of SLM Data LLC. He has been developing databases for the National Park Service, The Nature Conservancy, The Maui Invasive Species Committee and many other companies since 2000. Aaron also dabbles in Geographical Information Systems (GIS) when he has a free moment. Aaron can be contacted at Aaron@SLMData.com or check out SLM Data LLC’s website at www.SLMData.com.

Presentation Two
Title: Another Real World Application
Presenter: M. L. “Sco” Scofield

Because the group likes seeing other member’s applications, Sco will be demonstrating another one of his production Access applications. After an introduction to the application and a walkthrough of how it works, Sco will show some of the not-so-everyday code used in this application.

Our second presenter, M. L. “Sco” Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and past 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. He is a “Microsoft Certified Solution Developer,” a “Microsoft Certified Professional,” and is A+ certified. Sco was awarded the prestigious “Microsoft MVP” award from 10/1/2001 through 10/31/2005 in recognition of the time that he has spent helping Access users in the Access newsgroups on the Internet. See Sco’s company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com. Contact Sco at Sco@ScoBiz.com.

Thursday, February 21, 2008

Simple Approaches to Building Dashboards into Your Applications

David Nealey

Access allows developers to create dashboards that give database users greater insight into their data. Functionality built into Access allows developers to create the same look and feel that they get using expensive third-party programs. This presentation will describe how a customized Access application was built using colored text boxes and a set of gauges to help students prepare for a national test.

Our presenter, David Nealey, owns WordSmart Business Services, a local small business. He has developed Access applications for proposal development, project management, membership management, software requirements analysis, and test preparation. David also serves as Vice President of Marketing for a GIS consulting company in Parker where uses his applications to pursue new business and efficiently perform projects.

Thursday, January 17, 2008

Office Automation In Microsoft Access

Phil Ferrero

Consider a few good things with Access to Word (mail merge), Excel (data presentation), and Outlook (calendar reminders, email, adding an Excel file). I could even get into the discussion late/early binding, and how to version proof your Automation.

Thursday, December 20, 2007

No Meeting - Happy Holidays

N/A

No Meeting - Happy Holidays

Thursday, November 15, 2007

Annual Holiday Party<BR/>Let’s Build an Application from Scratch - Part 1

Jim Pilcher

It's the Annual Holiday Party!
"Let’s Build an Application from Scratch"


It’s often said that the most common type of Access database is the one you inherit. This month we will do the uncommon thing and assemble a new database from scratch during the DAAUG meeting. Discover some of the reasoning that goes into table, menu, and form design when handling a totally new application. Your Lab Director, Jim Pilcher, will guide the audience through this participative exercise. The resulting application will be available to those who bring a USB flash drive with them on this evening.

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.

Thursday, October 18, 2007

Sco's Application Demo - Part 2

M. L. "Sco" Scofield

"Sco's Application Demo - Part 2"

In August, "Sco's Grab-bag of Miscellaneous Stuff" turned out to be a demonstration and code walkthrough of an application that he is working on for the United States Geographical Survey. After a brief demonstration of how the system worked, he went on a code walkthrough of the main part of the application, a rather involved query-by-form. Time ran out before he was able to go through the code for outputting the data to Word, Excel, and a text file. After a quick straw poll, it was evident that the people in attendance wanted to see the rest of the code. Sco committed to do another presentation and here it is! Always entertaining and informative, come join us this month for another one of Sco's excellent presentations.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and the current 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. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time that he spent helping Access users in the Access newsgroups on the Internet. See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Thursday, September 20, 2007

Be the Master of Your Controls

Danny Lesandrini

"Be the Master of Controls"

After the tables are set, it's all about controls. Labels, text boxes, subforms and a cornicopia of others are at your disposal. Danny Lesandrini will show you how to bring them to heel using VBA code. Some of the techniques covered include:

  • Change the font, backcolor and style of a text box
  • Show and hide controls dynamically
  • Load label captions based on table-driven values
  • Resize subforms when parent form resizes

Virtually all control properties (with a few exceptions) can be set from your VBA code. See how to make your forms more flexible and extensible. Pick up tips on constructing a more user-friendly interface. Learn how to become the Master of Your Controls.

Our presenter, Danny J. Lesandrini, a Microsoft Certified Professional in Access, Visual Basic and SQL Server, has been programming with Microsoft development tools since 1995. He maintains a web site with free code samples at http://amazecreations.com/datafast and replies to all questions and comments sent to datafast@comcast.net.

Thursday, August 16, 2007

Sco's Grab-bag of Miscellaneous Stuff

M. L. "Sco" Scofield

No telling what we are likely to see this month. As you know, Sco always has something interesting to show us. And there is surely bound to be some VBA code thrown in somewhere.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and the current 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. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time that he spent helping Access users in the Access newsgroups on the Internet.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Thursday, July 19, 2007

Access Data Projects for Fun and Profit

Danny J. Lesandrini

Access Data Projects (ADPs) are more than just a mysterious file option in the Microsoft Access menu. Sometimes maligned, often misunderstood, ADPs provide a powerful alternative for creating a secure user interface to SQL Server data.

In addition to the basics, creating ADPs & connecting to data, you will see how easy it is to programmatically load data in forms and controls using ADO recordsets from SQL Server tables, views and even stored procedures. He'll even demonstrate how to completely obfuscate the data entirely from the user, drawing from multiple SQL Server databases at once.

Our presenter, Danny J. Lesandrini, a Microsoft Certified Professional in Access, Visual Basic and SQL Server, has been programming with Microsoft development tools since 1995. He maintains a web site with free code samples at http://amazecreations.com/datafast and replies to all questions and comments sent to datafast@comcast.net.

Thursday, June 21, 2007

Using Classes in Microsoft Access

Chris Nebinger

The professional development world is moving more and more toward object classes. It is only a matter of time before Access fully embraces object oriented design.

Classes are one of the most overlooked features of Microsoft Access. Many developers understand the syntax of the classes, but not how and when to use them in their applications. Chris will present 4 four situations ideally suited for using classes. Also, he will present some advanced class techniques.

Our presenter, Chris Nebinger, recently started CTN Technologies, Inc., a consulting company focused on Microsoft technologies, including .NET, SQL Server, and Access. He has developed applications for companies such as: Ball Aerospace, Coors, Conoco, BP, USAF, & Georgia Pacific.

Thursday, May 17, 2007

Crosstab Queries

M. L. "Sco" Scofield

See how to build, use, and modify this versatile "data analysis" query.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and the current 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. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time that he spent helping Access users in the Access newsgroups on the Internet.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Thursday, April 19, 2007

SQL Server Express and Access

Kevin Bell

Although Access can provide a very robust database, there are times when it just doesn’t have enough scalability or security for an application and alternatives need to be explored. In the past SQL Server was a viable solution, but it comes at an expense. Now there is a free version SQL Server 2005 called Express that is a free option that does not have the limitations that the previous free versions of SQL Server had. I this month’s main presentation we will learn about some of the advantages and pitfalls of upgrading your database from Access to SQL Server Express.

Kevin has been developing custom business solutions with Access since version 1.0 and SQL Server since version 4.21. Over the years he and his partner Wendell, have deployed more than 100 production databases in Colorado and other cities around the world. Visit their web site at www.access-experts.com for an Access tip of the day.

Thursday, March 15, 2007

Exploring the Treeview and Listview Controls

Chris Nebinger

Learn how to utilize TreeView and ListView controls, and how to implement them as an alternative to standard menu driven applications.

Chris has been developing with Access since version 95. He has developed applications for companies such as: Ball Aerospace, Coors, Conoco, BP, USAF, & Georgia Pacific. Currently he has been devoting more time towards .NET Development, but still does quite a bit in Access and continually defends Access as a development tool in newsgroups.

Thursday, February 15, 2007

Access 2007 - The Good, The Bad and the Ugly

Group Panel

In keeping with the sprit of the local Office 2007 launch (which is being held the same day as out February meeting), we well be holding a round table discussion on what good, bad and just plan ugly in the newest version of Access. Bring your questions and opinions about the new version of Access. We will also be discussing what topic members want to hear about and how much focus we should give Access 2007.

If you haven’t already signed up to attend the local launch, it looks to be too late, both events are ‘sold out’.

Thursday, January 18, 2007

Re-Scheduled Annual Holiday Party<BR/>(No main presentation this month)

N/A

Since Mother Nature didn’t corporate for our annual Holiday Party in December, the Denver Area Access User Group will host its annual Holiday party on January 18th. This is the annual "let your hair down" user group meeting. Holiday refreshments and goodie give-a-ways rule the evening.

Although we will not be having a full length main presentation, we will be having our annual elections and maybe a short 30 minute topic.

The majority of the meeting is for members and visitors to meet, relax, and chat. Door prizes and an evening-long drawing highlight the gathering.

Thursday, December 21, 2006

Annual Holiday Party <font color=red><b>- Party Cancelled!!! Due to the Snow Storm!</b></font><BR/>(No main presentation this month)

N/A

No Main Presentation - It's the Annual Holiday Party! - Party Cancelled!!! Postponed until January of 2007

The Denver Area Access User Group hosts its annual Holiday party on December 21st. This is the annual "let your hair down" user group meeting. Holiday refreshments and goodie give-aways rule the evening.

Although we will not be having a full length main presentation, sometime around 7:30 we will be having one of our expanded Thirty (Sixty???) Minute Topics.

The majority of the meeting is for members and visitors to meet, relax, and chat. Door prizes and an evening-long drawing highlight the gathering.

Thursday, November 16, 2006

'Word Automation from Access" and "A Variable Declaration Review and Class Module Properties"<br/><p align="center"><font color=red><b>First Meeting at the NEW Denver Microsoft Office </b></font><p/>

Alan Ruff and M. L. "Sco" Scofield

"Word Automation from Access" by Alan Ruff

How to build Word template forms, automate customer statements, and avoid Word automation pitfalls

Alan Ruff is a Microsoft Access Developer and IT Administrator Consultant in the Denver area. He has worked with Microsoft Access since the early 1990's and has an emphasis in Accounting. He currently has his own consulting business named "Ruff Group" which serves Denver area clients.

"A Variable Declaration Review and Class Module Properties" by M. L. "Sco" Scofield

During the July 2006 Report Tip presentation it became clear that the group needed a refresher on variable declaration, variable scope, and how to create class module properties. Do you know that Public doesn't always mean global? Do you know that you don't always need Property Let and Property Get to create class properties? This is a "back-to-the-basics" presentation of information that every VBA programmer needs to understand cold.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and the current 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. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time that he spent helping Access users in the Access newsgroups on the Internet.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Thursday, October 19, 2006

<font color=red><b>Meeting Moved to 10/12/2006 Becasue of the Denver Microsoft Office Moving</b></font>

N/A

This meeting is one week early due to the Microsoft office moving later this month
See the October 12th listing
The November meeting will be on our regular night at the new office

Thursday, October 12, 2006

Normal Forms<br/><font color=red><b>One Week Early Because of the Denver Microsoft Office Moving</b></font>

Jim Pilcher

Everything you ever wanted to know about database normalization and referential integrity.

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.

See Jim’s company profile on our DAAUG web site in the Consultant list and on his web site at www.DataOneDenver.com .

Thursday, September 21, 2006

Ribbon Extensibility in Microsoft Office Access 2007

Michael McCormack<br/>Microsoft Access Program Manager<br/>Redmond, WA

Say goodbye to CommandBars, and say hello to the Ribbon! The Ribbon is at the core of the new user experience in Microsoft Office 2007. The Ribbon provides an innovative way to display and organize commands that improve usability and user productivity. In this session you'll discover how the Ribbon exposes a rich and flexible XML-based extensibility model in Microsoft Office Access 2007. You'll explore the new programming model, learn best practices, and see how to incorporate the Ribbon design philosophy into your applications. You'll look at backward compatibility for custom CommandBars in Access 2007.

Our presenter, Michael McCormack, is a program manager at Microsoft Corporation working on the Microsoft Access development team. His team is currently working to enhance the overall usability in Access, with a personal focus on navigation, command structure (especially the ribbon) and the shell. Michael has worked at Microsoft since 2000, and prior to working as a program manager, Michael served as a software test engineer, and as a lab manager overseeing a large network. Previous projects include Microsoft Office Excel 2003.

Michael holds a Master's of Science in Information Management from the University of Washington. Prior to working at Microsoft, Michael was a Microsoft Partner designing and developing Access Databases, and Visual Basic - SQL Server client server applications as a consultant and developer.

Thursday, August 17, 2006

Database Show ‘N Tell

DAAUG Members

Remember how fun Show ‘N Tell was in kindergarten? Well this month you can re-live a bit of your youth. Come to the Denver Area Access Users Group database Show ‘N Tell! We will have short presentations by three members who have volunteered to show off a few cool features in an Access database that they have created.

Duane Hanstein of Dynamic Association Mapping, (DAM) will demonstrate using Access to update a Geographic Information System GIS.

Jim August of CORE, Inc. will talk about his company's reliability database application.

Bruce Handley of Handley Computer Corp. will demonstrate some features of one of his company's products called ClientMinder.

Thursday, July 20, 2006

Overview of Microsoft Office Access 2007 from a Developer Perspective

Michael McCormack<br/>Microsoft Access Program Manager<br/>Redmond, WA

This month we have something different and unexpected for the presentation. We were able to get one of the Access Product Managers from Microsoft Redmond to talk to us this month, via Live Meeting about Access 2007. Jim Pilcher's presentation, "Normal Forms," will be rescheduled to August or September depending on Jim's schedule.

Access 2007 provides developers with the ability to build much richer databases much more quickly. This session discusses new functionality for building client databases, and covers Access's new designers, new coding tools, the ability to create custom task panes, collecting data through email, and customizing the ribbon UI. In addition, we show the out-of-the-box "tracking applications" that will ship with Access 2007, and show some of the tools used to build those apps and that will ship in the Access Developer Extensions.

Our presenter, Michael McCormack, is a program manager at Microsoft Corporation working on the Microsoft Access development team. His team is currently working to enhance the overall usability in Access, with a personal focus on navigation, command structure (especially the ribbon) and the shell. Michael has worked at Microsoft since 2000, and prior to working as a program manager, Michael served as a software test engineer, and as a lab manager overseeing a large network. Previous projects include Microsoft Office Excel 2003. Michael holds a Master's of Science in Information Management from the University of Washington. Prior to working at Microsoft, Michael was a Microsoft Partner designing and developing Access Databases, and Visual Basic - SQL Server client server applications as a consultant and developer.

This presentation will be a little different this month. Michael will be giving his presentation via Live Meeting from Microsoft in Redmond, Washington.

Thursday, June 15, 2006

The Secrets of Security

Wendell Bell

If you are building Access applications for anyone other than yourself, you really need to restrict users from things that can break the application, or even destroy it. This presentation will look at a number of features in Access that provide security, and also explore securing your back-end.

After spending 27 years in the telecommunications industry, Wendell Bell began a consulting practice based on Microsoft products in 1991. With the release of Access, he began focusing primarily on database applications, and currently supports several clients in the Denver area, as well as applications deployed in Washington State, Texas and Nebraska. He also serves as a moderator of the WOPR Lounge Access forum.

Thursday, May 18, 2006

You don't need to be a web guru to use a Web Service

Danny J. Lesandrini

It's not like we live on an island. In fact, even those who live on islands aren't limited to the island anymore. Access developers may now leverage all the power of the Internet from the comfort and convenience of their familiar VBA code modules. Learn how to use Microsoft Access with the Web Services Toolkit to do things like; validate email an address, retrieve stock quotes or display a random Hungarian proverb.

Danny J. Lesandrini, although having programmed in FORTRAN with a keypunch machine and punch cards over20 years ago, became bored and strayed from the path of technology. Then in the mid 90's, prompted by a friend to return to the field of programming, he dove head-first into Microsoft Access. Today, Danny is a Microsoft Certified Professional in Access, Visual Basic and SQL Server, has been programming with Microsoft development tools since 1995. He maintains a web site with free code samples at http://amazecreations.com/datafast and replies to all questions and comments sent to datafast@comcast.net.

Thursday, April 20, 2006

Hitting for the Cycle with Outlook and Access

Mike Nindorf

This month’s presentation will demonstrate an application that uses Outlook, Access, Word and Adobe (writer) to create a Bankruptcy (PDF) Invoice. This process reads and modifies Outlook forms while storing the information in an Access database. The process will then pull correct bill information from an Oracle database, calculate the percentage used for the bankruptcy invoice, do the calculations and finally create the appropriate Word and PDF files. A form will then display for the Analyst to verify/change the results and give the option to send the required PDF file back to the requestor.

Our presenter, Mike Nindorf, is currently employed at Sprint and has been automating business processes since 1985- yes, that is pre Windows. Programming knowledge base include VBA, Holos, Excel and SQL. An expert in data-mining and with innovative way of solving business problems, his most recent accomplishments include automating an automated tool that will unzip, balance and burn to CD "electronic bills" for over 2,000 customers per month.

Thursday, March 16, 2006

Sco's Miscellaneous Code Samples - Part 3

M. L. "Sco" Scofield

The last time that Sco showed some of his code snippets was December, 2004. This has always been a popular topic. As in the past, audience interest will dictate the direction of the presentation.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and 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 10/1/2001 through 10/31/2005 in recognition of the time he spends helping Access users.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Thursday, February 16, 2006

"The Access Sub-way"<br/>Rescheduled (and Expanded) from November

Jim Pilcher

Rescheduled (and Expanded) from November 2005

"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 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 .

Thursday, January 19, 2006

"So You Want to Be An Access Consultant?"

Group Panel

This is a panel discussion and question and answer session designed to let you get some insight into the dynamic world of Microsoft Access consulting.

Thursday, December 15, 2005

Annual Holiday Party<BR/>(No presentations this month)

N/A

No Presentations - It's the Annual Holiday Party!

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.

Thursday, November 17, 2005

"The Access Sub-way" and "DAO Transactions"

Jim Pilcher and M. L. "Sco" Scofield

Something Different - Two Medium Length Presentations

"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 .

"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.

Thursday, October 20, 2005

"Practical Ways to Use XML with Access 2003"

Tim Getsch<br/>Microsoft Access Program Manager<br/>Redmond, WA

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.

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.

Thursday, September 15, 2005

"The Creation of a One Form Application"

M. L. "Sco" Scofield

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.

Thursday, August 18, 2005

"Free Your Programming from the Ties That Bind"

Jim Pilcher

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.

Thursday, July 21, 2005

“My First Access Database - Believe it or not!”

David Nealey

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.

Thursday, June 16, 2005

"Using Access Data with Office Smart Documents"

J. Mel Harris

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.

Thursday, May 19, 2005

"Connecting Access to your Windows SharePoint Services Data"

Viki Selca<br/>Microsoft Access Program Manager<br/>Redmond, WA

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.

This presentation will be a little different this month. Viki will be giving her presentation via Live Meeting from Microsoft in Redmond, Washington.

Thursday, April 21, 2005

"The Split Database"

M. L. "Sco" Scofield

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.

Thursday, March 17, 2005

"Optional Access"

Jim Pilcher

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 .

Thursday, February 17, 2005

"It's a Date" and "The Data Veg-A-Matic"

Jim Pilcher and M. L. "Sco" Scofield

Something Different - Two Medium Length Presentations

"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.

Thursday, January 20, 2005

"An Introduction to Class Modules"

M. L. "Sco" Scofield

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.

Annual Officer Elections

January is when we hold our annual officer elections. All members are encouraged to attend this meeting so that you can express your choices for the leadership of our group.

Thursday, December 16, 2004

Annual Holiday Party<BR/>(No main presentation this month)

N/A

No Main Presentation - It's the Annual Holiday Party!

The Denver Area Access User Group hosts its annual Holiday party on December 18th. This is the annual "let your hair down" user group meeting. Holiday refreshments and goodie give-aways rule the evening.

Although we will not be having a full length main presentation, sometime around 7:30 we will be having one of our expanded Thirty (Sixty???) Minute Topics.

The majority of the meeting is for members and visitors to meet, relax, and chat. Door prizes and an evening-long drawing highlight the gathering.

Thursday, November 18, 2004

"Bulletproofing an Application"

Kevin Bell

bul·let·proof adj.
1. Impenetrable by bullets
2. Informal. Impervious to assault, damage, or failure; guaranteed

As Access Applications mature, they tend to get more complex, are used by more people and often become a critical tool for a businesses success. While performance issues are usually easy to spot, bulletproofing an application is an exercise in predicting what can go wrong, and reacting to it before it happens. In addition to protecting your users from a bad computing experience, you also need to be concerned with protecting your application’s data and intellectual property from prying eyes. While even the most robust database application is no match for Dirty Harry, there are several tricks that can help make your Access application more stable and secure. In this presentation we will explore several different strategies for making your application more robust and maybe even bulletproof.

Kevin has been developing custom business solutions with Access since version 1.0 and SQL Server since version 4.21. Over the years he and his partner Wendell, have deployed more than 100 production databases in Colorado and other cities around the world. Visit their web site at www.access-experts.com for an Access tip of the day.

Thursday, October 21, 2004

"Maximizing Access Performance"

Wendell Bell

Small Access databases don't usually have performance issues - but small databases have a habit of growing up to become big databases with slow response times, and then you as the developer are faced with fixing it. In this presentation, Wendell Bell will explore the kinds of performance bottlenecks you are likely to encounter, and various methods of improving the situation. Topics to be covered include the judicious use of indexes, dealing with LAN performance issues, masking performance issues with the user interface, when to consider upsizing to SQL Server, and performance issues with WAN or web interfaces.

Wendell has been an active user of Microsoft products since 1986, began his consulting practice in 1990 after spending 27 years with AT&T and Bell Labs, and since 1994, has been specializing in using Access as a front-end to SQL Server. He and his partner Kevin have deployed more than 100 production databases in Colorado and other cities around the world. In addition, Wendell serves as a moderator for the Access forum on the peer-to-peer help site known as Woody's Lounge - it can be found at www.wopr.com/lounge - and you can read more about his background and avocations at www.access-experts.com.

Thursday, September 16, 2004

Access Totals Queries

M. L. "Sco" Scofield

Thursday, August 19, 2004

Database Design a Rational Approach

J. Mel Harris

Thursday, July 15, 2004

10th Anniversary Meeting and Celebration: New features in Access 2003, the Microsoft development process and how features make it in to Access, and the future of Access

Jon Sigler, Access Group Program Manager, Microsoft

Thursday, June 17, 2004

Importing Complex XML into Access; Publishing Data with the Web Matrix Tool; Sco's Miscellaneous Stuff

Danny Lesandrini; Kevin Bell; M. L. "Sco" Scofield

Thursday, May 20, 2004

Access Query Joins

M. L. "Sco" Scofield

Thursday, April 15, 2004

Advanced Report Design

Jim Pilcher

Thursday, March 18, 2004

Automating Excel with Access

Danny J. Lesandrini

Thursday, February 19, 2004

Access Form Events

Jim Pilcher

Thursday, January 15, 2004

"Access Parameter Queries andQuery by Form

M. L. "Sco" Scofield

Thursday, December 18, 2003

Annual Holiday Party

No main presentation this month

Thursday, November 20, 2003

Error Handling in VBA

Jim Pilcher

Thursday, October 16, 2003

Extending Access with ActiveX Controls

Kevin Bell

Thursday, September 18, 2003

DAO - Still the Best with Access Jet Databases

Jim Pilcher

Thursday, August 21, 2003

XML for the Access User/Developer

J. Mel Harris

Thursday, July 17, 2003

Access Totals Queries

M. L. "Sco" Scofield