Disable Toolbars (1 Viewer)

Status
Not open for further replies.

Guus2005

AWF VIP
Local time
Today, 23:35
Joined
Jun 26, 2007
Messages
2,645
Code:
Public Sub NoToolbars()
'Disable toolbars
    Dim prp As Property
    
    On Error GoTo Err_NoToolbars
    CurrentDb.Properties("AllowBuiltinToolbars") = False
    
    Exit Sub
Err_NoToolbars:
    If Err = 3270 Then 'property not found
      Set prp = CurrentDb.CreateProperty("AllowBuiltinToolbars", dbBoolean, False)
      CurrentDb.Properties.Append prp
    Else
      MsgBox Err.Description
    End If
End Sub
Enjoy!
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom