Easy yes or no question

wjmjr

New member
Local time
Today, 11:44
Joined
Jul 14, 2005
Messages
7
Is there a way to run the query wizard from a command button located on a switchboard?

Thanks -WM
 
If you are thinking of having the users create their own queries - not a good idea.

Col
 
Thanks for the reply...
I need to give one user - the manager - the ability to create queries and reports on the fly. Any suggestions on how to do this without giving him access to the database window?

-WM
 
I would strongly advise against giving a user access to write his own queries, unless he is fully competant in SQL....


If you give him access to write queries then I see no reason why he shouldn't have access to the database window, surely you will be giving him access to delete every bit of data from your database (by giving him query access) then what does it matter if he has access to the database window.

Why not give him a copy of the database locally then he can do what he wants with the data without risking data integrety on your live system
 
Or you could download all the data he needs into Excel and let him use pivot tables to do what he wants.

Or get him to tell you what reports he wants and you create them and let him add his own criteria via a form.

Col
 

Users who are viewing this thread

Back
Top Bottom