Microsoft Office Tutorials and References
In Depth Information
Run the Query
Press the Run Query button to retrieve the information from the database and display it in
the current worksheet (see Figure 24-8).
Figure 24-8. View the results from the database query as a normal worksheet.
In this chapter, you learned how to combine database programming with user forms and
command bars to create a useful application that runs in Excel. The program began by load
ing a command bar containing the controls that operate the application. Pressing the Database
button displays a form where the user can enter the information necessary to connect to the
database. Pressing the Edit Query button displays another user form that displays the current
database query and allows the user to change it. Finally, pressing the Run Query button runs
the query using calls to ADO and displays the results in the currently active worksheet.