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?

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.
==============================================

"Guido" <(E-Mail Removed)> wrote in message
news:F6624854-7C9D-4DF4-971D-(E-Mail Removed)...
>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?

Thank You very much. Just what I needed.

"Thomas A. Rowe" wrote:

> 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.
> ==============================================
>
> "Guido" <(E-Mail Removed)> wrote in message
> news:F6624854-7C9D-4DF4-971D-(E-Mail Removed)...
> >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?
>
>
>

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

Guido wrote:
> Thank You very much. Just what I needed.
>
> "Thomas A. Rowe" wrote:
>
>
>>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.
>>==============================================
>>
>>"Guido" <(E-Mail Removed)> wrote in message
>>news:F6624854-7C9D-4DF4-971D-(E-Mail Removed)...
>>
>>>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?
>>
>>
>>

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

Randy Morgan wrote:
> 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
>
> Guido wrote:
>
>> Thank You very much. Just what I needed.
>>
>> "Thomas A. Rowe" wrote:
>>
>>
>>> 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.
>>> ==============================================
>>>
>>> "Guido" <(E-Mail Removed)> wrote in message
>>> news:F6624854-7C9D-4DF4-971D-(E-Mail Removed)...
>>>
>>>> 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?
>>>
>>>
>>>
>>>

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.
==============================================

"Randy Morgan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> Guido wrote:
>> Thank You very much. Just what I needed.
>>
>> "Thomas A. Rowe" wrote:
>>
>>
>>>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.
>>>==============================================
>>>
>>>"Guido" <(E-Mail Removed)> wrote in message
>>>news:F6624854-7C9D-4DF4-971D-(E-Mail Removed)...
>>>
>>>>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?
>>>
>>>
>>>

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.
==============================================

"Randy Morgan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> Randy Morgan wrote:
>> 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
>>
>> Guido wrote:
>>
>>> Thank You very much. Just what I needed.
>>>
>>> "Thomas A. Rowe" wrote:
>>>
>>>
>>>> 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.
>>>> ==============================================
>>>>
>>>> "Guido" <(E-Mail Removed)> wrote in message
>>>> news:F6624854-7C9D-4DF4-971D-(E-Mail Removed)...
>>>>
>>>>> 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?
>>>>
>>>>
>>>>
>>>>

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

Thomas A. Rowe wrote:
> You will have to modify your database field to not require data.
>