Microsoft Access - Using XML Files

Reading and Writing
In this video we will:
1. Use the Line Input # method to display an XML file on a form
2. Open an XML file and retrieve data contained within XML tags
3. Open an XML file, update data contained within XML tags and save the updated file
***NOTE: I neglected to mention that you need to make a reference to Microsoft XML, v6.0 (or any version) in order to run this code!!!!
The VBA in this video can be found here:
accessjitsu.com/2016/01/16/mic...
NotePad++ website (free):
notepad-plus-plus.org/
Print # and Line Input #:
• Writing and Reading Se...
All of my videos organized by topic and other blog topics:
accessjitsu.com/

[@williampimienta2652]

Thanks for the tutorial.

[@dpsethi]

Great Tutorial, Thanks!

[@janezklun]

Thanks for this great tutorial

[@YOUSSEF.HOUIET]

thanks for this useful tutorial
where can i download the access file used in this tutorial?

[@mariano-cucinotta]

Hi and thanks for the video.
Could I kindly know, given your knowledge of xml if it is possible to recreate a structure that is exported from WordPress more precisely an article and using an access database, pass data to that structure.
Thanks

[@leifmusset6834]

Hello, is there a way to relink ms access automatocally to mysql in phpmyadmin?

[@tradingtechnicals4715]

Great video thanks very much, I just dont know how to got to the code to run, I have put the code in the Form_frmPrintLineInput tabe but then it wont allow me to run. Is the code in the module?

[@Accessjitsu]

Without knowing "what" won't run, it's hard for me to say. However, you do need a reference to the Microsoft Scripting Runtime and may also need the Microsoft Office Object Library reference.

[@ahmedhamdy3137]

@@Accessjitsu rmPrintLineInput/cmdRead_Click Error Number 91= Object variable or with block variable not set