StartupShowDBWindow property

[MichaelK]

In Access 2002 application on startup I'm hiding dbwindow, using:
ChangeProperty "StartupShowDBWindow", dbBoolean, False

It's working fine.
Now sometimes I need to see dbwindow, and it doesn't show up.
I'm trying:
ChangeProperty "StartupShowDBWindow", dbBoolean, True
or just:
dbs.Properties("StartupShowDBWindow") = True
It doesn't work.

Also I'm leaving for users only custom bar, so no way to Unhide it.
Even I enable menu bar later Unhide still doesn't show dbwindow.

What is the best way to bring database window back when I need it.

Thanks,
Michael

 

[Albert D. Kallal]

All of the code settings you need are in

tools->startup


If you need a sample of such an
application that hides everything with no code or security, you can download
the 3rd example at:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

That above sample is NOT a mde, and does not have the shift key turned
off..but ONLY those two additional things need to be done to complete secure
the above sample. So, once you try the above, exit, and then hold down the
shift key during start-up.


Of course, during testing and development I hold down the shift key to load
my application, and ignore those start-up settings.

After writing and testing some bit code, I will want to test things from the
"end" users perspective. I simply exit my application (alt - f4 key),
usually
at this point the mdb file I was working on in the window is still
highlighted, so then I whack enter key and re-load (no holding shift key).

Now I can test, and play in the view that my users will get. If all is well,
and my testing is over, then I exit the again, and re-load using shift key
so I can get back to development mode.

The above process occurs VERY fast. So, you can flip between
development mode, and user execute/test mode very fast.

If your startup options are set..then the database window is hidden
when run as user mode, but when you shift-bypass, you get
the database window. (so, why bother with startup code anyway
when you don't need any?).

Once I am happy, then I can create the final mde for the users
(you do use a mde
for your users...right!???). It is this mde that you really only need to
turn off the shift key for. And, only need to turn off the shift key if
your users discover this feature. To do that, I use my hand dandy shift key
browser code that lets you select the mde (or mdb) of your choice, and set
the shift key. Check it out at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

So, since you don't every have to turn off shift key code in your
development code, but only your final production code, then the shiftkey
very rarely gets in the way of development. I mean a quick alt-f4 and a
enter whack lets you test the system the way the user will see it...but ONLY
for deployment of the mde should you bother with the shift key setting, not
your development mdb.

The above also applies to display/hide of the database window....

 

[JimB]

Michael,

I do this in Access2000:
In the Access menubar, under Tools,select Startup to get
the startup option menu. To hide the database window
uncheck "Display Database Window". There are a variety
of other options to choose from, but make a copy of your
db because if you uncheck the wrong combination, you may
not be able to get into the startup menu. You can set
your menu and shortcut menu bars here as well.

To access the hidden db window, press F11 or Alt-F1.

JimB

 

[MichaelK]

Thanks Jim, I figured out how to program it.
But your statement about F11 now created another problem for me.
Is there a way to prevent this F11 and Alt-F11?

Thanks,
Michael

 

[JimB]

Michael,

There are many ways to solve your issue. I take it you
do not want people to get to the main db window except
for you or an administrator. I have my db's secured by
using edited Access system.mdw file. I set a new admin
user like admin123 and myself as administrator. Then set
the permission to all the db objects within the db. You
can reference Microsoft's websites or your local book
store on how to secure a db. You can program a special
button or menu selection in your custom menu bar
called "View Main" or whatever you what to call it and
reference a fuction to display the main db window. I have
code in my main switch board that checks the username
logged in and if is not Admin123 or myself it locks the
Startup option, (in your case the "View" option) in the
menu bar. Other users will see it but cant access it.

Hope this helps. JimB