PRINT FORM Command.

I currently have an extensive form that is filled out by clients and sent to
me access database on the web server. That part of the equation seems to be
working OK. However, Does anyone know the answers to the following questions?:

1. How do I get my .asp script that generates my form to email me when
someone has finished completing the form? (Currently it just submits the
info to the datatbase and I am not informed that something new was added to
the database)

2. I currently download the database each time from the server and onto my
computer so that I can use Crystal Reports to pull the data into my template
form. Does anyone know an easier way to do this? Maybe the PRINT FORM
command?

Any help would be appreciated. I have hit a dead end with ideas to have
this information from the online form sent to the database.... pre-fill into
my form to be printed out on a printer.

Thanks. Pete

You would have to learn to custom write a ASP form handler to process the form and work with a ASP
email component to actually send the emails. You would need to check with your web host to determine
which ASP email component they have available.

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

"PETE" <PETE@discussions.microsoft.com> wrote in message
news:415800C3-62D1-4931-8429-DB06C05D4486@microsoft.com...
>I currently have an extensive form that is filled out by clients and sent to
> me access database on the web server. That part of the equation seems to be
> working OK. However, Does anyone know the answers to the following questions?:
>
> 1. How do I get my .asp script that generates my form to email me when
> someone has finished completing the form? (Currently it just submits the
> info to the datatbase and I am not informed that something new was added to
> the database)
>
> 2. I currently download the database each time from the server and onto my
> computer so that I can use Crystal Reports to pull the data into my template
> form. Does anyone know an easier way to do this? Maybe the PRINT FORM
> command?
>
> Any help would be appreciated. I have hit a dead end with ideas to have
> this information from the online form sent to the database.... pre-fill into
> my form to be printed out on a printer.
>
> Thanks. Pete

Answer to (1) - you can only have one or the other if using the frontpage
form handler : a) send it to a database or b) send it to your email....

option c) use an asp script that is written to do both or a server side
script for your particular server/system.



Answer to (2): Regarding your reports you need, have you tried the Database
results wizard in frontpage? that just allows you to create queries and
extra info as you wish - it allows custom queries as well as using those
generated by the results wizard. I.e. sql query knowledge necessary.

I assume you have an Access database? Do you have MS Access? If so, then
use it to create your reports.


"PETE" <PETE@discussions.microsoft.com> wrote in message
news:415800C3-62D1-4931-8429-DB06C05D4486@microsoft.com...
>I currently have an extensive form that is filled out by clients and sent
>to
> me access database on the web server. That part of the equation seems to
> be
> working OK. However, Does anyone know the answers to the following
> questions?:
>
> 1. How do I get my .asp script that generates my form to email me when
> someone has finished completing the form? (Currently it just submits the
> info to the datatbase and I am not informed that something new was added
> to
> the database)
>
> 2. I currently download the database each time from the server and onto my
> computer so that I can use Crystal Reports to pull the data into my
> template
> form. Does anyone know an easier way to do this? Maybe the PRINT FORM
> command?
>
> Any help would be appreciated. I have hit a dead end with ideas to have
> this information from the online form sent to the database.... pre-fill
> into
> my form to be printed out on a printer.
>
> Thanks. Pete

Or if using the DBR wizards and not hand coding the DB update see
http://support.microsoft.com/defaul...kb;en-us;275251

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Thomas A. Rowe" <tarowe@mvps.org> wrote in message news:OTzbEP3gFHA.1612@TK2MSFTNGP12.phx.gbl...
| You would have to learn to custom write a ASP form handler to process the form and work with a ASP
| email component to actually send the emails. You would need to check with your web host to determine
| which ASP email component they have available.
|
| --
| ==============================================
| 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.
| ==============================================
|
| "PETE" <PETE@discussions.microsoft.com> wrote in message
| news:415800C3-62D1-4931-8429-DB06C05D4486@microsoft.com...
| >I currently have an extensive form that is filled out by clients and sent to
| > me access database on the web server. That part of the equation seems to be
| > working OK. However, Does anyone know the answers to the following questions?:
| >
| > 1. How do I get my .asp script that generates my form to email me when
| > someone has finished completing the form? (Currently it just submits the
| > info to the datatbase and I am not informed that something new was added to
| > the database)
| >
| > 2. I currently download the database each time from the server and onto my
| > computer so that I can use Crystal Reports to pull the data into my template
| > form. Does anyone know an easier way to do this? Maybe the PRINT FORM
| > command?
| >
| > Any help would be appreciated. I have hit a dead end with ideas to have
| > this information from the online form sent to the database.... pre-fill into
| > my form to be printed out on a printer.
| >
| > Thanks. Pete
|
|

Thank you all very much for the help.

"Andrew Murray" wrote:

> Answer to (1) - you can only have one or the other if using the frontpage
> form handler : a) send it to a database or b) send it to your email....
>
> option c) use an asp script that is written to do both or a server side
> script for your particular server/system.
>
>
>
> Answer to (2): Regarding your reports you need, have you tried the Database
> results wizard in frontpage? that just allows you to create queries and
> extra info as you wish - it allows custom queries as well as using those
> generated by the results wizard. I.e. sql query knowledge necessary.
>
> I assume you have an Access database? Do you have MS Access? If so, then
> use it to create your reports.
>
>
> "PETE" <PETE@discussions.microsoft.com> wrote in message
> news:415800C3-62D1-4931-8429-DB06C05D4486@microsoft.com...
> >I currently have an extensive form that is filled out by clients and sent
> >to
> > me access database on the web server. That part of the equation seems to
> > be
> > working OK. However, Does anyone know the answers to the following
> > questions?:
> >
> > 1. How do I get my .asp script that generates my form to email me when
> > someone has finished completing the form? (Currently it just submits the
> > info to the datatbase and I am not informed that something new was added
> > to
> > the database)
> >
> > 2. I currently download the database each time from the server and onto my
> > computer so that I can use Crystal Reports to pull the data into my
> > template
> > form. Does anyone know an easier way to do this? Maybe the PRINT FORM
> > command?
> >
> > Any help would be appreciated. I have hit a dead end with ideas to have
> > this information from the online form sent to the database.... pre-fill
> > into
> > my form to be printed out on a printer.
> >
> > Thanks. Pete
>
>
>