ccocker
Last Activity: Nov 27 '13, 08:50 PM
Joined: Nov 17 '13
Location:
-
I have solved the problem. I will post my code in a few hours -
thank you - I did try this and it does work for a basic XML file i.e. I can successfully load a file that I created.
The issue is that the XML file comes from another system and I believe it needs to be parsed. From my searching it appears this can be done using MSXML, however I cannot seem to get it working in Access. I suspect I need a library reference loaded but not sure which one I need.
When I put the following...Leave a comment:
-
Import XML File to a MS Access Table
hi guys,
I am wanting to import an XML file into MS Access Table - can someone assist in guiding me through the VBA to create the import.
I have some experience in VBA writing Functions,Proce dures etc but XML is new to me.... -
Thank you - very helpful. I get why it was not working now, you forced me to re-think my approach.
So I essentially just created a public function to get the value from the combobox on the main form (so it is always accessible to me). Then on each subform I just call the function and assign it to the field on the subform I am on using the Me! feature.
Sometimes approaching something in the opposite way to the way you...Leave a comment:
-
Navigation Control - Subforms
Hi guys,
I have in the past referred to controls on subforms without any issue, however with the new navigation control there does not seem to e a subform to refer to other than NavigationSubFo rm.
I have tried the following:
Me![NavigationSubfo rm]![prjCustomer] = Forms![menu]!cmbCustomer
Me![NavigationSubfo rm]![cCustomer] = Forms![menu]!cmbCustomer
I have also tried: ...
No activity results to display
Leave a comment: