putting query in vba

[papa jonah]

Is there a way to put a query, either in SQL or some other format, into
a vba event so that I can add some "if...then" statements?
If so, what sort of syntax do I need to surround it with?

 

[Denis Dougall]

I am not sure I understood your question exactly but have a look at this
link and perhaps it will help.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office10052000.asp

Cheers,

Denis

 

[papa jonah]

My question is this.
Can I take a sql query statement and insert it into code? I know that
on any sort of event such as "on focus" or "on click" I can run a
query. I want to have code run a query within certain parameters as
determined by if...then statements.

Does that make more sense?