convert queries to code

[SusanV]

I have a couple dozen queries that I would like to put into modules as
functions or subs so that they are inaccessible by my users. I know how to
do this manually via SQL view and copy/paste of course, but I was wondering
if there was any automation engine like Tools/Macro/Convert Macros to VB.

Not a big deal, mostly curious but it would certainly save me a lot of time
if there is...


TIA,

Susan

 

[John Vinson]

I have a couple dozen queries that I would like to put into modules as
functions or subs so that they are inaccessible by my users. I know how to
do this manually via SQL view and copy/paste of course, but I was wondering
if there was any automation engine like Tools/Macro/Convert Macros to VB.

Not a big deal, mostly curious but it would certainly save me a lot of time
if there is...

Not that I'm aware of; since of course a Query is not valid VBA code,
there's no "translation" involved.

If I wanted to hide queries I'd be inclined instead to use Access
security and just deny the user Show Design view.

John W. Vinson[MVP]

 

[SusanV]

That's kind of what I figured, but management says no passwording the
database, so I'll just do them manually. Not difficult, just time consuming.

Thanks John,

Susan