infopath project

O

Osyris

Hi all

can someone plz help me with my project?

Well..
i want to create a question form in infopath wich will contain the name of
a user,and genarally some personal elements.Also text boxes,check boxes etc.
Now, users will fill in the form and i want this form to be saved in an
access database.

please help..

thanks.
 
A

Adam Harding

Hi

First off, think of what questions and stuff you want to appear on the form.

Then create a database for the answers and information you need to record.

then open Infopath click Design a new form, then New from Data Connection.
Browse to your database and select. Now design your form by adding text
fields, check boxes etc to your hearts content (If you forgot to add a field
in the database you can go back to the database add it in and then click
'Tools', 'Data Connections', 'Main Connection' and then 'Modify'. Tick 'Show
Table Columns' and browse to the field you added. Tick it and then Next,
Finish, Close.)

Add a button on the bottom of the form to submit the data to the main
connection and job done.

One word of caution, Access, if you use it, can only take Text Fields up to
255 Characters and cannot use memo field type. It can only use Date, Number,
Yes/No, currency, autonumber and Text (255)

I hope this helps

Cheers Adam
 
O

Osyris

Adam this helped me very much but as a new user i have one more question..
For example..
i have this question in the form "How was your holiday"
and user should write in a text box "fine,ok,bad" etc..
And an other question "sex"
and the user has 2 check boxes "male" "female"
This 2 examples how can i make then work as i say priviously?

many thanks..
 
A

Adam Harding

Osyris

Add two fields to the database called rating and sex

Add a layout table with 2 rows and 2 columns. In row 1 column 1 add your
question, in row 1 column 2 add a text field and link it to rating
In R2C1 add your sex question and in R2C2 add drop-down list control bound
to sex.

Add a button at the bottom of the form that submits to main connection and
job done.

Cheers Adam
 
O

Osyris

Thanks ma u r the best

Adam Harding said:
Osyris

Add two fields to the database called rating and sex

Add a layout table with 2 rows and 2 columns. In row 1 column 1 add your
question, in row 1 column 2 add a text field and link it to rating
In R2C1 add your sex question and in R2C2 add drop-down list control bound
to sex.

Add a button at the bottom of the form that submits to main connection and
job done.

Cheers Adam
Click to expand...
 
O

Osyris

Adam hi again...
i did what you said..i created a layout table in ifopath but now the problem
is i dont know how to link it with rating!!!
i told you im new in this!!
can you give me an extra help again?

many thanks
 
Top