Author: Pat
-
SAP BOM Upload
To load a bill of materials into SAP I needed to create a XML file with the hierarchy of the bill. To start this project in Access you will need to set a reference to ChilkatXML (free from chilkatsoft.com), or you use MS DOM Object but I prefer the coding structure provided by chilkat, and a…
-
Creating Ribbon Menu in VBA
Ribbon Menu’s are controlled by the table USysRibbon and the function MyButtonCallbackOnAction Download my sample application , in the Ribbon table I have included the Ribbon for the application a reporting ribbon and sample of other ribbons I have used in the past. The ribbon menus are written in XML , set your application to…
-
Sage Invoice Loading
In our sample application we have loaded a number of samples to work with Sage Line 50. The sample below was used to create a Sage Invoice. The sources for the header and transaction will vary depending on the source but this sample will get you started. You will need to create a link to…
-
Viewing XML Files
I use Chilkat to make and read XML files. I like the way the program is structured. In this sample you can paste raw unformatted XML – Click XML Formatted will format the XML to a more readable format. You can also use the same option with JSON Files. Sample Database Zipped – https://anythingaccess.com/wp-content/uploads/2024/11/Pretty_XML.zip Code…