Monday, January 28, 2019

How Do I Disable Layout View for Forms and Reports in Access at Start Up?

Create a function called SetMyOptions()

Function SetMyOptions()
'disable Layout View for forms and reports
    Application.SetOption "DesignwithData", False
End Function
Run this function in an AutoExec macro.





How do I run a macro or code when the database starts?

Monday, January 21, 2019

How Do I Maximize an Access Database at Start Up?

Create a function called SetMyOptions()

Function SetMyOptions()
'maximize Access
    Application.SetOption "maximized", True
End Function
Run this function in an AutoExec macro.





How do I run a macro or code when the database starts?

Monday, January 14, 2019

How Do I Minimize the Ribbon In Access at Start Up?

Create a function called SetMyOptions()

Function SetMyOptions()
'minimize Ribbon
     If Not (CommandBars("Ribbon").Controls(1).Height < 100) Then
        CommandBars.ExecuteMso "MinimizeRibbon"
     End If
End Function
Run this function in an AutoExec macro.





How do I run a macro or code when the database starts?

Monday, January 7, 2019

How Do I Minimize the Access Navigation Pane on Start Up?

Create a function called SetMyOptions()

Function SetMyOptions()
'Open Nav Pane collapsed
    CurrentDb.Properties("Startupshowdbwindow") = False
    SendKeys ("{F11}")
    SendKeys ("{F11}")
End Function
Run this function in an AutoExec macro.





How do I run a macro or code when the database starts?