How Open Start Up Dialog with VBA

a_20120

tan
Local time
Tomorrow, 00:24
Joined
Nov 21, 2006
Messages
175
Hi everyOne,
How it is possible to open the StartUp window of Ms Access Via VBA
 
re:

Hi,
What startup dialog do you mean? Do you mean the one under tools--startup...? Why would you want to open this via VBA. If necessary you can set all options behind that dialog at runtime through VBA. A good sample of this can be found here. If this is not what you are trying to achieve then post back with some clarifications.
HTH
Good luck
 
More Explanation

freakazeud said:
Hi,
What startup dialog do you mean? Do you mean the one under tools--startup...? Why would you want to open this via VBA. If necessary you can set all options behind that dialog at runtime through VBA. A good sample of this can be found here. If this is not what you are trying to achieve then post back with some clarifications.
HTH
Good luck

after I set some options on Startup of Ms Access file, like hide the Object Window and disable the special keys like Shift+F11, F11 and ...

after that I want to have a button on a form that be able to open the start up window for me to change the settings.
 

Attachments

  • StartUp.JPG
    StartUp.JPG
    28.7 KB · Views: 154
re:

Why can't you go to tools--startup...and change the settings there?
Start your application holding down the shift key...all should be back to normal...then you can modify your settings if you want.
HTH
Good luck
 
Re.

Hello Sir,

I want to disable the Shift Key when the file open, and also I disable the right click menu, and all menus and toolsbar too, therefoe I want to add a button on a form, that in some cases be able to open the startup window, and modify ther settings.

please solve this problem...
 
re:

Hi,
The command to bring up the startup properties dialog is:

DoCmd.RunCommand acCmdStartupProperties

But as earlier mentioned you might be better of setting these settings through code rather then exposing dialog. However, I guess that is up to you.
HTH
Good luck
 
Thanks Very Much

Hi, Thank you very much,
Could you please write me how it is possible to disable the Special Keys, Hide Object Window, Disable Right Click, ... on Start Up Window with Coding.
 
re:

Hi,
check the link I provided in my initial reply.
HTH
Good luck
 
Hi,

I have just come across your thread and would liek to guide you to another post on this site that i have used and found verry usefull.

If you use this code, then when you open your DB you will not see the DB window at all! this way the end user cannot use any of the toolbars or play with anything you do not wish them to.

http://www.access-programmers.co.uk/forums/showthread.php?t=112067&highlight=Hide+Access+Window

The one thing i am yet to implement though is changing the hot key "Shift" so that it wont work when someone tries to bypass the code.

Alternatively if you wish to keep the same hot key, have you thought about password protecting your DB?

Hope that this helps.

Bev
 

Users who are viewing this thread

Back
Top Bottom