Hello,

Is it possible to have a button on the switchboard that allows you to create a report/query/form directly?
Also, can I open the database window from the switch?

I thought it would involve macros...

Thanks

Hi
Welcome to Utter Access Forums

The creating of reports/queries/forms have to be done in design view then "saved" the button on you switchboard can then "Run" any of those objects.
Not sure what you mean about the db window..?

Thanks for replying so quickly Larry.

I am glad reports etc have to be created in design view and then run by the switchboard - I can stop pulling my hair out about it now!

By db window I meant the control window?? I have attached an image to this posting (i hope!) showing the window I am trying to describe - not very successfully. If the db is on a setting that hides this window when the db is opened, can the user then open it via the switch somehow (if they do not know about F11)?

Hi
Have a look in Tools>StartUp and there are a number off option that you can adjust to suit your needs.
HTH's

To create a new Form from a button use this line of code:

DoCmd.RunCommand acCmdNewObjectForm

a report would be :

DoCmd.RunCommand acCmdNewObjectReport

a query would be :

DoCmd.RunCommand acCmdNewObjectQuery

This is not the best idea for your users to have this ability as they could very easily corrupt your database.

Thanks guys,

I will have a play with it!

Your welcome.