database records

[Mike]

Hey everyone,

I've constructed a Frontpage site and have an Access
database getting the results. Is there a way to display
the <auto number> from the database? It's a questionnaire
website and I want to use the auto number as the
participants record number...so how can I display this
back to the person once they click submit?

I've tried having the wizard setup a display on the page
following the submit but it has never been able to
function.

Thanks

Mike

 

[Jim Buyens]

There are some techniques for "hacking" into the code
FrontPage generates, but these sorts of fixes tend to
disappear when you reconfigure the form, run recalculate
hyperlinks, or reinstall FrontPage. So instead, I
generally write my own ASP code as described in

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)
|/---------------------------------------------------
*----------------------------------------------------

 

[Kathleen Anderson [MVP - FP]]

http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Autonumber