Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2009
    Posts
    49

    Unanswered: how to integrate xml to ms access 2007

    hello

    does anyone know how to integrate the xml in the ms access 2007? I have some xml code here, and I would like to integrate it but don't know how to start.

    Here is the sample I found in the internet:
    General Format of XML Markup Files
    You can use XML markup to customize the Fluent UI. The following example shows the general format of an XML markup file that customizes the Fluent UI in Word 2007.

    <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    <ribbon>
    <tabs>
    <tab idMso="TabHome">
    <group idMso="GroupFont" visible="false" />
    </tab>
    <tab id="CustomTab" label="My Tab">
    <group id="SampleGroup" label="Sample Group">
    <toggleButton id="ToggleButton1" size="large"
    label="Large Toggle Button"
    getPressed="ThisDocument.MyToggleMacro"
    onAction="ThisDocument.MyActionMacro" />
    <checkBox id="CheckBox1" label="A CheckBox"
    screentip="This is a check box"
    onAction="ThisDocument.MyCheckboxMacro" />
    <editBox id="EditBox1" getText="ThisDocument.MyTextMacro"
    label="My EditBox" onChange="ThisDocument.MyEditBoxMacro"/>
    <comboBox id="Combo1" label="My ComboBox"
    onChange="ThisDocument.MyComboBoxMacro">
    <item id="Zip1" label="33455" />
    <item id="Zip2" label="81611" />
    <item id="Zip3" label="31561" />
    </comboBox>
    <dialogBoxLauncher>
    <button id="Launcher1" screentip="My Launcher"
    onAction="ThisDocument.MyLauncherMacro" />
    </dialogBoxLauncher>
    </group>
    <group id="MyGroup" label="My Group" >
    <button id="Button1" label="My Large Button"
    size="large" onAction="ThisDocument.MyButtonMacro" />
    <button id="Button2" label="My Normal Button"
    size="normal" onAction="ThisDocument.MyOtherButtonMacro" />
    </group >
    </tab>
    </tabs>
    </ribbon>
    </customUI>

    Thanks for your help.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    What do you mean by "integrate the xml in the ms access 2007" and how do you know that the example you found is applicable to Access?
    Have a nice day!

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I think he just needs to know where to put this "code".

    I can't remember the table and fieldname for this... try googling "customize Access 2007 ribbon" and I am sure you will soon find out. One of the table names is USysRibbon or something...
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Feb 2009
    Posts
    49
    @Sinndho: i was trying to find out where I can put this xml file in ms access 2007. I found this on the website and wanted to try out. Anyway I was able found out how to do it and so far it works.
    By creating another table named as USysRibbon.

    I'm actually trying to transfer the Menu Bars from the Ms access 2003 to Ms access 2007.
    I was able to hide the original ribbon bars and just have the "Add-In" with the Menus from Ms access 2003.
    Now I would like to customize this Menu Bars by changing the size of the icons from normal size to bigger size. I found a software which can do this and the software is: IDBE Ribbon Creator.
    Now my question is: where I can integrate the events of each buttons that I have so that every time I clicked it will function the same as it has from the MS access2003?

    Any idea?

    Thanks

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Isn't it a wonderful experience having to use an extra disconnected tool to modify the ribbon?! Access 2003 is vastly superior.

    And I would have thought the code in post 1 would give you the answer to what happens when you click your buttons -- OnAction / OnChange; but I have yet to get the IDBERC installed and fiddle around with it to know yet.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Feb 2009
    Posts
    49
    @StarTrekker: thanks for your reply. so what do you actually suggests?

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Using Access 2003... tbh.

    The fact is that there is no easy answer to this newly created problem of ribbon customisation.

    What irks me more is the total inability to remove the stupid "office button".
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Feb 2009
    Posts
    49
    @StarTrekker: i understand what you like, but at somepoint things should be upgraded and updated.

    I think there is always a solution to all of these problems

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well there isn't one. In 2007 you either use IDBE Ribbon Creator or you code the XML yourself or you don't do it. It's not just what I like, it's the truth of the matter!

    Yes, things should eventually be upgraded. But 2007 is NOT an upgrade imo, it is a serious DOWNGRADE. I have recommended to ALL my customers to totally dodge 2007 and await the next version (2010). I see nothing wrong with that.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •