Hide access - only switchboard view

[RiskyP]

Hello,

Recently I came across a database where - on open, only the main swtchboard form appeared on screen. This was minimized to the center of the screen, and the usual access 'grey' background was minimized onto the taskbar. A user could maximise access to get to the edit tabs, but tabs from the ribbon were missing, and nothing was clickable except for the main swtichboard. In order to edit anything the from had a 'maintanence' button (along with all other usual comand buttons related to forms, queries and a close button ect....).

When the maintanence button was clicked, only then was the 'usual' access view with options, navigation view and tabs to make edits ect.... clickable

My question is... how would I go about creating something like this? I know about on load event to hide certain veiw panes, but the user can still easily get to the edit controls without having to click a maintanence button. I would like to link this to a login form/table

If anyone could help it would be greatly appreciated

Thanks
P

Running Access 2010

 

[Rx_]

Besides being on a project deadline, it is somewhat of a big question.
Hate to see a question go completely unanswerd.
The best I can do at the moment is to suggest you search this forum's Sample Database section.
It is on the page 2 of a bunch of samples:
This is an example of a switchboard front-end to a database
the download is swbrd.zip
While it doesn't provide your exact answer, it could serve to provide some valuabel ideas to get you started.

 

[mrkn]

Hello,

Recently I came across a database where - on open, only the main swtchboard form appeared on screen. This was minimized to the center of the screen, and the usual access 'grey' background was minimized onto the taskbar. A user could maximise access to get to the edit tabs, but tabs from the ribbon were missing, and nothing was clickable except for the main swtichboard. In order to edit anything the from had a 'maintanence' button (along with all other usual comand buttons related to forms, queries and a close button ect....).

When the maintanence button was clicked, only then was the 'usual' access view with options, navigation view and tabs to make edits ect.... clickable

My question is... how would I go about creating something like this? I know about on load event to hide certain veiw panes, but the user can still easily get to the edit controls without having to click a maintanence button. I would like to link this to a login form/table

If anyone could help it would be greatly appreciated

Thanks
P

Running Access 2010

Do you still interested in solution?