Avatar of John Kincaid
John KincaidFlag for United States of America

asked on 

Dim cBars As CommandBars error

The below procedure returns error "user-defined type not defined" with Dim cBars As CommandBars highlighted.  I tried "Dim cBars As DAO.CommandBars" with the same results. I have verified that the reference to DAO3.6 is checked.

Any help appreciated.

Public Sub ToggleCmdBars()
 
  Dim cBars As CommandBars
  Dim cBar As CommandBar
   
  Set cBars = Application.CommandBars '   reference databases commandbars collection
   
  For Each cBar In cBars '   loop through each commandbar in the commandbars collection
    With cBar
      If .TYPE = 0 Then '    if it is a tool Bar, disable it
        If .Enabled = False Then
          .Enabled = True
        Else
          .Enabled = False
        End If
      ElseIf .TYPE = 1 Then '    if it is a menu Bar, disable it
        If .Enabled = False Then
          .Enabled = True
        Else
          .Enabled = False
        End If
      End If
    End With
  Next

'Pop-Up menus remain enabled
End Sub
Microsoft ApplicationsMicrosoft Access

Avatar of undefined
Last Comment
John Kincaid
ASKER CERTIFIED SOLUTION
Avatar of pteranodon72
pteranodon72
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of John Kincaid
John Kincaid
Flag of United States of America image

ASKER

You are exactly right, thanks alot.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo