Startup Help

[Naka]

hey guys. i have a switchboard that appears automatically in my database via the startup options from tools in the menu bar. ive seen that if you have something startup, then exit it, another form will appear. how can i do this? my switchboards name is just switchboard and the form i want to appear after closing the switch board is titled "Orders". thanks

 

[CEH]

Sounds like you created a blank switchboard.... go to.........Tools...Database Utilities...Switchboard Manager.........
Then Edit..... New.... Edit Switchboard Items... Follow the prompts to set up which items you want to open on each button.

 

[Naka]

oh no, i have a switchboard that i want to use w/ all the buttons and all. what i want is another form to show up, after openning the database. because once a user is done with or is not using the switchboard, the next thing they should be using is the "orders" form which i want to appear after exiting the switchboard

 

[statsman]

A rather unusual method of going about it.

The switchboard is designed to stay active so that when you have finished whatever function you have selected on the switchboard, the switchboard will return and you can go to another function.

In your case, the order form should be one of the selections on the switchboard. You would have to click the order form on the switchboard to open it.

This is the way switchboards are designed to work.

If you wish to just open the orders form on startup, create a macro called "Autoexec". In the macro select:
Open Form - Order Form.

Autoexec macro will be the first thing the database does when it is opened.

 

[boblarson]

If you wish to just open the orders form on startup, create a macro called "Autoexec". In the macro select:
Open Form - Order Form.

Autoexec macro will be the first thing the database does when it is opened.

Even easier, if you have Access 2000, or above, is to just go to Tools > Startup and select the opening form in the dropdown. No macro necessary. From there you can also uncheck the Show Database Window checkbox to be able to hide the database window on open.

 

[Naka]

thanks guys, yeah i just made a form that acts like a switchboard w/ a command button that opens my forms

 

[Yecats131]

Even easier, if you have Access 2000, or above, is to just go to Tools > Startup and select the opening form in the dropdown. No macro necessary. From there you can also uncheck the Show Database Window checkbox to be able to hide the database window on open.

Where can I find this in Access 2007? I'm just not seeing it :/

 

[pbaldy]

Microsoft Office Button |Access Options | Current Database

 

[Yecats131]

Oh.. I see it thanks! :0) One more question.... is it possible to disable the ribbon?

Thanks!