Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Autoloading a switchboard

Aug 2, 2005 6:41AM PDT

I am running Access 2000 with all the latest updated and I want to know if it is possible to have a switchboard automatically load when a database is opened. I tried following the instructions found here:
http://www.techonthenet.com/access/switchboard/maximize.php
but I do not have the onload option it is talking about. Any thoughts? Any help would be appreciated. Thanks

Discussion is locked

- Collapse -
Re: autoloading switchboard
Aug 2, 2005 7:02AM PDT

Leep,

The switchboard is just a form, so the easiest way is to go to Tools>Startup ... then set the combobox for the form to be opened at startup to switchbox. While being there, you might like to have a look at the other settings.

But an Openform in a macro called Autoexec should work also. That's executed automatically at startup.

Be aware that keeping shift pressed will inhibit a lot of this to work. Don't tell the user!


Kees

- Collapse -
THANKS!
Aug 2, 2005 7:27AM PDT

Thanks that was just what I needed. As a side note I dont suppose you know if there is an easy way to allow people who do not have access installed to view the database I just created? I know i can sace reports to snapshots and have people install the snapshot viewer, but I want them to be able to navigate the switchboard I created. Any thoughts? Thanks again.

- Collapse -
Access run-time
Aug 2, 2005 5:17PM PDT

Leep,

Delve into the Office resource kit, and find out all about how to setup and distribute run-time Access and mde-files. That way users don't need full Access installed, and they can't modify your coding. It's fully supported.

Hope this helps.


Kees