Code

Re: Using Fields in my Form as the Filename

PaulPHS — Fri, 15 Oct 2010 15:59:51 GMT

Thats Awesome thanks for the advice Potemkine.

Re: Using Fields in my Form as the Filename

Potemkine — Fri, 15 Oct 2010 15:32:44 GMT

If you can't use debugger for some reason, you can use an old debug method with XDocument.UI.Alert("BREAK1")

you place your Message box on your code and you can figure out where you have your error.

Re: Using Fields in my Form as the Filename

PaulPHS — Fri, 15 Oct 2010 15:18:02 GMT

I was trying to use debugger before but it keeps giving me an Admin right error which is odd since I am the Admin.

Re: Using Fields in my Form as the Filename

Potemkine — Fri, 15 Oct 2010 15:04:25 GMT

I glad I could help, to debug VBS form code you can use "debugger",

http://office.microsoft.com/en-US/infopath-help/deboguer-le-script-HA010173118.aspx

With that you can make break point and see where your bug is.

Re: Using Fields in my Form as the Filename

PaulPHS — Fri, 15 Oct 2010 14:56:12 GMT

Thanks Potemkine. That worked. Wish InfoPath give me a better error.

Re: Using Fields in my Form as the Filename

Potemkine — Fri, 15 Oct 2010 14:52:18 GMT

Ok, your Xpath is wrong the good one is :/my:myFields/my:PtInfo/my:ptfname

To known a xpath on your datasource window right click on your field and then click copy Xpath, after that you paste it to your code.

Re: Using Fields in my Form as the Filename

PaulPHS — Fri, 15 Oct 2010 14:51:14 GMT

Here is my template.

Re: Using Fields in my Form as the Filename

PaulPHS — Fri, 15 Oct 2010 14:35:31 GMT

I was trying to figure out the error I was getting but InfoPath isn't giving me one. For the XPath I did a copy and paste from a data connection. I found that being the easiest way to get it right. At least thats what I think anyway. I have attached the error I am getting, I'll attach the template in a sec.

Re: Using Fields in my Form as the Filename

zacharybrown — Fri, 15 Oct 2010 14:12:33 GMT

PaulPHS, the logic I struggled with the most was my "XPath". You may double check yours and make sure it includes the correct [MainDataSource].

Re: Using Fields in my Form as the Filename

Patrick Halstead — Fri, 15 Oct 2010 06:17:55 GMT

Also, you can click on details and send us the error message. :)

Re: Using Fields in my Form as the Filename

Potemkine — Fri, 15 Oct 2010 01:31:03 GMT

Ok, try to attach your form template, to do that, when you reply, click on option and select your template...

Re: Using Fields in my Form as the Filename

PaulPHS — Thu, 14 Oct 2010 23:31:47 GMT

I just switched those around and I still get an error when I submit.

InfoPath cannot complete this action, because of an error in the form's code.

Re: Using Fields in my Form as the Filename

Potemkine — Thu, 14 Oct 2010 23:20:26 GMT

Hi, I'm not completly sure about this line XDocument.SaveAS(txtPath & txtName & sFileCode) it should be XDocument.SaveAS(txtPath & sFileCode & txtName)

Re: Using Fields in my Form as the Filename

PaulPHS — Thu, 14 Oct 2010 20:25:05 GMT

Hi,

I am actually trying to do the same thing as Zach but I am still getting an error. Here is what I have.

Sub orders_OnClick(eventObj)

Dim txtPath
Dim txtName
Dim sFileCode

txtPath = "\\PHSORNT152\Laboratory\Lab\Client Services\Message Manager\1 Time Orders\"

sFileCode = XDocument.DOM.selectSingleNode("my:PtInfo/my:ptlname").text

txtName = ".xml"

XDocument.SaveAS(txtPath & txtName & sFileCode)

End Sub

Re: Using Fields in my Form as the Filename

Potemkine — Thu, 14 Oct 2010 19:09:22 GMT

You're welcome, Have a great day too!