Action Queries in Code.mdb
by Roger Carlson
There are a variety of circumstances under which you might want to run a query in VBA code. You may want to just display the results of a Select query to the screen at the push of a button. You may want to run an Action Query in a code module as part of another process.
This sample illustrates how to suppress confirmation messages when running an Action query in VBA code, and is a perfect companion to the Action Queries Series.
Full documentation included.
You can find the sample here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=402.