How to reenable mysteriously disabled ribbon

rickober

Registered User.
Local time
Yesterday, 19:35
Joined
Dec 12, 2012
Messages
10
I have a button that prepares a pdf report and sends it to an email address. This has worked great for years in every version of Access Except 2013. and it works there too but it has a strange quirk: it disables the ribbon. The ribbon is visible but everything is greyed out. If I close/reopen the application, it is good to go.

The functions uses CDO for windows 2000 and as such it goes to some web site to assist in its work. I have isolated the issue to the last command of the code " iMsg.Send".

How can I prevent this strange behavior and short of that, is there line of code to (re)enable the ribbon on the next line? It's just the standard ribbon. The entire ribbon is disabled.

This is the biggest time waster I have ever encountered!! Isn't this software supposed to get better/easier, not more confounding???

Thanks in advance for any insights/suggestions.
 
what is your original setup and your current one? And have you upgraded your 2000 system to 2013?
 
Thanks for the question. The computer I am working with is brand new with 2013 on it and Windows 7. I "upgraded" the mdb file to an accdb format and I get the same results. I really want to keep it in a 00 format since working in that environment is so much easier. Other than this snag, everything seems to work just fine.

In searching for a solution, I am coming to learn that the ribbon is a completely different architecture/approach and I suspect that something on the cdo helper page is sending something to that disables the ribbon.
Rick
 
I
am coming to learn that the ribbon is a completely different architecture/approach. I suspect that something on the cdo helper page is sending something to that disables the ribbon.
it is and quite possibly

is there line of code to (re)enable the ribbon on the next line?
To be clear, do you mean disabled (i.e. greyed out) or hidden?

Not sure if these links will help
http://stackoverflow.com/questions/12186208/re-enable-full-menu-ribbon-in-ms-access-2010

http://www2.palomar.edu/pages/atrc/2013/04/22/office-2013-ribbon-display-options/

http://www.access-programmers.co.uk/forums/showthread.php?t=151711
 
Thanks again for your eyeballs and ideas! The ribbon is visible and everything is grayed out, ie disabled (or whatever it is called but I am pretty sure it is "disabled"). If it were merely making it invisible, it would be simple to get it back and those pages you suggested do that but there seems to be something beyond that to reenable the ribbon.

I did find another page that suggests that some of this has to be done at XML level. I keep hoping for a simple solution but it seems that there may not be one.

Thanks again for your help.
Rick
 

Users who are viewing this thread

Back
Top Bottom