News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Monday, July 30, 2007

Commandbar with hidden control is deleted after compact in Access 2003

I have an old application, which was mostly used in Access 2000 recently, and there is a shortcut command bar where I show/hide controls depending on selected value.

Listbox has different communication items – phone, email, skype and if user right-click on, say skype, it shows buttons to start skype call, delete and copy number, other buttons – phone call, email, web are hidden. Only today I found that once you compact this application in Access 2003 – this commandbar disappear. Completely! Did anybody see this and have a solution? So far I implemented a following fix – I made a copy of commandbar and at application startup I check if commandbar exists, if not – the restore it from copy using Commandbarcontrol Copy method.

Technorati tags: ,


Blogger Alex Dybenko said...

This also happens in Access 2002 (XP)

8:08 PM  
Blogger Alex Dybenko said...

Code to "Copy CommandBars using VBA":

11:46 AM  
Anonymous Phone Power said...

Having the command bar disappear like that could be pretty annoying, to say the least. Why did they set it up like that? People should be able to access Skype or any other application regardless of whether they are on 203 or anther version.

11:12 PM  
Anonymous kellis said...

I don't use that for databases much anymore.

8:06 PM  

Post a Comment

<< Home