-
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.
-
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 ...
-
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. :)
-
(Excuse the typo)
Should have been:
objIP.XDocuments.Open ("file:\\mytestserver\Poll_test.xml" / InputParameters "MyID=26")
-
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 ...
-
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/
-
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.
-
What are you trying? Do you have code in the form to get the parameter values?
-
I've search for days, no luck. Can't get the syntax to work. Any help would be appreciated!
-
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"?