Oct 4 2004, 01:05 AM
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...
Oct 4 2004, 01:12 AM
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..?
Oct 4 2004, 01:34 AM
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)?
Oct 4 2004, 03:00 AM
Have a look in Tools>StartUp and there are a number off option that you can adjust to suit your needs.
Oct 4 2004, 09:20 AM
To create a new Form from a button use this line of code:
a report would be :
a query would be :
This is not the best idea for your users to have this ability as they could very easily corrupt your database.
Oct 4 2004, 05:10 PM
I will have a play with it!
Oct 4 2004, 10:28 PM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here