How to convert a query into vba code?

[Pepocles]

Hi!

I want to convert al my queries into vba code... Is this possible? Is a
program or routine out there that could possibly help me? Is there a
tutorial?

Thank you.

 

[solex]

Don't do it, stored queries are generally much faster then dynamic sql.

 

[RK]

Simple,
go to design view, then go to code view, run Compile.

works great.

RK