Creating a Form where submitting information goes to a Access Data

G

gwtechie72

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

Kathleen Anderson

J

Jens Peter Karlsen

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

gwtechie72

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

Jens Peter Karlsen

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

Regards Jens Peter Karlsen.
 
W

Wayne-I-M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top