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!

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/O...p#Hookom,Duane

hth


"Sokan33" <(E-Mail Removed)> wrote in message
news:867CDB16-743D-40CB-9914-(E-Mail Removed)...
> 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!

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!

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
(E-Mail Removed)


"Sokan33" <(E-Mail Removed)> wrote in message
news:867CDB16-743D-40CB-9914-(E-Mail Removed)...
>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!

"PC Datasheet" <(E-Mail Removed)> schreef in bericht news:n9%9g.2719$(E-Mail Removed)...

--
> 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 ????
> (E-Mail Removed)


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

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
> (E-Mail Removed)
>
>
> "Sokan33" <(E-Mail Removed)> wrote in message
> news:867CDB16-743D-40CB-9914-(E-Mail Removed)...
> >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!
>
>
>

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
(E-Mail Removed)



"Sokan33" <(E-Mail Removed)> wrote in message
news:08D6C7C7-EDDB-473B-994A-(E-Mail Removed)...
> 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
>> (E-Mail Removed)
>>
>>
>> "Sokan33" <(E-Mail Removed)> wrote in message
>> news:867CDB16-743D-40CB-9914-(E-Mail Removed)...
>> >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!
>>
>>
>>