Adding a file

[Tiff]

Hi,

My form is almost finished and ready for publishing.

A couple of colleagues have suggested I include the 'add a file button'.

When I try to insert the 'add a file' control - I get asked to 'bind' it to
my database (the form is based on an access DB). I don't want to store the
files users add anywhere - I save the forms for reference, so is it possible
to just add this control and not have it bound to the DB fields - if so how
do I do this?

Also, a couple of times, I've realised I've left a field out of my DB MS
Access table that the form is bound to. I haven't been able to work out how
to refresh the form to pick up the changes to the source table - so I have
been rebuilding the form from scratch which is a bit tedious (but hey I'm
reinforcing the learning!). Is there a way I can add a field to my source DB
Table and then refresh the form so that it shows up in the Query Fields - and
I can therefore add it to the form?

Thank you,
Tiff.

 

[T.Coita]

Hi,

What is the benfit to link a file that you don't send to your database?
What would you do with this file?
If is that you want bound a xml (with only one field) a secondary
database and link that to your add a file controle. But when a user
select a file it's not bound to the things that infopath will send to
your database

For the second question click on tools data connections select xyour db
and click modify make all the steps with the same value and your
infopath form is refresh!

++

Thierry

 

[Alex [MSFT]]

For your first question: it seems that you want to reference the file, not
really add it to the form. Then all you need is to have a text box or a
hyperlink control where the user will be able to type in the URL or UNC path
of the file.

For your second question: explore the Tools | Convert Main Data Source
option. Additionally, try just going to Tools | Data Connections and
clicking Modify, and then going through the wizard again - your new fields
will be picked up.

Good luck,
Alex @ Microsoft