Limit user to one submit

[Guest]

Hi, I am running a little voting contest. With 5 sets of radio buttons, email and then submit in the form. The information all goes to a .mdb Access 2003 (Front Page 2000)

What I would like to do is make it so a person can only vote (hit submit) once. If they try to "vote" again they would get a message that they have already voted in the contest.

Also is there anyway my DB can verify the email address they enter and if not valid redirct them to please enter a valid email address?

I just got this software 2 days ago and don't know a thing about it. I am a button pusher not a programmer, so I would appreciate a step by step explanation. I think what I need to do is place a cookie in their computer, but don't know how to do that.
You can view the form I am speaking of at: http://www.horseplaycentral.com/PHnewfoals2004voting.asp

Thank you in advance for your help.

 

[Michel Walsh]

Hi,


To allow just one record per "id" in a table with two fields, id and
VoteForWho, in the table design, add an index on "id" so that it does not
allow "duplicated values". You won't be able to add two same value under
"id".


I do not know of any easy solution to know if an address is valid or not.



Hoping it may help,
Vanderghast, Access MVP

Hi, I am running a little voting contest. With 5 sets of radio buttons,

email and then submit in the form. The information all goes to a .mdb
Access 2003 (Front Page 2000)

What I would like to do is make it so a person can only vote (hit submit)

once. If they try to "vote" again they would get a message that they have
already voted in the contest.

Also is there anyway my DB can verify the email address they enter and if

not valid redirct them to please enter a valid email address?

I just got this software 2 days ago and don't know a thing about it. I am

a button pusher not a programmer, so I would appreciate a step by step
explanation. I think what I need to do is place a cookie in their computer,
but don't know how to do that.