Browser Forms

Re: Reviewing Attachments with infopath form

Frody — Mon, 08 Dec 2008 20:20:09 GMT

Yeh thats the tricky part here, the database has created a subset that I can't see or access, but in the main table it appears as an attachment that much is certain..I can send another screen shot tomorrow if that would help...

Point of fact though I don't necessarilly need to be able to store the files in the database, but it would seriously help, would this be easier to achieve if I wasn't using access I wonder?

Re: Reviewing Attachments with infopath form

Hilary Stoupa — Mon, 08 Dec 2008 18:53:41 GMT

And then, in your Access Database, the column that you wanted to use for your attachement? Is it text, or character (I'm not very familiar with Access data types)?

The thing is, you aren't going to be able to simply bind a file attachment control to a field that uses a text data type. And as far as I know, InfoPath isn't going to allow you to have a submit connection to a database that has a field that would accept an attachment.

Is it absolutely necessary that the attachment be stored in the database? Do you intend (for example) to need to access that field from other applications?

Re: Reviewing Attachments with infopath form

Frody — Mon, 08 Dec 2008 18:28:48 GMT

Ah I see, sorry but no the form has been create from the design wizard in infopath, using the database as the mainsource, if I drag and drop it creates by default a text box which reads the file names but doesn't provide a link to the file, nor can I view multiple files, just the one... very frustrating I feel like this might be a limitation of the software, but I am not willing to lie down and take it without a fight, so here I am..

Re: Reviewing Attachments with infopath form

Hilary Stoupa — Mon, 08 Dec 2008 17:48:44 GMT

I'm sorry, I should have been more specific. From your screenshots, it appears as if your form was created off the database you intend to submit to, is that correct? In the database, what is the data type of the Attachments field? I'm asking because I thought that InfoPath wouldn't allow submit on a db bound form if the db had certain types of columns in it, including file attachment columns. If you drag the attachment field onto the form, what type of control does IP create? I'm wondering if you aren't getting kind of a misleading error message...

Re: Reviewing Attachments with infopath form

Frody — Mon, 08 Dec 2008 17:45:53 GMT

Oh just got your point... data type is down as simpleType.. can I amend this somehow?

Re: Reviewing Attachments with infopath form

Frody — Mon, 08 Dec 2008 17:37:11 GMT

The data type would be attachments of any kind stored in an access database, which I want to be able to review, amend and attach as required..

Re: Reviewing Attachments with infopath form

Hilary Stoupa — Mon, 08 Dec 2008 16:50:18 GMT

What is the data type on the field that is causing the trouble?

Re: Reviewing Attachments with infopath form

Frody — Mon, 08 Dec 2008 16:36:31 GMT

Last shot... this should sum up my frustrations...

Re: Reviewing Attachments with infopath form

Frody — Mon, 08 Dec 2008 16:35:47 GMT

Freakie forum seems to not like me posting twice...

Re: Reviewing Attachments with infopath form

Frody — Mon, 08 Dec 2008 16:34:22 GMT

Re: Reviewing Attachments with infopath form

Anuma — Sun, 07 Dec 2008 15:59:41 GMT

HI,

First inser repeating table into the form and then insert Attachment in that Repeating Table.

BTW, You can attache screen shorts in this forum only.

Click on Reply button in the forum.
Click on "Options" tab.
Click on "Add/Update" button.
There you can attach your Screen Shorts".

Re: Reviewing Attachments with infopath form

Frody — Sat, 06 Dec 2008 11:52:10 GMT

Hmm see as far as I can tell I have the group already bound to a repeating field, but when I got to insert the control it doesn't?won't bind, any chance I could send you a couple of screen shots via email so that you can see what I see and tell me where I am being completely stupid, which I suspect is the case eventually :o)

Re: Reviewing Attachments with infopath form

swathip — Sat, 06 Dec 2008 05:14:03 GMT

Hi,

I think the attachment control is not binded to the repeating field. Make sure that the attachment control is binded to a field which is under the repeating group in data source. Do check this one,

1. Go to view -> Design tasks.

2. Click on Data source.

3. Go to the attachment control and click on that.

4. See in the Data source pane. It will highlight one field. Make sure that field is under the repeating section(The section in which you placed the control).

Reviewing Attachments with infopath form

Frody — Fri, 05 Dec 2008 17:17:27 GMT

Dear All,

I am trying to create a form that enables me to review, update and submit new entries to an Access database.

As part of this I want to be able to review and add attachments in a repeating section (accompanied by a commentary field explaining the status of the document)

But I keep getting the same damned message that the attachment field must occur in the repeating section or table bound to the group the attachments are part of, as far as I can see I am doing just that but it seems to think otherwise, can any suggest the problem here.. better yet the solution?

Cheerio

Phill