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.
posted by Alex Dybenko | 19:10
4 Comments:
This also happens in Access 2002 (XP)
Code to "Copy CommandBars using VBA":
http://smsconsulting.spb.ru/shamil_s/topics/copycmdb.htm
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.
I don't use that for databases much anymore.
Post a Comment
<< Home