Results 1 to 9 of 9
  1. #1
    Stan Denman is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    50

    Export MS access query data to specific XML format


    I am trying to figure out how to fill a pdf form with data from MS Access.&nbsp; Proving amazingly difficult.&nbsp; Adobe Acrobat Pro DC seemed to have no functionality, so I switched to FoxIt.&nbsp; There I found I can populate a form from xml.&nbsp; But the XML Access gives me is not in the format that FoxIt wants to see.&nbsp; If I go to my FoxIt form and expert to XML I of course get the format FoxIt wants to see.&nbsp; And if I fill it by hand, go back to FoxIt and import, I get my desired results.<br><br>I cannot figure out, though how to export to XML in the right format.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Someone asking the same thing, pretty much, here.
    https://www.utteraccess.com/topics/2.../posts/2801332
    See if this helps at all?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Stan Denman is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    50
    I asked trying to solve this specific problem, but it was definitely a different question.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Quote Originally Posted by Stan Denman View Post
    I asked trying to solve this specific problem, but it was definitely a different question.
    Really?, I thought they were trying to fill a pdf?

    Here is the demo from the DBguy. http://www.accessmvp.com/thedbguy/demos/fillablepdf.php that was mentioned in that link?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Stan Denman is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    50
    Yes, that is the specific problem - the question was clearly about solving it by a different method. Don't really know why we are going around on this. You don't have to respond to my question. Thank you.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Not a problem. I have put you on my IL.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    Stan Denman is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    50
    Please do.

  8. #8
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Just use vba to write the xml in the format that foxit wants. Good luck.

  9. #9
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Sorry, did not realise you had crossposted from that other forum.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Export MS access query data to specific XML format
    By Stan Denman in forum Import/Export Data
    Replies: 1
    Last Post: 06-26-2022, 09:25 AM
  2. Replies: 4
    Last Post: 09-19-2016, 05:02 PM
  3. Access 2010 InfoPath Data Collection Export Fails Due to Date Format
    By raghureddy02 in forum Import/Export Data
    Replies: 3
    Last Post: 01-22-2014, 10:40 AM
  4. Replies: 1
    Last Post: 10-28-2013, 12:32 PM
  5. Export Specific Data
    By Learner123 in forum Access
    Replies: 3
    Last Post: 05-29-2011, 11:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums