running queries

[slimjen1]

All, using access 2010. I was recently asked to lockdown one of the users database outside my dept. I split the database, created an accde and put a copy on all user desktop. I put the backend on a shared server. Now I find the users are used to running queries using the F11 function. I proceeded to give them a form and command button to just run them whenever they wanted but found there are about 20 queries! Is there a quicker design; maybe a dropdown of a list of queries they can select to run. I just don't remember doing this kind of thing. Most of users have one or two queries or reports but this many. ugh. Any suggestions are helpful. Thanking you in advance.

 

[Minty]

Have a look at the attached - it uses a list box that lists all queries with a certain prefix. It's not complete but will hopefully give you the idea.

 

[arnelgp]

select [Name] from MSysObjects Where Type = 5 And Instr([Name],"~") = 0

 

[slimjen1]

thanks all. I'll try this