Database window not hidden

[Gina]

I have tried to get a response to this query for some time now, I really
need help.

With Access 2002 I have found a bug which is really bugging me!!!!

In start up option I de-select the 'Display Database Window' and disable the
Shift Key Bypass.

I distribute my database as a runtime.

The problem is, clients who use my database and have Access 2002 still see
the database window and all the objects.

I am aware that changing the option (deselecting 'Windows in Task bar') will
fix this problem, however I don't have access to my clients option settings.

Is there code that I can place in my database that changes the option
settings so that Windows in Task Bar is disabled.

Sorry for the detailed message.

Gina

 

[Bonnie]

I copied both functions into a new module called HideDB.
Do I add 'RunCode' to my AutoExec macro to get it to run
when the DB opens? When I tried that, I got errors on the
function name. The expression builder gives me this:
ChangePropertyDdl («stPropName», «PropType», «vPropVal»)
I get the error "can't find the name '«stPropName»' you
entered. I thought the variables were defined in the
code. I know I'm missing something and hope it can be
answered easily. Can someone point me in the general
direction? Do I run this function from the autoexec
macro?

Any advice would be VERY much appreciated. If, however,
you just want to ask an amoeba why it's trying to leave
the safety of a petri dish, find someone else to slam.
I'm really trying to learn something here.

-----Original Message-----
You can turn the AllowByPassKey off with a bit of code that is at the MVP
website:

http://www.mvps.org/access/general/gen0040.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Window' and disable
the

(deselecting 'Windows in Task bar')

 

[Lee]

You could either create an autoexec macro and select
RunCommand for action, and Command-WindowHide, Or add this:
DoCmd.RunCommand acCmdWindowHide in your initial form.

 

[Gina]

Hi Lee,

I have found what I was looking for in google.

Place the following in your startup form


Public fTaskbarWindows As Boolean

In the load event type the following;
fTaskbarWindows = Application.GetOption("ShowWindowsinTaskbar")
Application.SetOption "ShowWindowsInTaskBar", False

In the unload event type;
If fTaskbarWindows = True Then
Application.SetOption "ShowWindowsInTaskBar", True
End If


I hope this helps.

Gina


You could either create an autoexec macro and select
RunCommand for action, and Command-WindowHide, Or add this:
DoCmd.RunCommand acCmdWindowHide in your initial form.