Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access DB for election poll

Discussion in 'Information Technology' started by Sokan33, Jul 28, 2006.

  1. Sokan33

    Sokan33
    Expand Collapse
    Guest

    I was asked to conducting an election in my church and would like to design
    an Access DB for that purpose. Can anyone point me in a direction on how to
    go about this? Thanking you all for your assistance!
     
  2. Loading...


  3. tina

    tina
    Expand Collapse
    Guest

    a survey database might do the trick, perhaps with a little tweaking. take a
    look at MVP Duane Hookom's AtYourSurvey database, at
    http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

    hth


    "Sokan33" <Sokan33@discussions.microsoft.com> wrote in message
    news:867CDB16-743D-40CB-9914-8F5D01251923@microsoft.com...
    > I was asked to conducting an election in my church and would like to

    design
    > an Access DB for that purpose. Can anyone point me in a direction on how

    to
    > go about this? Thanking you all for your assistance!
     
  4. Sokan33

    Sokan33
    Expand Collapse
    Guest

    RE: Vote Counting Access DB

    I changed the original topic of this tread so my intention could be clearer.
    I would like to design an Access 2K3 Db for use by my church. Any assistance
    will be highly appreciated. I am a beginner.

    Thanks

    "Sokan33" wrote:

    > I was asked to conducting an election in my church and would like to design
    > an Access DB for that purpose. Can anyone point me in a direction on how to
    > go about this? Thanking you all for your assistance!
     
  5. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    TblCandidate
    CandidateID
    FirstName
    MI
    LastName

    TblOffice
    OfficeID
    Office
    Term (Years)

    TblCandidateRunningForOffice
    CandidateRunningForOfficeID
    OfficeID
    CandidateID
    ElectionDate
    NumberOfVotes

    --
    PC Datasheet
    Your Resource For Help With Access, Excel And Word Applications
    Over 1175 users have come to me from the newsgroups requesting help
    resource@pcdatasheet.com


    "Sokan33" <Sokan33@discussions.microsoft.com> wrote in message
    news:867CDB16-743D-40CB-9914-8F5D01251923@microsoft.com...
    >I was asked to conducting an election in my church and would like to design
    > an Access DB for that purpose. Can anyone point me in a direction on how
    > to
    > go about this? Thanking you all for your assistance!
     
  6. StopThisAdvertising

    StopThisAdvertising
    Expand Collapse
    Guest

    "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht news:n9%9g.2719$y4.2257@newsread2.news.pas.earthlink.net...

    --
    > PC Datasheet
    > Your Resource For Help With Access, Excel And Word Applications 'Resource ????
    > Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
    > resource@pcdatasheet.com



    To Steve:
    You still don't get it? You never will?
    ==> No-one wants your advertising/job hunting here!
    Over 850 !! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

    To the original poster:
    Most people here have a common belief that the newsgroups are for *free exchange of information*.
    But Steve is a notorious job hunter in these groups, always trying to sell his services.
    And he is known here as a shameless liar with no ethics at all.

    Before you intend to do business with him look at:
    http://home.tiscali.nl/arracom/whoissteve.html

    Arno R
     
  7. Sokan33

    Sokan33
    Expand Collapse
    Guest

    Thanks for your suggestions. But after building these tables what's next.
    Would appreciate further suggestion on how to query and report against the
    tables. Your free input will be regarded and appreciated!

    "PC Datasheet" wrote:

    > TblCandidate
    > CandidateID
    > FirstName
    > MI
    > LastName
    >
    > TblOffice
    > OfficeID
    > Office
    > Term (Years)
    >
    > TblCandidateRunningForOffice
    > CandidateRunningForOfficeID
    > OfficeID
    > CandidateID
    > ElectionDate
    > NumberOfVotes
    >
    > --
    > PC Datasheet
    > Your Resource For Help With Access, Excel And Word Applications
    > Over 1175 users have come to me from the newsgroups requesting help
    > resource@pcdatasheet.com
    >
    >
    > "Sokan33" <Sokan33@discussions.microsoft.com> wrote in message
    > news:867CDB16-743D-40CB-9914-8F5D01251923@microsoft.com...
    > >I was asked to conducting an election in my church and would like to design
    > > an Access DB for that purpose. Can anyone point me in a direction on how
    > > to
    > > go about this? Thanking you all for your assistance!

    >
    >
    >
     
  8. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    1. Open TblCandidateRunningForOffice and set the default value for
    NumberOfVotes to 0.
    2. Build a simple data entry form based on TblCandidate to enter the
    candidates.
    3. Build a simple data entry form based on TblOffice for entering the
    offices.
    ** You can use the form wizard to create the two forms in 1 and 2
    4. Build a continuous data entry form based on
    TblCandidateRunningForOffice.
    a) Use a combobox based on TblOffice to enter OfficeID
    b) Use a combobox based on TblCandidate to enter Candidate.
    c) Create an unbound textbox named EnterElectionDate in the form
    header. Set the form up to force the user to enter EnterElectionDate first.
    d) Select ElectionDate, go to properties, go to the Data tab, set
    Enabled to No and Locked to Yes.
    e) Select NumberOfVotes, go to properties, go to the Data tab, set
    Enabled to No and Locked to Yes.
    f) Put the following code in the AfterUpdate event of CandidateID:
    Me!ElectionDate = Me!EnterElectionDate
    g) Put the following code in the double click event of CandidateID:
    Me!NumberOfVotes = Me!NumberOfVotes + 1

    When you enter an election, the code in f) will automatically enter the
    election date for each record.

    To tally the votes for each candidate, as you count each vote click on the
    candidate's name and the code in g) will automatically add 1 to his
    NumberOfVotes each time you click on his name.

    --
    PC Datasheet
    Your Resource For Help With Access, Excel And Word Applications
    Over 1175 users have come to me from the newsgroups requesting help
    resource@pcdatasheet.com



    "Sokan33" <Sokan33@discussions.microsoft.com> wrote in message
    news:08D6C7C7-EDDB-473B-994A-8D754E5A6106@microsoft.com...
    > Thanks for your suggestions. But after building these tables what's next.
    > Would appreciate further suggestion on how to query and report against the
    > tables. Your free input will be regarded and appreciated!
    >
    > "PC Datasheet" wrote:
    >
    >> TblCandidate
    >> CandidateID
    >> FirstName
    >> MI
    >> LastName
    >>
    >> TblOffice
    >> OfficeID
    >> Office
    >> Term (Years)
    >>
    >> TblCandidateRunningForOffice
    >> CandidateRunningForOfficeID
    >> OfficeID
    >> CandidateID
    >> ElectionDate
    >> NumberOfVotes
    >>
    >> --
    >> PC Datasheet
    >> Your Resource For Help With Access, Excel And Word
    >> Applications
    >> Over 1175 users have come to me from the newsgroups requesting
    >> help
    >> resource@pcdatasheet.com
    >>
    >>
    >> "Sokan33" <Sokan33@discussions.microsoft.com> wrote in message
    >> news:867CDB16-743D-40CB-9914-8F5D01251923@microsoft.com...
    >> >I was asked to conducting an election in my church and would like to
    >> >design
    >> > an Access DB for that purpose. Can anyone point me in a direction on
    >> > how
    >> > to
    >> > go about this? Thanking you all for your assistance!

    >>
    >>
    >>
     

Share This Page