Changing the same access database record with webform?

[sithlord70]

I posted a request the other day asking how I can use a webform to
update the same record in an access database and then have a database
results page display just that record. I found a couple of things on
the web but they were confusing. Currently my webform works fine but
simply adds a new record to the database each time I submit the data.
What I want to do is take that very same webform, which I named
submission.asp, and instead tell it to update record #1 rather then add
a record each time. I already figured out to how to get the database
results page, which I named results.asp, to display just record #1
rather then all the records so that part I figured out. Currently the
database an autonumber field called key set as the primary key and then
a few text fields called specdes1, specdes2 and specdes3. My webform
has fields corresponding to those in the database. How can I tell my
webform to keep submitting to same record number rather then add a new
record each time. What do I need to add to my webform to make it submit
and overwrite the data in record #1of the database each time.

Thanks in advance,
Adam

 

[Stefan B Rusynko]

Try http://home.att.net/~codelibrary/FrontPage/drw.htm

--

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I posted a request the other day asking how I can use a webform to
| update the same record in an access database and then have a database
| results page display just that record. I found a couple of things on
| the web but they were confusing. Currently my webform works fine but
| simply adds a new record to the database each time I submit the data.
| What I want to do is take that very same webform, which I named
| submission.asp, and instead tell it to update record #1 rather then add
| a record each time. I already figured out to how to get the database
| results page, which I named results.asp, to display just record #1
| rather then all the records so that part I figured out. Currently the
| database an autonumber field called key set as the primary key and then
| a few text fields called specdes1, specdes2 and specdes3. My webform
| has fields corresponding to those in the database. How can I tell my
| webform to keep submitting to same record number rather then add a new
| record each time. What do I need to add to my webform to make it submit
| and overwrite the data in record #1of the database each time.
|
| Thanks in advance,
| Adam
|

 

[Stefan B Rusynko]

Suggest you ask in a WSS newsgroup
news://msnews.microsoft.com/microsoft.public.sharepoint.windowsservices


--

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I posted a request the other day asking how I can use a webform to
| update the same record in an access database and then have a database
| results page display just that record. I found a couple of things on
| the web but they were confusing. Currently my webform works fine but
| simply adds a new record to the database each time I submit the data.
| What I want to do is take that very same webform, which I named
| submission.asp, and instead tell it to update record #1 rather then add
| a record each time. I already figured out to how to get the database
| results page, which I named results.asp, to display just record #1
| rather then all the records so that part I figured out. Currently the
| database an autonumber field called key set as the primary key and then
| a few text fields called specdes1, specdes2 and specdes3. My webform
| has fields corresponding to those in the database. How can I tell my
| webform to keep submitting to same record number rather then add a new
| record each time. What do I need to add to my webform to make it submit
| and overwrite the data in record #1of the database each time.
|
| Thanks in advance,
| Adam
|