Dynamic creation of MS Access query

[alvisdouglas]

I have been able to create an Access database, its tables and those tables fields using TADOXCatalog component. I now need to create an Access query dynamically. Any ideas?

Thanks in advance.

Alvis

[nico5038]

Just "string" it together form the known elements like:

strSQL = "SELECT " & Me.field1 & " from tblX where ID = " & me.ID

Nic;o)

[NeoPa]

I have been able to create an Access database, its tables and those tables fields using TADOXCatalog component. I now need to create an Access query dynamically. Any ideas?

Thanks in advance.

Alvis

Do you need to create a QueryDef (a saved query object) or do you simply need to know how to put a 'query' (a set of SQL statements) together and run it?
SQL is relatively straightforward (as indicated by Nico's post) and is just about formulating an ASCII string. To run an action query, just use DoCmd.RunSQL.
Let us know if this answers your question or if it is actually more complicated than it looks. If more's required we can provide it ;)