CheckBox Selecting Excel Coulumns [ URGENT HELP]!

[laserized]

Hi to all,
I ve created a from, where user can enter search criterias in the
textboxes, when Ok button Clicked I ve DoCmd.OpenForm code that opens a
new form where 16 Checkboxes there. What I want to do is that, Among
the users selected CheckBoxes Excel Report Will be generated.

In the first form Ive lots of if statements that generates the SQL code
and I want to send the SQL code to a query and by that query I'll
generate the Excel with OutputTo property in VB.
In this part actually question turns to How to Send VB generated SQL
code to the Query?

Hope I'm clear
Any helps will be alot appriciated.
Thanx
metan

 

[Arvin Meyer [MVP]]

How about something like:

Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim strSQL As String

Set db = CurrentDb

strSQL = "SELECT * FROM MyTable "

Set qdf = db.CreateQueryDef("MyQuery")
qdf.SQL = strSQL
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[laserized]

Thanx its just working perfect.

Appriciated.