Results 1 to 2 of 2

Thread: Vote

  1. #1
    Join Date
    Dec 2005
    Posts
    11

    Unanswered: Vote

    Hi,

    I have a NEW USER login page with name,address,phone,region etc. they are assigned an auto id.
    Wondering how i can save their details to my voters table without them seeing all other voters?



    Also
    How do i stop a user from pressing the same command button twice?

    I have a voting application and it's one vote per user.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You could set the dataentry property to true for your new user form. That will hide all existing data.

    There are a couple ways to go about preventing duplicates. One is to store the vote in the voters table directly. If you only have one vote per user, this makes sense. If you want users to vote on a variety of topics, but only once per topic, then votes should be stored in a seperate table. In this scenario, you do have to intervene to make sure there are no duplicates. One method is to simply disable the command button after it's been pressed. A more reliable method is to do some checking in the before_update event of the form to see if the vote already exists.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •