Ribbon comes up empty in a runtimed Access 2007 app

My Access app 2007 displays the ribbon I created OK when required in development mode but when runtimed and moved to another computer, it appears empty when required.
I cannot show the picture as EE crashes when I try to upload the screen dump replacing it with a new tab in Firefox (!)
The question is simply: what would cause a properly defined ribbon to come up empty in my runtime app (or anywhere)?

Many thanks.
PeborghAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LucasMS Dynamics DeveloperCommented:
The only thing i can think of is that the XML file is not properly structured.

Take a look at this website:

http://www.databasedev.co.uk/access2007ribbon.html

Then download Peter's XML editor (FREE) and create or dump your existing ribbon to check for errors.

http://www.iol.ie/~pxe/

Good luck.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PeborghAuthor Commented:
OK, if it isn't structured, why does it appear to work in development mode?
It must be recognised that in dev mode there is already development ribbon present which might do things that make my ribbon work also. And that ribbon is not present in the runtimed app... What do you think?

I will do what you propose early next week.

peter
LucasMS Dynamics DeveloperCommented:
I'm not sure if  you've seen this, but this might help you:

http://msdn.microsoft.com/en-us/library/cc136539%28v=office.12%29.aspx
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

JezWaltersCommented:
Just out of interest, do you get the same behaviour when you simulate the run-time environment via the command line?

   msaccess /runtime "C:\YourPath.YourDatabase.mdb"
PeborghAuthor Commented:
Oh, hello Jez!

I will try this this afternoon...

peter
PeborghAuthor Commented:
Jez,

Would you believe:

msaccess.exe /runtime "c:\Program Files\Counselog 4.2\Counselog 4.27.accdb"

fails to kick off anything? So does msaccess without the ".exe"

What is going on?

peter

PeborghAuthor Commented:
JezWalters,

Eventually, the answer to your question: Yes, it come up empty when run on the dev machine as /runtime. Which I suppose should gives me a simple way in for investigation...

peter
PeborghAuthor Commented:
lucas911, with apologies for delay.

I activated displaying UI errors in my app and sure enough it came up with
line 4, character 21 error 0xC00CEE25 equal expected .

here is the XML:

"
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
   <ribbon startFromScratch="true">
      <tabs>
      <tab id="RTF" label" Formatting a large text field" visible="true">
                 <group idMso="GroupTextFormatting"></group>
                 <group idMso="GroupRichText"></group>
      </tab>
      </tabs>
   </ribbon>
</customUI>
"

Sure enough (again!) I think there should be an = after label in line 4. Not at character 21. BUT when I open the table and try to modify the XML, it does funny things like adding additional characters, shifting characters around, etc...

Help!

Many thanks,

peter
LucasMS Dynamics DeveloperCommented:
Hey Peter,

You solved it!

How did you fix the problem?
PeborghAuthor Commented:
I copied the XML to Notepad, modified it and copied it back in...

Any ideas why the text within the Access table behaved the way it did?

many thanks,

peter
JezWaltersCommented:
I'm not sure if it's just a copy/paste error but I reckon the XML should be:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
   <ribbon startFromScratch="true">
      <tabs>
      <tab id="RTF" "label"=Formatting a large text field" visible="true">
                 <group idMso="GroupTextFormatting"></group>
                 <group idMso="GroupRichText"></group>
      </tab>
      </tabs>
   </ribbon>
</customUI>

I suspect you've figured it out by now, but the XML you posted in ID 35468644 above is missing a quotation mark and an equal sign.
JezWaltersCommented:
If you're thinking of dabbling with XML a lot, you'd do well to use some sort of XML validator - I use PSPAD (www.pspad.com).

Hope that helps!  :-)
JezWaltersCommented:
For what it's worth, the XML standard requires badly formed XML to be rejected out of hand - though it looks like (surprise, surprise) Microsoft isn't doing this when the ribbon XML is incorrect!  :-(
PeborghAuthor Commented:
Thanks, Jez. I d intend to get too deely into XML (Thanks God). I did fix the problem as you describe.

The current prob is hiding the ribbon. At the moment it justs greys out. This is in another ongoing question ID 26978315 .

peter
JezWaltersCommented:
I realise you've sorted it now, but just for the record I meant this XML:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
   <ribbon startFromScratch="true">
      <tabs>
      <tab id="RTF" label="Formatting a large text field" visible="true">
                 <group idMso="GroupTextFormatting"></group>
                 <group idMso="GroupRichText"></group>
      </tab>
      </tabs>
   </ribbon>
</customUI>

The label attribute name shouldn't be quoted, of course - serves me right for rushing!  :-)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.