Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2019, 09:56 PM
DangerDraper DangerDraper is offline Dynamic Populate Content Control XML Windows 8 Dynamic Populate Content Control XML Office 2010 64bit
Novice
Dynamic Populate Content Control XML
 
Join Date: Sep 2016
Posts: 3
DangerDraper is on a distinguished road
Default 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>

Reply With Quote
  #2  
Old 10-16-2019, 05:57 AM
Charles Kenyon Charles Kenyon is offline Dynamic Populate Content Control XML Windows 10 Dynamic Populate Content Control XML Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,070
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Who has phased out Access?
Reply With Quote
  #3  
Old 10-16-2019, 04:36 PM
DangerDraper DangerDraper is offline Dynamic Populate Content Control XML Windows 10 Dynamic Populate Content Control XML Office 2019
Novice
Dynamic Populate Content Control XML
 
Join Date: Sep 2016
Posts: 3
DangerDraper is on a distinguished road
Default

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...
Reply With Quote
Reply

Tags
form, ms word, xml

Thread Tools
Display Modes


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
Dynamic Populate Content Control XML Auto populate a text field based on Content Control Dropdown List matthias92701 Word VBA 2 05-02-2019 03:54 PM
Dynamic Populate Content Control XML 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
Dynamic Populate Content Control XML 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft