SQL Database Integration

Re: Passing Parameter to Infopath from ACCESS 2010

Massa — Tue, 12 Sep 2017 00:23:58 GMT

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.

Re: Passing Parameter to Infopath from ACCESS 2010

Hilary Stoupa — Thu, 07 Sep 2017 20:51:26 GMT

Not sure. I've never tried opening a form w/ input params from Access. You can attach your screenshot under the Option tab in a reply - perhaps someone else will have an idea.

Re: Passing Parameter to Infopath from ACCESS 2010

Massa — Thu, 07 Sep 2017 20:34:32 GMT

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.

Re: Passing Parameter to Infopath from ACCESS 2010

Massa — Thu, 07 Sep 2017 20:30:12 GMT

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 error?

Re: Passing Parameter to Infopath from ACCESS 2010

Hilary Stoupa — Thu, 07 Sep 2017 20:11:21 GMT

Have you tried the URL syntax instead? "file:\\mytestserver\Poll_test.xml?MyID=26" I don't know if that would work, but you may as well try it. :)

Re: Passing Parameter to Infopath from ACCESS 2010

Massa — Thu, 07 Sep 2017 20:01:51 GMT

(Excuse the typo)

Should have been:

objIP.XDocuments.Open ("file:\\mytestserver\Poll_test.xml" / InputParameters "MyID=26")

Re: Passing Parameter to Infopath from ACCESS 2010

Massa — Thu, 07 Sep 2017 19:59:46 GMT

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 syntax:

objIP.XDocuments.Open ("file://\\mytestserver\Poll_test.xml" / InputParameters "MyID=26")

Re: Passing Parameter to Infopath from ACCESS 2010

Hilary Stoupa — Thu, 07 Sep 2017 19:45:09 GMT

You have to add code to the form to retrieve that parameter value. See this blog post for more info: https://blogs.msdn.microsoft.com/infopath/2007/02/26/passing-data-into-a-form-input-parameters/

Re: Passing Parameter to Infopath from ACCESS 2010

Massa — Thu, 07 Sep 2017 19:36:37 GMT

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.

Re: Passing Parameter to Infopath from ACCESS 2010

Hilary Stoupa — Thu, 07 Sep 2017 19:22:33 GMT

What are you trying? Do you have code in the form to get the parameter values?

Re: Passing Parameter to Infopath from ACCESS 2010

Massa — Thu, 07 Sep 2017 18:50:16 GMT

I've search for days, no luck. Can't get the syntax to work. Any help would be appreciated!

Passing Parameter to Infopath from ACCESS 2010

Massa — Thu, 07 Sep 2017 17:27:16 GMT

Is it possible to pass a sql parameter to the Main connection of an InfoPath form. When I open INFO path from access, I use objIP.XDocuments.Open ("\\OurServer\test\test.xml") Is there syntax to add to this line, like FieldName = "X"?