Access Programming - 2010Hide Contextual Tabs in RibbonTo hide DataSheet contextual tab in Form Tools Ribbon add code to xml ribbon definition <contextualTabs>
<tabSet idMso="TabSetFormDatasheet" visible="false" />
</contextualTabs>
idMso for all existing tabSets: TabSetFormToolsLayout TabSetFormTools TabSetReportToolsLayout TabSetReportTools TabSetRelationshipTools TabSetQueryTools TabSetMacroTools TabSetPivotTableAccess TabSetPivotChartAccess TabSetTableToolsDatasheet TabSetTableToolsDesign TabSetFormDatasheet TabSetAdpFunctionAndViewTools TabSetAdpStoredProcedure TabSetAdpSqlStatement TabSetAdpDiagram TabSetFormReportExtensibility VBA7 for Office 2010http://msdn.microsoft.com/en-us/library/ee691831.aspx As office 2010 can run in 64 bit mode, need to explicitly declare pointer sizes in API Declare statements. Use conditional compilation for backward compatility #if VBA7 then
Declare PtrSafe Sub MessageBeep Lib "User32" (ByVal N AS Long)
#else
Declare Sub MessageBeep Lib "User32" (ByVal N AS Long)
#end if
|
Resources Articles Access Database
|