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.
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'.
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.
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.
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.
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.
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.
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.
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:
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.
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.
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.