Code

Re: Add repeating section via vb script

Hilary Stoupa — Tue, 20 Apr 2010 22:44:10 GMT

In the conditional formatting for your button, set the first dropdown to "The Expression". Type in position() != 1. This will hide your button for all but the first group.

Re: Add repeating section via vb script

Bob Arctor — Mon, 19 Apr 2010 15:59:53 GMT

Hi again Hilary. I think we're almost there. I understand the conditional formatting concept, but how do I set the "first instance of the group" condition/part?

Re: Add repeating section via vb script

jayanaveen — Mon, 19 Apr 2010 10:31:19 GMT

is there any way to hide menu bar in infopath 2003 form and restrict user to see only their items using form template.

Re: Add repeating section via vb script

Hilary Stoupa — Sat, 17 Apr 2010 11:54:03 GMT

MSDN says:

Note In some cases, calling the ExecuteAction method from the OnClick event for a button in a view may cause an error. This is because the selected context changes to the button when the button is clicked. In this case, it is better to use a button (or link) on a custom task pane, toolbar, or menu to call the ExecuteAction method.

Which may be what you are running into. I found that if I put the button inside the repeating table / section I wanted to use the insert before action on, it worked. You could do that, then use conditional formatting to hide your button unless it was in the first instance of the group.

Re: Add repeating section via vb script

Bob Arctor — Mon, 12 Apr 2010 16:12:19 GMT

Hilary, I'm back at work so I can provide more info about my form. As for the error message I spoke of earlier, it was "InfoPath cannot complete this action because of an error in the form's code". If I use xCollection::insert there is no problem. If I use xCollection::insertBefore (or other variations) I receive the error message.

As for my form, it has two sections- the top section is a repeating table and the second section is a repeating section with a repeating table inside of it. The top section contains employee data- name, unit, supervisor. The 2nd section contains a date field and task/time spent fields. The task field is a drop down box where the employee selects whatever task they worked on. The time spent field is where they record the time spent on any particular task. When the employee opens the form, they put their name in a name query field, then click a query button, which then populates the top section and the 2nd section. So, after running the query, the top section will contain their name, unit and supervisor. The second section shows the dates they worked and the tasks/time spent on each task. The second section is filtered to only show the 6 most recent weeks worked, so the typical user sees about 30 repeating sections worth of dates worked and the tasks/time spent for those days.

As it stands, when the user clicks the add section button I'm attempting to add to the form, it puts the new section at the bottom of the form (after the last repeating section), which requires the user to scroll all the way to the bottom of the form to fill it out. What I'm trying to accomplish is to have the new section be inserted immediately below the top section and above the most recently dated 2nd section, basically in between the two. Does that make sense? Let me know if you need further info and thanks again for your help!

Re: Add repeating section via vb script

Hilary Stoupa — Sat, 10 Apr 2010 00:06:16 GMT

Hi --

You can place the control you want on your form in the design view. Then, in Tools / Defaults, you can choose not to have the repeating group bound to that control included when the form is opened. Then your button can use xCollection::insert to insert the repeating section, and the control will show. Is that what you were asking? I may be a little confused. :-)

Re: Add repeating section via vb script

Bob Arctor — Fri, 09 Apr 2010 19:37:56 GMT

Hi Hilary. I'm off work today so I don't have access to my form to tell you what the error message is. While I have your ear, let me ask you another question, the answer to which may clear up my problem with the error message. Thanks to "xCollection::insert" I can insert the repeating section like I wanted. Let's say I wanted to insert it immediately after a particular repeating table on my form. Is that possible? If so, what would the vbscript syntax be for that? Basically, I'm looking for the repeating section to be inserted in a particular spot on my form (the user will do this via a button on the form). I've got the button on the form and the insert code behind it (which works), I just don't know how to control the placement of the repeating section on the form.

Thanks for all your help- I appreciate it!

Re: Add repeating section via vb script

Hilary Stoupa — Fri, 09 Apr 2010 00:36:37 GMT

What is the error?

Re: Add repeating section via vb script

Bob Arctor — Thu, 08 Apr 2010 14:47:21 GMT

In theory, found what I was looking for with "xCollection::insertBefore", but of course that was too easy, so I receive an error message when using that.

Re: Add repeating section via vb script

Bob Arctor — Thu, 08 Apr 2010 14:14:33 GMT

Thank you. That's what I was looking for. Now I just need to figure our how to make the repeating section appear at the top of the form instead of the bottom...

Re: Add repeating section via vb script

Hilary Stoupa — Wed, 07 Apr 2010 22:17:45 GMT

Hi:

Check out this blog post by Jimmy, or qRules can make this easy for you to do without code!

Add repeating section via vb script

Bob Arctor — Thu, 01 Apr 2010 16:54:56 GMT

Hello! I'm looking to add a button to my form with code behind the button that will add a repeating section. Basically, vb script that is equivalent to "Insert myrepeating section above".

Thanks in advance.