how to run a SQL select statement and display in a new datasheet

J

Jerry Qu

Hi All,

how can I run a SQL select statement using VBA and display the result to a
new datasheet just like
Docmd.opentable and docmd.openQuery doing. the docmd.runsql only works for
action statement.

Please help

TIA

Jerry
 
A

Allen Browne

Could you create a query for this purpose, and then:
strSql = "SELECT ...
CurrentDb().QueryDefs("Query1").SQL = strSql
DoCmd.OpenQuery "Query1"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to open a Select query using SQL string? 2
How to display zero value in blank fields of Cross Tab query 0
VBA code returns no records hwenKey ID is added 14
SQL Statement 4
trouble with QBF and multiple choices 0
changing the syntax of an SQL Select statement to appease VBA 4
Build SQL statement 2
PLEASE HELP: Reload a subform with updated columns 1

Top