IP2007 to Outlook (user) back to Outlook upload to MS Access 2007 - InfoPath Dev
in

InfoPath Dev

IP2007 to Outlook (user) back to Outlook upload to MS Access 2007

Last post 01-17-2010 03:55 PM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 01-15-2010 09:50 AM

    • ronallard
    • Not Ranked
      Male
    • Joined on 11-25-2009
    • Marlborough, MA
    • Posts 2

    IP2007 to Outlook (user) back to Outlook upload to MS Access 2007

    I can perform this using the wizard in Access 2007 but the IP form it creates is quite unprofessional looking (looks just like the html). I've tried creating the form in IP2007 sending it via Outlook2007 to our users. They in turn fill in the form and return it to us but I can find no help anywhere for getting the replies uploaded back to Access. The wizard does it but how???? I tried importing external xml file into access but I end up with two tables one called header the other called values.How can I get just one loaded into an existing table???

  • 01-17-2010 03:55 PM In reply to

    Re: IP2007 to Outlook (user) back to Outlook upload to MS Access 2007

    In order to submit to Access, you'll need to base your form off the Access DB when you create it. If you go to create a new form, you'll see that basing it off a database is one of the options. Perhaps add a submit button on the form that submits to Access that is only displayed for you (you can use User Roles for this, or the userName() function in IP 2007), then when the form is emailed back to you, you can review it and submit the data to your Access DB.

    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.