RWOP Queries and User Queries

  • Thread starter Thread starter robert demo via AccessMonster.com
  • Start date Start date
R

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
 
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.
 
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.
 
Thank you for the advice. However, I would still like an answer to my
original question if possible.

Thanks.

Duane said:
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.
Click to expand...
[quoted text clipped - 31 lines]
Click to expand...
 
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


robert demo via AccessMonster.com said:
Thank you for the advice. However, I would still like an answer to my
original question if possible.

Thanks.

Duane said:
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.
Click to expand...
[quoted text clipped - 31 lines]
Thanks for any response.l
Click to expand...
Click to expand...
Click to expand...
 
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.
Click to expand...

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.
Click to expand...

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
 
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.
 
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.
Click to expand...

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
 
Back
Top