RWOP Queries and User Queries

[robert demo via AccessMonster.com]

My app has custom menu bars, does not display the database window and uses
RWOP queries.

Users are clamoring for the ability to create ad-hoc queries. I have an idea
of how I want to do this, but have the following question.

How can I display queries that users create and save without also displaying
my RWOP queries. I don't need to show the database window, but I would need
to provide at least a listbox with any existing user-created queries so that
they can be selected and run. Again, I don't want to show the RWOP queries.

Also, I only want users to have the ability to create Select (no Delete or
Update) queries. I believe I can accomplish this from the custom menu by
only allowing Queries to be created (as opposed to other objects) and it
looks like Access defaults to only Select queries in that case. All other
menu items abd subitems that would allow Delete or Update Queries, or the
creation of other objects such as form, tables, etc. would not be included in
the custom menu.

Thanks for any response.l

 

[Duane Hookom]

There is a query by form (ad-hoc queries) "applet" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You can
import several tables, forms, etc into an existing application and provide
your users with a custom reporting tool. Results are a click away from
sending to other apps such as Excel.

 

[robert d via AccessMonster.com]

How does an applet work with Access. Is this essentially an executable file.
If so, my client won't allow any executable files to be installed without
approval from IT (which typically takes 2 years even for Windows XP). That's
why I'm developing in Access. They don't view an Access file in the same way.

 

[Duane Hookom]

Did you download and look at the "applet"? It is just a group of standard
Access tables, forms, etc that can be imported into your application. There
is no exe. Just read the information on the web and try it.

 

[robert demo via AccessMonster.com]

Thank you for the advice. However, I would still like an answer to my
original question if possible.

Thanks.

Did you download and look at the "applet"? It is just a group of standard
Access tables, forms, etc that can be imported into your application. There
is no exe. Just read the information on the web and try it.

How does an applet work with Access. Is this essentially an executable
file.

[quoted text clipped - 31 lines]

 

[Duane Hookom]

Sorry, I am only providing a solution that I believe should work and provide
additional functionality.

If you are looking for an answer to your specific question, I don't have it
and don't intend to take the time to research it.

--
Duane Hookom
MS Access MVP

Thank you for the advice. However, I would still like an answer to my
original question if possible.

Thanks.

Did you download and look at the "applet"? It is just a group of standard
Access tables, forms, etc that can be imported into your application.
There
is no exe. Just read the information on the web and try it.

How does an applet work with Access. Is this essentially an executable
file.

[quoted text clipped - 31 lines]

Thanks for any response.l

 

[Tim Ferguson]

Users are clamoring for the ability to create ad-hoc queries. I have
an idea of how I want to do this, but have the following question.

1) Use Microsoft Query: this is free with all Office installations
(although not installed by default) and give a completely
graphically-driven query designer.

2) Use another mdb. There is no reason why you have to use a single
front end for each database. Provide forms for creating queries there,
and don't let the users anywhere near your own ones.

Also, I only want users to have the ability to create Select (no
Delete or Update) queries.

Use user-level security and remove permissions for update and delete from
the base tables. I guess you have already done this if you are using
owner-access queries.

Hope that helps


Tim F

 

[robert demo via AccessMonster.com]

Tim:

Thanks for the response. I was planning to use another mdb for the ad-hoc
querying. But the problem is that the users need to be able to see any
queries that they have created. I want to display user-created queries, but
not the RWOP queries, that I've created to access my tables.

Do you know how I can display only user queries in a listbox or something
like that. What if I just hide the Queries and not provide the Access menu
option to view hidden objects. I'll have to look into that.

 

[Tim Ferguson]

Do you know how I can display only user queries in a listbox or
something like that. What if I just hide the Queries and not provide
the Access menu option to view hidden objects. I'll have to look into
that.

If you have a naming system, you can do something like

for each qdf in QueryDefs
if left$(qdf.Name, 3)="_am" then
ListOfQueries.AddItem qdf.Name

etc

Alternatively, you could look at the DoCmd.SetHiddenAttribute method --
I'm not completely sure I've spelled that right -- to hide them from the
user.

All the best


Tim F