Submit and Copy Form

G

Guest

I have created a simple form in Frontpage with the default buttons 'Submit' and 'Reset'. Clicking on 'Submit' will submit to an Access Database and then take the user to the basic confirmation page. I would like to add another button 'Copy' which would submit the data to the database as normal, but then open up the form again with the next record number. Is there an easy way to do this?
 
J

Jim Buyens

-----Original Message-----
I have created a simple form in Frontpage with the
default buttons 'Submit' and 'Reset'. Clicking
on 'Submit' will submit to an Access Database and then
take the user to the basic confirmation page. I would
like to add another button 'Copy' which would submit the
data to the database as normal, but then open up the form
again with the next record number. Is there an easy way
to do this?
Click to expand...

Not really. However, the visitor can just click the Back
button and return to the input form.

I suppose you could create a custom confirmation page, and
code the body tag

<body onload="history.back()">

This programatically clicks the Back button as soon as the
page appears. But then, the visitor never receives
confirmation that the Web server sucessfully processed the
form.

If you want the kind of page where the confirmation
message appears on the input form, you'd have to program
it yourself in ASP or ASP.NET.

For more information on these topics, browse:

Customizing Form Confirmation Pages
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=41

and

Saving Form Data in a Database
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=44

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
A

Andrew Murray

I suppose you could do it using the meta refresh tag, or write code in javascript
to refresh the page to return you to the page with the form. If you have a
'thank you for your submission..." page, this could come up as normal, then you
could just redirect using the above methods back to your form page.

Regarding the record number...I don't know how you'd do this ....perhaps a script
(ASP?) to read the last record, then increment the record number by one, and then
give you the blank form with a new record number.

Or just change it maybe with
 

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

Similar Threads

Form Auto Submit? 1
Reset after Submit 4
Submit form without button 2
Help needed for Frontpage form 2
Limitation in Number of Fields ... 1
Submit-->'Page Not Found' 7
Submitable Form 1
form submit more than once 4

Top