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.
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.
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.
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.
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’.
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.
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.
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.
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.
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.
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.
Find out how reindeer and senoir elves use Microsoft Access to track all aspects of toy manufacturing and inventory control at the North Pole.