tags:

views:

601

answers:

1

Hi I need to create a query in MSAccess 2003 through code (a.k.a. VB) -- how can I accomplish this?

+3  A: 

A vague answer for a vague question :)

strSQL="SELECT * FROM tblT WHERE ID =" & Forms!Form1!txtID 

Set qdf=CurrentDB.CreateQueryDef("NewQuery",strSQL)
DoCmd.OpenQuery qdf.Name
Remou
Ugh I've been trying things similar to this for the past 3 hours :( Thanks a bunch
Andrew G. Johnson