Form to Database

[Allen]

I want to set up a table with a form that will put the
name of the person in the table after they hit submit.
I'm very new to all this. The page I'm using now, they
fill in their info then it emails to me then I have to
load it into the table. It's at
http://www.rainbowsendemmaus.com/prayer_vigil2.htm I
would like it to look something like this
http://www.findlayemmaus.org/prayervigil.php3 . Know
it can be done but like I say am new to all this and am
learning as I go. Any help would be appreciated, Allen

 

[Jim Buyens]

-----Original Message-----

I want to set up a table with a form that will put the
name of the person in the table after they hit submit.
I'm very new to all this. The page I'm using now, they
fill in their info then it emails to me then I have to
load it into the table. It's at
http://www.rainbowsendemmaus.com/prayer_vigil2.htm I
would like it to look something like this
http://www.findlayemmaus.org/prayervigil.php3 . Know
it can be done but like I say am new to all this and am
learning as I go. Any help would be appreciated, Allen

In FrontPage, right-click the form, choose Form
Properties, and change Send To E-Mail Address to Send To
Database.

Then, click the Options button and specify the database
you want.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Allen]

-----Original Message-----

In FrontPage, right-click the form, choose Form
Properties, and change Send To E-Mail Address to Send To
Database.

Then, click the Options button and specify the database
you want.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


.
Thanks Jim, I'm still a little confused. I'm using FP

2002. I guess I need to first set up a data base then
send the info to the data base? Can I change the table I
have set up to a database? Sorry to be a lot of
trouble. Am really new to this.

 

[Jim Buyens]

Thanks Jim, I'm still a little confused. I'm using FP
2002. I guess I need to first set up a data base then
send the info to the data base? Can I change the table I
have set up to a database? Sorry to be a lot of
trouble. Am really new to this.

You can do that if you want. You would then use the
Saved Fields of the Options For Saving Results To Database
dialog box to match up the form fields with database fields.

Alternatively, you can have FrontPage create the database
for you. In this scenario, you create the form first, taking
care to give each form field a meaningful name that:

o Isn't a reserved word in Access (i.e. don't use "date".)
o Doesn't contain any spaces.
o Doesn't contain any special characters.

Next:
1. Save the form.
2. Right-click the form and choose Form Properties.
3. Select Send To Database.
4. Click Options.
5. Click the Create Database button.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

select Save