Denver Area Access Users Group

General Meeting Presentation

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.