David Emerson
newsgrps at dalyn.co.nz
Wed Mar 23 17:10:44 CDT 2011
I call the code below from the Open event of the first form that
opens when the app starts. I have just tested it on Access 2007 and
am still seeing the ribbon. My custom menu is showing in the Add In
tab. Am I doing something wrong?
Public Sub basSetProperties()
basSetProperty "StartupShowDBWindow", dbBoolean, False
basSetProperty "AllowShortcutMenus", dbBoolean, True
basSetProperty "AllowFullMenus", dbBoolean, False
basSetProperty "AllowBuiltinToolbars", dbBoolean, False
basSetProperty "AllowToolbarChanges", dbBoolean, False
basSetProperty "AllowSpecialKeys", dbBoolean, True
basSetProperty "StartupShowStatusBar", dbBoolean, True
basSetProperty "UseAppIconForFrmRpt", dbBoolean, True
basSetProperty "AppTitle", dbText, "Ribbon Test"
basSetProperty "StartUpMenuBar", dbText, "MenuBarMenus"
' basSetProperty "AppIcon", dbText, "C:Prog\LTD.ico"
End Sub
Public Function basSetProperty(strPropName As String, varPropType As
Variant, varPropValue As Variant) As Long
On Error GoTo Err_basSetProperty
Dim db As DAO.Database, prp As DAO.Property
Set db = CurrentDb
db.Properties(strPropName) = varPropValue
basSetProperty = True
Set db = Nothing
Exit_basSetProperty:
Exit Function
Err_basSetProperty:
If Err = 3270 Then 'Property not found
Set prp = db.CreateProperty(strPropName, varPropType, varPropValue)
db.Properties.Append prp
Resume Next
Else
basSetProperty = False
MsgBox "SetProperties", Err.Number, Err.Description
Resume Exit_basSetProperty
End If
End Function
Regards
David Emerson
Dalyn Software Ltd
Wellington, New Zealand
At 11/03/2011, Carolyn Johnson wrote:
>Well, it seems to be working on 2010 now. Maybe I'm thinking of
>times when I bypassed the startup form and then had to deal with the
>ribbon. But I thought it was enough of a problem to put on my To Do
>list. Guess I'll cross it off!
>
>Carolyn Johnson