Denver Area Access Users Group

General Meeting Presentation

Thursday, November 16, 2006

Word Automation from Access and A Variable Declaration Review and Class Module Properties"

Alan Ruff and M. L. "Sco" Scofield

First Meeting at the NEW Denver Microsoft Office!

"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 and on his web site at