+ Reply to Thread
Results 1 to 2 of 2

Help... Access Menu Bar issue, not populating

  1. #1
    Registered User
    Join Date
    02-03-2012
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    1

    Help... Access Menu Bar issue, not populating

    I've been picking with VBA coding, macros, etc for a couple of years now and just 2 days ago I became stumped with a very odd issue.
    I have been remediating Win xp -Office 2003 Access applications so they work in Win 7 using Office 2010. 2 days ago I successfully opened an access application in XP and noticed that there is a custom menu bar which is populated via a module... essentially the ADODB connection fetches the menu dropdown items and populates the custom menu bar. This works perfectly in Access 2003 (using xp os).
    When I open it in Win 7, using Office 2010. The app opens properly and there are no missing references. All Menu dropdowns are populated, except for one (one that is titled 'Reports')... When this one is clicked, a blank square appears with no menu items. It's the only menu item like this, all other menubar buttons work great. That's part one of this strange issue. Part two is what really gets to me. If I right click the form (where the menu bar resides) and go to design view, then I change the view back to form view... the 'Report' menu button now has all of the menu items it should have been populated with in the first place.
    I've tried debugging, recompiling... even inserting code to automatically change to design view and back to form view for me ... to work like a refresh on load. That last attempt didn't work because once you go to design view the code breaks and never executes the form view trigger.

    This may sound like an easy one, but I'm honestly stuck on something that makes very little sense at this point.

    Any ideas? Has anyone else ever experienced this? Thanks

  2. #2
    Registered User
    Join Date
    04-19-2010
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Help... Access Menu Bar issue, not populating

    I know there was an issue with 2007 where you had to enable VBA to edit itself to do things like dynamically crated UIs. Is there anything in your settings that look like this? "Allow access to the VBA object model?" That's all I can think of.
    Excel\Access, VBA, C#, C++, SQL, Java

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1