Setting a limitation of record entry from a form (data entry)

[arnelgp]

try again please.

 

[sashi126]

try again please.

Hey buddy, thanks alot for the help. i really appreciate it.
It is a great help from you...i won't forget you for sure...

U r just "WoW"....

 

[sashi126]

hi arnelgp

I would like to ask if you have some idea on how to eliminate duplication of the survey done from the same PC or IP address.
Maybe you have a better idea on this?

Hope to see your reply on this.

Perhaps you can reach me to my email sashi126@gmail.com

 

[arnelgp]

first you must have a table that will hold the ip of the current user of your db.
the idea is to check first this table for a particular ip, if it exist, then obviously survey has already been done on that pc. if not complete the survey questionaire first, and before closing the form save the ip of that pc to the table.
if your ip in your workplace is static then theres no problem, but if dynamic, youll also need to save the mac address of the pc.

very simple!

 

[sashi126]

do u have any idea how to retrieve the IP/MAC address from our PC automatically and store it into the table?

Man, I am so new to this coding..maybe you can give me some idea from the DB i sent to u?

 

[arnelgp]

ok, well try, be back soon.

 

[arnelgp]

here try this:

 

[sashi126]

omg! I din know we can do such thing with this...i am learning alot along the way from u
How did u learn all these?

 

[arnelgp]

through books, internet, forums. in time, you'll be able to help others also. just remember: learn by Heart and not only by mind.

 

[sashi126]

seriously i do admire ur humbleness...u willing to help...trully speechless

 

[arnelgp]

if you are unable to follow the code, search the internet or best invest on books.
your welcome bro.