General Meeting Presentations

2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003

Past Presentations - 2010

Tuesday, January 5, 2010

Tips and Tricks Inspired by Student Questions

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, February 2, 2010

Nobody Told Me There Would Be 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, 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, 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, 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, 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, July 6, 2010

The Many Faces of QBF - Part 1

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, 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, 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, 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, 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, December 7, 2010

Toy Manufacturing and Inventory Control @ 90º N Latitude -- Holiday Party

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.