Access 2007 message bar showing

[So Call Me Crazy]

Anyone know how to hide the message bar when my Access 2007 database opens?
When my DB initially opens, there appears a message bar with a button to
publish to sharepoint. ugh.

Had to use XML to eliminate the default Access 2007 ribbon. Perhaps there's
a setting for turning the message bar off too??

TIA.

 

[Tom van Stiphout]

On Wed, 28 Jan 2009 15:19:01 -0800, So Call Me Crazy

Try this:
Application.SetOption "Show Status Bar", False

-Tom.
Microsoft Access MVP

 

[So Call Me Crazy]

OK. stupid question, but where would I put that code?

 

[Tom van Stiphout]

On Thu, 29 Jan 2009 08:18:15 -0800, So Call Me Crazy

Somewhere in your startup code.
This is how I start an application:
Create an AutoExec macro with one line: RunCode, and the function name
is InitApplication.
Then in a standard module I write:
public function InitApplication()
Application.SetOption "Show Status Bar", False
'Other initializations go here, e.g. reattach to back-end.

'Finally we're ready to open the first form.
DoCmd.OpenForm "myFirstForm"
end function

-Tom.
Microsoft Access MVP