How to programmatically switch query to design mode
Posted on 2008-10-01
I have an Access databas that does not allow objects like forms and tables to be modified in design mode. I just added the default Access buttons to allow users to create custom data queries. If a new query is created and run, but not yet saved, Access recognizes it as "query1" and that is fine.
The problem is once the query is run and you are looking at the data, one might decide to modify the query further, but I can find no way to get back to design mode without adding the default Access design mode button. The problem with that is that it would then allow users to switch forms, reports, tables, etc in the database to design mode!
I need a way to only switch the query to design mode!