Tag Archives: Unhide

How Do You Fix an Automation Error in VBA?

One of the more frustrating errors to occur in VBA is the Automation Error.  It can often pop up for no apparent reason despite your code looking perfect. Reasons for This Error There are a variety of reasons that this can occur. Microsoft Office is

No Thumbnail

Hide/Unhide Access Ribbons, VBA

This article will explain how to hide and unhide the ribbon in Access using VBA. – Hide: The following code will hide the ribbon: Call DoCmd.ShowToolbar(“Ribbon”, acToolbarNo) Before: After: – Unhide: The following code will unhide the ribbon: DoCmd.ShowToolbar(“Ribbon”, acToolbarYes) See also: Hide/Unhide Navigation Pane Access

No Thumbnail

Hide/Unhide Navigation Pane Access VBA

This article will explain how to hide and unhide the navigation pane in an Access database using VBA. – Hide: The following code will hide the navigation pane: ‘select the navigation pange Call DoCmd.NavigateTo(“acNavigationCategoryObjectType”) ‘hide the selected object Call DoCmd.RunCommand(acCmdWindowHide) Before: After: – Unhide: The