Opening Wizards

[Qury]

I am creating a database for my office. All of my tables are in place,
relationships are created, and all sorts of queries and reports can be
created. To me, everything is functional. From reading this forum, I have
decided to use forms instead of the switchboard for my opening screen. I have
command buttons that open the separate forms as well. I borrowed a few books
from the library to help.

What I would like to do is create buttons that will open the table wizard,
query wizard, form wizard, and report wizard so that when others use it,
these functions can be accessed easily. Also, it would be great to have
buttons created for any new form or report created, but I may be asking for
too much there. If I can get the query wizard and report wizard to open from
buttons on a form, that would be perfect.

Thanks and have a great day.

 

[Chris O'C via AccessMonster.com]

Your ideas may be too ambitious. The users qualified to create new forms,
queries, etc., in your db are developers, and they're already familiar with
these buttons in the db window or can select them on the insert menu.
They'll expect to use those instead of your custom buttons.

The users who aren't familiar with these built in features aren't experienced
with Access. Those aren't the people you want creating new objects in your
db, because they'll do crazy things like jeopardize data integrity. They'll
drive you nuts.

Chris
Microsoft MVP

 

[Qury]

That makes complete sense. And I can appreciate the idea of keeping hands out
of where they should be. Although, my job is to create then teach others how
to use it. I figured having at least the query wizard and report wizard
available in the opening forms as buttons would keep those hands out of the
main db window. Also, having those reports show up as buttons on the form
automatically would be icing on the cake, so to speak.

But, is what I want possible? I am using Access 2003 (which I forgot to
state in my first post).

Qury