1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| Sub ParamProprDémarrage()
Const DB_Text As Long = 10
Const DB_Boolean As Long = 1
ModifiePropr "StartupForm", DB_Text, "Clients"
ModifiePropr "StartupShowDBWindow", DB_Boolean, False
ModifiePropr "StartupShowStatusBar", DB_Boolean, False
ModifiePropr "AllowBuiltinToolbars", DB_Boolean, False
ModifiePropr "AllowFullMenus", DB_Boolean, True
ModifiePropr "AllowBreakIntoCode", DB_Boolean, False
ModifiePropr "AllowSpecialKeys", DB_Boolean, True
ModifiePropr "AllowBypassKey", DB_Boolean, True
End Sub
Function ModifiePropr(chNomPropriété As String, varTypeProp As Variant, varValeurProp As Variant) As Integer
Dim bds As Object, prp As Variant
Const conErreurPropNonTrouvée = 3270
Set bds = CurrentDb
On Error GoTo Change_Err
bds.Properties(chNomPropriété) = varValeurProp
ModifiePropr = True
Change_Sortie:
Exit Function
Change_Err:
If Err = conErreurPropNonTrouvée Then ' Propriété non trouvée.
Set prp = bds.CreateProperty(chNomPropriété, _
varTypeProp, varValeurProp)
bds.Properties.Append prp
Resume Next
Else
' Erreur inconnue.
ModifiePropr = False
Resume Change_Sortie
End If
End Function |
Partager