#1
|
|||
|
|||
Dynamic Populate Content Control XML
Hi all,
Looking for assistance here with getting this done in XML. I need to find a quick and VBA-free (macros are disabled by default on project) method for populating a series of comboboxes and then (hopefully) make them dynamic of each other. Originally this used to be an Access db and a series of forms (on a similair project) but they've now phased out access. Which wouldn't be a problem with Office 19/365 as I could use the dynamic arrays features in excel... Unfortunately they're using a mix of Office 13/16. Basically the three combos represent a different column in a table and the tables is approx ~50 lines deep. And the form will be based off aprrox 10-15 similiar sized tables. Me being too lazy to manually populate each CC, I had hoped that I could pull these lists into the CC via a custom XML Add-in. I had thought either of the two would work... but the xml doesn't bind to the CC Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <!--<xmlns="Data Scaveneger"/>--> <DataScavenge> <Common> <UniqueID></UniqueID> <systemName> <item> <system>Air Conditioning</system> <system>Cooling Water</system> <system>Cold Water</system> <system>Hot Water</system> </item> </systemName> <pscName> <psc>AirCon</psc> <psc>CoolWtr</psc> <psc>CldWtr</psc> <psc>HotWtr</psc> </pscName> <TSC></TSC> </Common> <Section1></Section1> </DataScavenge> |
#2
|
|||
|
|||
Who has phased out Access?
|
#3
|
|||
|
|||
Hi Charles, the customer (of this form) has been phasing out its reliance upon access. Even going as far as to remove Acces from its std workstations.
Big problem being is that they haven't offered an alternative app... |
Tags |
form, ms word, xml |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing content control data from excel and populate two fields on selected dropdown | badarlodhi | Word VBA | 8 | 02-08-2023 10:47 AM |
Auto populate a text field based on Content Control Dropdown List | matthias92701 | Word VBA | 2 | 05-02-2019 03:54 PM |
Auto populate text box based on drop-down content control and repeat the process via copy paste | helenndp | Word VBA | 2 | 09-27-2018 11:04 AM |
Populate Content Control Dropdowns from Excel | Deirdre Kelly | Word VBA | 23 | 09-07-2017 02:51 PM |
Populate Drop-Down Content Control from CustomXMLPart added to the Document | KhmerBoi1 | Word VBA | 0 | 05-11-2016 01:10 PM |