Frontpage form - submitting to a databas

[papakura]

Hello all

I have been creating an online questionnaire in MS Front page. When the form is inserted there appears a submit button and a reset button. I want the information that has been written on the form to be automatically written to a database when the submit button is pressed.

This option is grayed out when you right click on the submit button. In other words, I want it to not be grayed out. I asked the Tech team and they came back with "it was not grayed out" when they tried it. Presumaby then, there is some extension that needs to be set for all student/teacher users?

Any help would be appreciated.

Thanks

[john]

Have you set up the database on the website and also set the submit to database properities on the form? The form properties are accessible by right clicking inside the form, but not on a button, you select from there and get all the options you should need

[papakura]

Thanks for the reply John,

yes, I right click in the form but the database option is grayed out.

Thanks

[john]

Is it frontpage 2003 your using?

[papakura]

Hello John

We have Widows XP.
Is it because the page has to be uploaded to the network first? If so, I would really like to know how to do this.

Thanks

[mac_shinobi]

I havent used front page before but if you wanted it to write the results to a database from what I have done you would either have to use some thing like ASP or php to connect to and write the fields that are in the form into the relevant fields in the database...

Maybe im missing something??

[john]

Is the webpage you are working on part of a MS Frontpage Site? As I have just tried here and its greyed out when its not part of a complete site, IE you have just got that one page open rather than the complete site open as it auto creates its databse etc..

Also have you got it set on complete for the Authoring options? To check this in FP 2003 at the bottom corner it should say Complete, if it says Defualt, None or Custom that may also cause it. To change it double click the place where it says what you are running and change it to Complete and then try that.

[papakura]

Hello John

thanks for your excellent replies. I will look first thing in the morning when I get to work as I do not have the software on this computer. Pleas stick with me!!
Thanks

[laticsfanatic]

Hello John

thanks for your excellent replies. I will look first thing in the morning when I get to work as I do not have the software on this computer. Pleas stick with me!!
Thanks

To connect your form to a database. right click inside the form. you will get the form properties window. select send to database and then click options. you now have the choice either connect to a database you already have created or you have the option to create one.

Clck create and frontpage creates you a database for your results. then just follow the on screen directions.