from:
http://sites.google.com/site/msaccesscode/vba-3/hidemessagebarwhilestartingdatabase
DoCmd.RunCommand acCmdHideMessageBar statement can be used to hide MS Access 2007 Message Bar from VBA.
However while starting database application, the Message Bar shows up with some delay, so you cannot just place RunCommand HideMessageBar in your AutoExec macro to hide it.
This happens for example if you have tables linked to SharePoint lists. Every time you open such application you get a message "Publish changes. Save your
changes to the server. Publish to SharePoint site."
To resolve the issue, place the following function in any public module and call it from AutoExec macro. This will execute DoCmd.RunCommand acCmdHideMessageBar with some delay.
Function fHideMessageBar()
Dim Start
Start = Timer ' Set start time.
Do While Timer < Start + 1 ' 1 sec delay, change if necessary
DoEvents ' Yield to other processes.
Loop
DoCmd.RunCommand acCmdHideMessageBar
End Function
Katie wrote:
Hide option to Publish to SharePoint (Access 2007)
29-Aug-09
Hi - I have an Access 2007 database that at one point had bee
published to SharePoint. We took it offline several months ago, mad
major changes to it, deleted the linked SharePoint lists, and have n
intention of ever linking it to SharePoint again. However, every tim
we open the database, the message bar appears with the option t
Publish to Sharepoint. Is there a way to completely remove this? Th
database is used by our entire company and we do not want anyon
selecting this option
I know there is a way to remove the message bar alltogether, but w
cannot do that because we need people to see the security warning s
they will enable the content and allow macros to run. Is there a wa
to just remove the Publish to Sharepoint message bar
Thanks in advance for the help
-Katie
Previous Posts In This Thread:
Hide option to Publish to SharePoint (Access 2007)
Hi - I have an Access 2007 database that at one point had bee
published to SharePoint. We took it offline several months ago, mad
major changes to it, deleted the linked SharePoint lists, and have n
intention of ever linking it to SharePoint again. However, every tim
we open the database, the message bar appears with the option t
Publish to Sharepoint. Is there a way to completely remove this? Th
database is used by our entire company and we do not want anyon
selecting this option
I know there is a way to remove the message bar alltogether, but w
cannot do that because we need people to see the security warning s
they will enable the content and allow macros to run. Is there a wa
to just remove the Publish to Sharepoint message bar
Thanks in advance for the help
-Katie
How to hide MS Access Message Bar (all of them)
from:
http://sites.google.com/site/msaccesscode/vba-3/hidemessagebarwhilestartingdatabase
Hide Message Bar while starting database
posted ??Oct 9, 2009 8:06 AM?? by Pavlo Pedan
DoCmd.RunCommand acCmdHideMessageBar statement can be used to hide MS Access 2007 Message Bar from VBA.
However while starting database application, the Message Bar shows up with some delay, so you cannot just place RunCommand HideMessageBar in your AutoExec macro to hide it.
This happens for example if you have tables linked to SharePoint lists. Every time you open such application you get a message "Publish changes. Save your
changes to the server. Publish to SharePoint site."
To resolve the issue, place the following function in any public module and call it from AutoExec macro. This will execute DoCmd.RunCommand acCmdHideMessageBar with some delay.
Function fHideMessageBar()
Dim Start
Start = Timer ' Set start time.
Do While Timer < Start + 1 ' 1 sec delay, change if necessary
DoEvents ' Yield to other processes.
Loop
DoCmd.RunCommand acCmdHideMessageBar
End Function
Re: Hide option to Publish to SharePoint (Access 2007)
From:
http://sites.google.com/site/msaccesscode/vba-3/hidemessagebarwhilestartingdatabase
DoCmd.RunCommand acCmdHideMessageBar statement can be used to hide MS Access 2007 Message Bar from VBA.
However while starting database application, the Message Bar shows up with some delay, so you cannot just place RunCommand HideMessageBar in your AutoExec macro to hide it.
This happens for example if you have tables linked to SharePoint lists. Every time you open such application you get a message "Publish changes. Save your
changes to the server. Publish to SharePoint site."
To resolve the issue, place the following function in any public module and call it from AutoExec macro. This will execute DoCmd.RunCommand acCmdHideMessageBar with some delay.
Function fHideMessageBar()
Dim Start
Start = Timer ' Set start time.
Do While Timer < Start + 1 ' 1 sec delay, change if necessary
DoEvents ' Yield to other processes.
Loop
DoCmd.RunCommand acCmdHideMessageBar
End Function
EggHeadCafe - Software Developer Portal of Choice
Run Stored DTS Package in VBScript & FTP Output
http://www.eggheadcafe.com/tutorial...9-fa03f17aa752/run-stored-dts-package-in.aspx