Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 2 (11 items) 1 2 Next > Re: Passing Parameter to Infopath from ACCESS 2010 The syntax for URL and SharePoint, do not work for me from Access. I saw a command line option, a parameter was combined with. If I can get it to work, I'll post the syntax. Posted to SQL Database Integration (Forum) by Massa on 09-11-2017 Populate username in infopath 2010 form from Access db. Do not have sharepoint. Survey form needs Yes/No responses from an email. Is there a way to get the username of the person filling out the form. I cant find anything on the internet, except for using sharepoint, which our company doesn't use. Does anyone know how to do this? I tried referencing the operating system's whoami, but couldn't get it to work. ... Posted to SQL Database Integration (Forum) by Massa on 09-11-2017 Re: Capture current username on infopath 2010 form Maybe if I restate the title question a different way? Send an InfoPath form email to some email addresses. Main connection is an Access DB. I want to be able to receive the answer by person, to know who responded with which answer. Is this possible? Posted to General (Forum) by Massa on 09-11-2017 Capture current username on infopath 2010 form I'm trying to create a questionnaire form. Form is sent as email to users. Main connection is tied to a MS Access DB table that has fields: username, id, and response(yes/no). DB should update with only current user response. We do not have share point. Thank you! Posted to General (Forum) by Massa on 09-11-2017 Re: Passing Parameter to Infopath from ACCESS 2010 Picture of my error didn't post. But it said InfoPath cannot open the following file: ~ it copied the path through the poll_id=26 - and read that 'Then system could not find the path specified. Posted to SQL Database Integration (Forum) by Massa on 09-07-2017 Re: Passing Parameter to Infopath from ACCESS 2010 The Url syntax didn't work. I got access to accept objIP.XDocuments.Open ("\\MyTestServer\Mytest.xml /InputParameters 'Poll_ID=26'") InfoPath opens, not the form, it doesnt seem to recognizing the /inputParameters , and I receive an error on the Access side. I'm guessing its a syntax ... Posted to SQL Database Integration (Forum) by Massa on 09-07-2017 Re: Passing Parameter to Infopath from ACCESS 2010 (Excuse the typo) Should have been: objIP.XDocuments.Open ("file:\\mytestserver\Poll_test.xml" / InputParameters "MyID=26") Posted to SQL Database Integration (Forum) by Massa on 09-07-2017 Re: Passing Parameter to Infopath from ACCESS 2010 I added the code to the form, but I don't have the correct syntax on the access side when launching info path. Set objIP = CreateObject("InfoPath.Application") This works: objIP.XDocuments.Open ("file://mytestserver/Poll_test.xml" But Access doesn't accept, it highlights the line as incorrect ... Posted to SQL Database Integration (Forum) by Massa on 09-07-2017 Re: Passing Parameter to Infopath from ACCESS 2010 Hi Hilary, I have a Main Connection set up which links to an Access db table. I'm trying to pass a command line parameter so that when I open InfoPath form, the correct record displays. I do not have anything set up on the form itself yet. Posted to SQL Database Integration (Forum) by Massa on 09-07-2017 Re: Passing Parameter to Infopath from ACCESS 2010 I've search for days, no luck. Can't get the syntax to work. Any help would be appreciated! Posted to SQL Database Integration (Forum) by Massa on 09-07-2017 Page 1 of 2 (11 items) 1 2 Next > Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.