Creating a form in Wizard Mode through button on existing form

[marting]

If i have a form open and wish to enable users to create their own forms, tables, queries or reports in wizard or design mode by clicking on the relevant button how is this done.

Is there a code i can use. I am using MS Access 2002.

The users wont have access to back end of database so need to give them these option from the views they have. The only way i can think to do this is to code buttons which would allow these actions to happen.

Can anyone help please?

Marting

 

[boblarson]

So, the users won't have access to the backend? Any particular reason? I can think of several reasons why what you are asking to be able to do will make things very bad, very quickly.

1. If users start making their own tables, queries, or forms then if you are all using one database file it will get ugly very quickly.

2. Nobody will follow any kind of standard and you will wind up with the potential for corruption if someone happens to throw some rogue code in.

3. If you are limiting the access to the backend due to data concerns, letting users create their own stuff will let them see and access all of the existing data.

4. Design changes cannot be saved when the database has more than one user in the database at a time. So, how would they save their changes?

5. If they each have a copy of the front-end on their own computer and can modify it at will, how can you make design changes and incorporate them into their database if they are making changes - nobody's front-end will be the same. Updating it will become a major nightmare.


To sum up, I think you are heading down the path of heart attack city. You'd better rethink this strategy.

 

[marting]

Some Clarification

Thanks Bob for the advice and of course you are right in what you say but perhaps to give you some more info might help you see where i am coming from as perhaps i did not explain it fully in my original posing.

I have created a database which will be used by one office and two people, the administrator and the admin person. The admin person will be simply entering data and the administrator while not professionally trained in access has a very good knowledge and understanding.

Basically this functionality would enable him to create queries if needed along the way and forms based on those queries and then reports if needed. Due to the compelity of the organisation it is difficut to try and forsee all future report req and so this is why i wished to have this functionality available to him to create them as he went along.

I dont really see him creating tables and so this element would perhaps not be needed initially anyway but cretainly the ability to create new queries and reports or and forms based on same.

Any ideas or help? All advise is much appreciated