Query Wizard

[jamies]

Hi all,
I have an access form which i have turned of menus, navigation and shift key. What I am looking for is to have buttons on my form to allow users to create and delete queries from my form. I already have a listbox that shows all the queries and runs them when a user double click on them.
The codes needs to run in access 2007-2013 in both 32 & 64 bit versions.

Thanks
Jamie

 

[pr2-eugin]

Hello Jamie, Welcome to AWF..

Deleting Queries is not a reversible process... If you have some idea of what you entirely mean by..

allow users to create and delete queries from my form.

Giving users the authority over Creating and Deleting queries might not be the best option.. I might be wrong, as I am unaware of what you exactly are after.. But if you could explain in a bit detail we might be able to help you out..

 

[jamies]

Hi there,
Sorry for the delay in getting back to you.

It will be ok for some of the users to add/edit & delete queries and reports, they just like the wizards to help the do so.
I have at the moment to created forms with options for them to query the tables and display in a datalist below and generate the report, however this might not meet all their requirements so they will need to create their own ones occasionally.

Plus if i dont use it on this project it would be worth knowing how to do

Thanks
Jamie

 

[Pat Hartman]

Allowing users to make object changes in a shared database prevents you from easily publishing new versions. Either the user looses all the changes he made or you have to get the changes from EVERY user and somehow incorporate them into your new version.

If the users need to create their own queries, etc, give them an empty FE with links to the BE and let them use that.