I have a small database and forms already attached to a switchboard. I just was wondering if it is even possible to open striaght to that switchboard, without the access window in the background. Even if it pops up minimized and closes when the switchboard does.
I have looked into this and it is really hard to find info on it because I am not sure how to phrase the search. Although what info I have found led me to believe it can't be done. Any info or a point in the right direction would be really appreciated.
In the 'Tools' menu, select 'startup...', then select your form from the drop down list called 'Display Form/Page' and make sure the 'display database window' box isn't checked
Yeah that works to hide the window with all the forms and databases in it. I was kind of hoping to hide the whole access program.
Say for example if I had nothing else open. When I opened this all that would appear is the switchboard and nothing else. Meaning the rest of my desktop would still be visible. The idea is to make it look more like its own program.
Wouldn't that minimize the switchboard as well. It seems like such a simple thing that everyone would want to do. I am surprised I am having so much difficulty.
Access 200 and 2002 have an MDI view that lets you have forms open with the main access form minimised.... but to minimise access in code requires using API calls to find the access process and then send it a minimise command.... it may work, and it may not... I don't think MS makes it easy as then you may end up with people not even knowing they are using MS applications.
Just so you understand there are drawbacks. I believe all of your forms need to be PopUp and Modal and I think previewing reports seems to suffer too. Good Luck!
I worked out this and posted on a different thread. Minimal code and pretty straighforward. Rural Guy is right (of course!) in that you need to set the modal and pop for forms and reports or you can't see them as they are 'behind' the switchboard.
A very clean interface and uses hardly any code at all.
The switchboard is set to pop up, modal no, and sized to run off the right and bottom sides of the screen which results in it always filling the screen entirely.
Other forms & reports are set to Pop up on & Modal yes or they would not be visible as they would appear "behind" the switchboard.
The DB opens with the switchboard so the user cannot get to the database window.
2 Command Buttons are added to the switchboard, one to minimize the application and the other to close the application.
The DB appears as a single item in the task bar. If the minimize command on the switchboard is used, the db drops down to the task bar and a single click on the task bar icon restores the DB with the Switchboard showing.
The only irritation with this is that you have to open the DB with the shift key held down if you want access to the database window yourself. And if you are looking to modify the switchboard, you have to reload after every test viewing. Not big problems really.
In conclusion, this works well and is simple, albeit a savy user can get into the DB if they wish to.
Set the Switchboard to display on startup.
Set Switchboard
Pop up Yes
Modal no
Switchboard On Open event
Code:
'Set Switchboard size & position
Me.Move Left:=0
Me.InsideHeight = 15000 'Any number that is greater than the screen height
Me.InsideWidth = 20000 'Any number that is greater than the screen width
Switchoard Command button to minimize Access:
Code:
Private Sub cmd_Minimize_App_Click()
Application.RunCommand acCmdAppMinimize
End Sub
Some of the solutions offered on this thread runs to dozens (hundreds?) of lines of code so this simple solution may be suficient for some situations that do not warrent any added functionality provided by more complex solutions.
I worked out this and posted on a different thread. Minimal code and pretty straighforward. Rural Guy is right (of course!) in that you need to set the modal and pop for forms and reports or you can't see them as they are 'behind' the switchboard.
A very clean interface and uses hardly any code at all.
The switchboard is set to pop up, modal no, and sized to run off the right and bottom sides of the screen which results in it always filling the screen entirely.
Other forms & reports are set to Pop up on & Modal yes or they would not be visible as they would appear "behind" the switchboard.
The DB opens with the switchboard so the user cannot get to the database window.
2 Command Buttons are added to the switchboard, one to minimize the application and the other to close the application.
The DB appears as a single item in the task bar. If the minimize command on the switchboard is used, the db drops down to the task bar and a single click on the task bar icon restores the DB with the Switchboard showing.
The only irritation with this is that you have to open the DB with the shift key held down if you want access to the database window yourself. And if you are looking to modify the switchboard, you have to reload after every test viewing. Not big problems really.
In conclusion, this works well and is simple, albeit a savy user can get into the DB if they wish to.
Set the Switchboard to display on startup.
Set Switchboard
Pop up Yes
Modal no
Switchboard On Open event
Code:
'Set Switchboard size & position
Me.Move Left:=0
Me.InsideHeight = 15000 'Any number that is greater than the screen height
Me.InsideWidth = 20000 'Any number that is greater than the screen width
Switchoard Command button to minimize Access:
Code:
Private Sub cmd_Minimize_App_Click()
Application.RunCommand acCmdAppMinimize
End Sub
Some of the solutions offered on this thread runs to dozens (hundreds?) of lines of code so this simple solution may be suficient for some situations that do not warrent any added functionality provided by more complex solutions.
A very clean interface and uses hardly any code at all.
The switchboard is set to pop up, modal no, and sized to run off the right and bottom sides
of the screen which results in it always filling the screen entirely.
Other forms & reports are set to Pop up on & Modal yes or they would not be visible as they
would appear "behind" the switchboard.
The DB opens with the switchboard so the user cannot get to the database window.
2 Command Buttons are added to the switchboard, one to minimize the application and the
other to close the application.
The DB appears as a single item in the task bar. If the minimize command on the switchboard
is used, the db drops down to the task bar and a single click on the task bar icon restores
the DB with the Switchboard showing.
The only irritation with this is that you have to open the DB with the shift key held down
if you want access to the database window yourself. And if you are looking to modify the
switchboard, you have to reload after every test viewing. Not big problems really.
In conclusion, this works well and is simple, albeit a savy user can get into the DB if they
wish to.
Set the Switchboard to display on startup.
Set Switchboard
Pop up Yes
Modal no
Switchboard On Open event
Code:
'Set Switchboard size & position
Me.Move Left:=0
Me.InsideHeight = 15000 'Any number that is greater than the screen height
Me.InsideWidth = 20000 'Any number that is greater than the screen width
Switchoard Command button to minimize Access:
Code:
Private Sub cmd_Minimize_App_Click()
Application.RunCommand acCmdAppMinimize
End Sub
Some of the solutions offered on this thread runs to dozens (hundreds?) of lines of code so
this simple solution may be suficient for some situations that do not warrent any added
I used part of what RuralGuy had given me, I just had to drop the checking for the opn window. I have the code to minimize in the onLoad event. It seems to work fine. I got the exit button working just fine, but the minimize button doesn't work. It seems as though you are calling another command "acCmdAppMinimize" that has not been defined. Do I have to define that somewhere? Or will this not work with a method other than Keith's. Thanks.
Sorry about the tripple reply. There is some problem with the site hanging (network TCP/IP error- try agtain later) and I didn't want to log out and lose my post if it hadn't been accepted. Obviously they had!
Regards,
Keith.
I'm a relative novice and I'm not sure what you have done as you have taken something from RG and me.
the "acCmdAppMinimize" is built into Access, at least it is in 2003. I didn't do any defining, jut the code given in my post. No idea why it isn't working for you. Sorry.
I hope some of the other more knowledgable posters can shed light fr you.
