Forum Discussion

BajaRic2009's avatar
BajaRic2009
Copper Contributor
Jul 06, 2023

Northwinds 2.0 template Help

Is there anyplace/anyone who can provide some basic help with the new Northwinds 2.0 Developer version of the template? I'm specifically looking for some guidance modifying the customized ribbon. I've made some minor changes to labels, etc. that all work but I CANNOT seem to add an additional button in the 3rd group (Maintenance). When I copy-and-paste the lines for the last button, change the button ID and the label and reload the XML into USysRibbons and suddenly the ribbon won't load. ANy suggestions? Am I corrupting the XML file when I add lines?

  • Thanks for the thanks. I will pass it along. Stay tuned; v2.2 is not too far away. Also note the videos that have been posted on YouTube. The team has already discussed many aspects of NW2 and several recordings are available.

    > I also wonder if working directly in the table might be causing an issue?
    Yes. That is why I am using a text editor. The Access built-in textbox definitely has issues with larger XML formatted files. I never edit directly, nor in the textbox on frmSysRibbons.
  • I'm one of the creators of NW2.
    What I do is create a new form bound to USysRibbons, so I can easily replace the XML.
    I always make a backup first, because (as you found out) it is easy to break things. The XML is case sensitive and VERY picky.
    I copy the XML to a text file (I use Notepad++ with an XML add-in, and I save the file as "ribbon.xml" so I get syntax highlighting), and edit it there; not in the above mentioned form - that is just for copy/paste.
    Editing xml is mostly a matter of copy/paste an item.
    Same thing for the callback functions in modRibbonCallbacks: VERY picky.
    Once you are more comfortable, this web site is the one I use for all the finer points of the XML: https://www.accessribbon.de/en/

    • BajaRic2009's avatar
      BajaRic2009
      Copper Contributor

      Tom_van_Stiphout Thank you VERY MUCH for the quick response! I've been working with Access almost from the beginning and I'm always on the lookout for a good template for apps I build and maintain. I think I've done everything you suggest except that I use PSPad as my editor and I've been saving my working code in a TXT file, rather than XML. But I make the mods in the editor and then copy-paste them into the memo field of the USysRibbons table in the database. I will try renaming the text file to XML and letting my editor syntax check it to see if that turns up anything. I also wonder if working directly in the table might be causing an issue? When it "breaks", the app opens, asks me to log in and then goes to the Orders screen, as expected, but the ribbon doesn't change (it remains the default one). There are no error messages, but I assume the XLM code "failed" when loading? Using the same editing process to remove the 5 lines of added code for the new button seems to fix things.

       

      Thanks again, a thanks to the entire NW2 team for a great template.

      • Tom_van_Stiphout's avatar
        Tom_van_Stiphout
        Steel Contributor
        Thanks for the thanks. I will pass it along. Stay tuned; v2.2 is not too far away. Also note the videos that have been posted on YouTube. The team has already discussed many aspects of NW2 and several recordings are available.

        > I also wonder if working directly in the table might be causing an issue?
        Yes. That is why I am using a text editor. The Access built-in textbox definitely has issues with larger XML formatted files. I never edit directly, nor in the textbox on frmSysRibbons.

Resources