how do i create a web form that emails AND saves to a database?

[Guest]

I have a web form that currently emails the data to me. I need to have it
save to an Access database that I display the results from. I have other
forms that save data to Access databases, so I know how to make all that
work, but is there a way to make one form do both? Or - is it possible to
make Access send me an email with the data every time a new record is entered?

 

[Thomas A. Rowe]

See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Guest]

Thank You very much. Just what I needed.

See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

I have a web form that currently emails the data to me. I need to have it
save to an Access database that I display the results from. I have other
forms that save data to Access databases, so I know how to make all that
work, but is there a way to make one form do both? Or - is it possible to
make Access send me an email with the data every time a new record is entered?

 

[Randy Morgan]

I'm using the paper written by Jim to send form results to both an email
address and a database. I use FP2003.

Not all the fields in my form are required, or at least I don't want
them to be. If I leave a field blank and submit the form I get an error
saying that (for example) Results.Address1 cannot be a zero-length
field. When I populate the field in the form it goes through fine.

Is there a way to modify the code to allow a blank field?

Thanks,
Randy Morgan

Thank You very much. Just what I needed.

:

See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

I have a web form that currently emails the data to me. I need to have it
save to an Access database that I display the results from. I have other
forms that save data to Access databases, so I know how to make all that
work, but is there a way to make one form do both? Or - is it possible to
make Access send me an email with the data every time a new record is entered?

 

[Randy Morgan]

The actual error shown is:

Microsoft JET Database Engine error '80004005'

Field 'Results.FirstName' cannot be a zero-length string.

/dev/registration-c.asp, line 118

Randy Morgan

I'm using the paper written by Jim to send form results to both an email
address and a database. I use FP2003.

Not all the fields in my form are required, or at least I don't want
them to be. If I leave a field blank and submit the form I get an error
saying that (for example) Results.Address1 cannot be a zero-length
field. When I populate the field in the form it goes through fine.

Is there a way to modify the code to allow a blank field?

Thanks,
Randy Morgan

Thank You very much. Just what I needed.

:

See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================


I have a web form that currently emails the data to me. I need to
have it
save to an Access database that I display the results from. I have
other
forms that save data to Access databases, so I know how to make all
that
work, but is there a way to make one form do both? Or - is it
possible to
make Access send me an email with the data every time a new record
is entered?

 

[Thomas A. Rowe]

You would have to learn to hand code your ASP/VBScript to test for blank input and then exclude the
field from the email.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

I'm using the paper written by Jim to send form results to both an email address and a database.
I use FP2003.

Not all the fields in my form are required, or at least I don't want them to be. If I leave a
field blank and submit the form I get an error saying that (for example) Results.Address1 cannot
be a zero-length field. When I populate the field in the form it goes through fine.

Is there a way to modify the code to allow a blank field?

Thanks,
Randy Morgan

Thank You very much. Just what I needed.

:

See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================


I have a web form that currently emails the data to me. I need to have it
save to an Access database that I display the results from. I have other
forms that save data to Access databases, so I know how to make all that
work, but is there a way to make one form do both? Or - is it possible to
make Access send me an email with the data every time a new record is entered?

 

[Thomas A. Rowe]

You will have to modify your database field to not require data.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

The actual error shown is:

Microsoft JET Database Engine error '80004005'

Field 'Results.FirstName' cannot be a zero-length string.

/dev/registration-c.asp, line 118

Randy Morgan

I'm using the paper written by Jim to send form results to both an email address and a database.
I use FP2003.

Not all the fields in my form are required, or at least I don't want them to be. If I leave a
field blank and submit the form I get an error saying that (for example) Results.Address1 cannot
be a zero-length field. When I populate the field in the form it goes through fine.

Is there a way to modify the code to allow a blank field?

Thanks,
Randy Morgan

Thank You very much. Just what I needed.

:


See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================


I have a web form that currently emails the data to me. I need to have it
save to an Access database that I display the results from. I have other
forms that save data to Access databases, so I know how to make all that
work, but is there a way to make one form do both? Or - is it possible to
make Access send me an email with the data every time a new record is entered?

 

[Randy Morgan]

That's interesting, because I don't think I set it up to require data.
The database is currently in use and written to by a form, all of which
was generated by FP. In the current incarnation the form can save a
blank value to the database, but it's not working when I use the code
from the white paper.

There may also be another problem, since the e-mail does not get sent
even when all the fields are populated and the database gets updated as
it should.

Thanks,
Randy Morgan