CommandBar ACtiveX with MS Access...

I am hoping someone will be nice enough to help a codeJock beginner. I'm an Access 2002/2003/2007 developer trying to implement some menubars and toolbars as a replacement for the ribbon(which my customers hate).  I understand I must use commandbarsframe and I've successfully designed a couple of nice toolbars using the designer.  I drop a commandbarsframe on an access form, load the xcb files, adjust the size a little, and it looks good. 

 

Here's my problems/questions.

 

1/. if I want 2 toolbars on one form, do I need 2 commandbarsframe(s) or is there a way to fit them both in 1 frame.  So far I' m using 2.

 

2/. I studied the object browser but I can't seem to access any of the objects with vba.  For instance how do I access the CommandBarOptions object (or can I access it)? 

 

I tried this in both form_open and form_load ...

but then I need something like

 

similarly, how can I programatically access the commandbarsframe object, and the globalsettings object?  What works in vb doesn't seem to work in Access vba.

 

3/. How do I make it work without the ocx license file?  Whenever I remove the license (as I legally must) the activex controls come up with the dreaded "Control is empty" error.  I read the tutorial about including license information by loading it into the globalsettings.  I followed those instructions exactly but it doesn't seem to help. 

 

Thanks for any pointers you can give.

Derek.

 

 

1.  I need them together.  But using designer how do I force controls to be on 2 different rows?  Whenever I add a new control it always goes on the right-hand end until it exceeds the form width, then it wraps.  That's not what I want.

 

2.  What is "CommandBarsFrame2"?  Is that just the name property of the CommandBarsFrame?  Assuming that's what you mean -  it does not work for me...

 

 

 

'ERROR "Object variable or With block variable not set"

 

when typing the messagebox line, Access does show me a dropdown list of properties of Options, so something is trying to work.  But I always et that error when trying to access any property.

 

Thanks - Derek

 

 

 

1/. I will try & let U know.

 

2/. That is the name property.  U can rename it whatever you want. I call it "Toolbar1"  You did not answer my question.  Why is the cbo object empty even after I set it to the commandbarsFrame.options?

 

 

This code also fails

 

 

 

Basically I seem unable to assign any CodeJock objects to any vba object variables.

 

So  to cut to the chase - how the heck do I read and write the options?

Derek