Updating Entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that allows customers to input personal data. My problem is
that when a user wants to update his info (such as his phone number) he goes
back and fills out the form again. What I get now is 2 entries from this user
with different info. What I want is 1 entry with updated info. Is it possible
to tell 1 column ( such as email address) that if it is duplicated to just
overwrite the other fields in this entry?
 
Do you not have a primary key defined for the table that stores these data?
You can use a primary key to avoid duplicate data entry.
 
A primary key stops duplicate entries ...yes. But it also stops the other
fields in this entry from being updated. What I need is for the duplicate to
be recognized and then update instead of just blocking it completly. The new
entry will contain new or updated info which I do not want blocked nor do I
want it in a new entry. I want it to update the original fields in the entry.
 
What I am suggesting is that you could include the primary key value in the
form that the user fills out, and that will tell the form that the
information is editing, not new.

Perhaps I am not understanding the scenario for how this information is
being generated/submitted. Do users fill out a "blank" form for all
situations, and then it's submitted in some way and you're trying to
identify if the information is new or existing?
--

Ken Snell
<MS ACCESS MVP>
 
Yes, I am sorry if I didnt make it clear. The user fills out a blank form on
my web page. (asp) Then later if any user needs to update his info for any
reason, he goes back and fills out the same form with new info in maybe 1 or
2 fields. What I get is a new entry instead of 1 updated entry.
 
How do you currently take the data from the form and put it into the
database? We should be able to modify that process as you wish.
 
The data base was created for me by frontpage when I created the asp page and
the data is sent directly to the database (which is stored online) from the
asp page.
 
I have not worked with FrontPage to do these types of things, so I cannot
provide a specific suggestion here. In whatever code has been created in the
FrontPage page, it should be possible to test if the data are for an
existing person and to update instead of append. But, you'll need to post
the VB code that is being used in the asp page to do the addition of the
data to the database.
 
I am not sure if i have this right but i think this is the code that
frontpage created in the asp to govern the form. If so is there something I
can do with this?

<form method="POST" action="--WEBBOT-SELF--" onSubmit="">
<!--webbot bot="SaveDatabase" suggestedext="asp"
u-asp-include-url="_fpclass/fpdbform.inc" s-dataconnection="sign_up"
s-recordsource="Results" u-database-url="fpdb/sign_up.mdb"
u-confirmation-url="sign_up_confirmation.htm" s-form-fields="Royal\ Vegas\
Screen\ Name Royal\ Vegas\ prvr\ # First\ Name City Email\ Address Last\ Name
Country Province/State" s-form-dbfields="Royal\ Vegas\ Screen\ Name Royal\
Vegas\ prvr\ # First\ Name City Email\ Address Last\ Name Country
Province/State" startspan --><input TYPE="hidden" NAME="VTI-GROUP"
VALUE="0"><!--#include file="_fpclass/fpdbform.inc"--><!--webbot
bot="SaveDatabase" endspan i-checksum="40548" -->
 
I'm afraid I just don't know enough about FrontPage and asp pages. This
script seems to be running some "built-in" feature that adds the record to
your database.

May I suggest that you post your question in a front page newsgroup (such as
microsoft.public.frontpage.programming)? I'm betting that some MVPs there
can help you much more effectively than I. I'm sorry that I can't help you
directly!
 
Thank you anyway

Ken Snell said:
I'm afraid I just don't know enough about FrontPage and asp pages. This
script seems to be running some "built-in" feature that adds the record to
your database.

May I suggest that you post your question in a front page newsgroup (such as
microsoft.public.frontpage.programming)? I'm betting that some MVPs there
can help you much more effectively than I. I'm sorry that I can't help you
directly!
Click to expand...
 
Back
Top