Creating a Form where submitting information goes to a Access Data

I am trying to figure out a way to have a Form created in Frontpage, so when
clicking submit the information in the form is sent directly to a access
database. I know you can creat a FP database. however it creates a form in
ASP. I have no knowledge of this and can not get the form to display
activley. Can help me. As an example this is what the fom would entail..
Account, Location, Sub location, Issue, Issue Number. The database would
have the same fields with the same title.

Re: Creating a Form where submitting information goes to a Access Data

Have you verified that the server your web site is on supports ASP, Access
Databases and the FrontPage Server Extensions?

If so, this may help:
http://www.brainbell.com/tutorials/ms-office/FrontPage_2003/ Saving_Form_Results_To_A_Database.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


"gwtechie72" wrote in message
news:3B1CE2C0-3A52-4DB0-BC87-B6FF6EB54368@microsoft.com...
>I am trying to figure out a way to have a Form created in Frontpage, so
>when
> clicking submit the information in the form is sent directly to a access
> database. I know you can creat a FP database. however it creates a form in
> ASP. I have no knowledge of this and can not get the form to display
> activley. Can help me. As an example this is what the fom would entail..
> Account, Location, Sub location, Issue, Issue Number. The database would
> have the same fields with the same title.

Re: Creating a Form where submitting information goes to a Access Data

You can't do this without ASP. Just use FPs database tools for this.
FP will generate the necessary ASP for you.
If you want finer control you need to learn ASP.

Regards Jens Peter Karlsen.

On Sat, 29 Mar 2008 11:36:00 -0700, gwtechie72
wrote:

>I am trying to figure out a way to have a Form created in Frontpage, so when
>clicking submit the information in the form is sent directly to a access
>database. I know you can creat a FP database. however it creates a form in
>ASP. I have no knowledge of this and can not get the form to display
>activley. Can help me. As an example this is what the fom would entail..
>Account, Location, Sub location, Issue, Issue Number. The database would
>have the same fields with the same title.

Re: Creating a Form where submitting information goes to a Access

I have tried the FP Database tool. It creates what I want, but when I take
the index file that that is linked to the form. The form will not come up.
just shows the source coding.

"Jens Peter Karlsen" wrote:

> You can't do this without ASP. Just use FPs database tools for this.
> FP will generate the necessary ASP for you.
> If you want finer control you need to learn ASP.
>
> Regards Jens Peter Karlsen.
>
> On Sat, 29 Mar 2008 11:36:00 -0700, gwtechie72
> wrote:
>
> >I am trying to figure out a way to have a Form created in Frontpage, so when
> >clicking submit the information in the form is sent directly to a access
> >database. I know you can creat a FP database. however it creates a form in
> >ASP. I have no knowledge of this and can not get the form to display
> >activley. Can help me. As an example this is what the fom would entail..
> >Account, Location, Sub location, Issue, Issue Number. The database would
> >have the same fields with the same title.
>

Re: Creating a Form where submitting information goes to a Access

Then the Server doesn't support ASP.
You must Publish the Web to a server that Supports ASP.

Regards Jens Peter Karlsen.

On Sat, 29 Mar 2008 12:05:00 -0700, gwtechie72
wrote:

>I have tried the FP Database tool. It creates what I want, but when I take
>the index file that that is linked to the form. The form will not come up.
>just shows the source coding.
>
>"Jens Peter Karlsen" wrote:
>
>> You can't do this without ASP. Just use FPs database tools for this.
>> FP will generate the necessary ASP for you.
>> If you want finer control you need to learn ASP.
>>
>> Regards Jens Peter Karlsen.
>>
>> On Sat, 29 Mar 2008 11:36:00 -0700, gwtechie72
>> wrote:
>>
>> >I am trying to figure out a way to have a Form created in Frontpage, so when
>> >clicking submit the information in the form is sent directly to a access
>> >database. I know you can creat a FP database. however it creates a form in
>> >ASP. I have no knowledge of this and can not get the form to display
>> >activley. Can help me. As an example this is what the fom would entail..
>> >Account, Location, Sub location, Issue, Issue Number. The database would
>> >have the same fields with the same title.
>>

Re: Creating a Form where submitting information goes to a Access

If you don't have asp then get the form to save your private folder as a csv
file and import this in to an access DB off-line.

Of course you will need to run this though an update query (to amend the
formats) prior to an append (which you can normally do with an asp form) but
it's only one extra line (well 3 really normally) lines of vba so it will not
take long.


--
Wayne
Manchester, England.



"Jens Peter Karlsen" wrote:

> Then the Server doesn't support ASP.
> You must Publish the Web to a server that Supports ASP.
>
> Regards Jens Peter Karlsen.
>
> On Sat, 29 Mar 2008 12:05:00 -0700, gwtechie72
> wrote:
>
> >I have tried the FP Database tool. It creates what I want, but when I take
> >the index file that that is linked to the form. The form will not come up.
> >just shows the source coding.
> >
> >"Jens Peter Karlsen" wrote:
> >
> >> You can't do this without ASP. Just use FPs database tools for this.
> >> FP will generate the necessary ASP for you.
> >> If you want finer control you need to learn ASP.
> >>
> >> Regards Jens Peter Karlsen.
> >>
> >> On Sat, 29 Mar 2008 11:36:00 -0700, gwtechie72
> >> wrote:
> >>
> >> >I am trying to figure out a way to have a Form created in Frontpage, so when
> >> >clicking submit the information in the form is sent directly to a access
> >> >database. I know you can creat a FP database. however it creates a form in
> >> >ASP. I have no knowledge of this and can not get the form to display
> >> >activley. Can help me. As an example this is what the fom would entail..
> >> >Account, Location, Sub location, Issue, Issue Number. The database would
> >> >have the same fields with the same title.
> >>
>