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.