Conditional Data Entry

[Stuart]

i work for the British Red Cross, we have a database for Public Events so we
need to know who our volunteers are in Bedfordshire, Hertfordshire & Essex
and what training courses they have passed, if they pass a set of certain
courses then they qualify as Emergency response, if the pass a different set
of courses they qualify for Event First Aid and if they passed a different
set of courses they qualify as FESS which is Fire & Emergency Support Service.

obviously some of the qualifications in each set overlap as is to be
expected, anyways what we nee is for the database to look at what
qualiications a volunteer has by seeing first if it has a date entered in
that qualifications field then it validates that date against a ruleset to
see if that qualification is still valid for example first aid certificates
are valid for 3 years from the date you were certified so in that case it
would check to see if theres a date in the first aid aid and if there is it
then checks to see if it has been more than 3 years since the date in the
field.

if the volunteers certificate has expired then the value in that field
should have a red background with bold white text in it to alert the person
reading the database that the volunteer needs to go on a course to get a new
certificate, ideally it would show an orange background with bold white text
30 days before the certificate is due to expire so we can get them trained
and recertified before there existing qualification expires.

now assuming that a volunteer has all the core qualifications needs for a
specific area of volunteering and those qualifications haven't expired then
the database should take them off as being a volunteer in that section.

so can anyone tell me how to programme access to do all of this?

 

[Jeff Boyce]

Stuart

You've done an excellent job of beginning to describe requirements.

You've not described much about the intended users and their skill
level/experience. You've not covered the type of PCs on which this would
run, nor how many. Nor the version of Access, nor the OS, nor the
network...

You've not described your skill-level/experience with MS Access, nor with
relational database design, nor with user interface design, nor with
application development methodology.

What you are asking (of the volunteers here) is probably more than you'll
find folks willing to volunteer to do.

These newsgroups are great resources for folks to get specific suggestions
to specific requests -- your's is much more general.

(by the way, what you're seeking to do is quite doable. There may even
already be a template or an example database available through searching
on-line.)

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Steve]

Hello Stuart,

I provide help with Access, Excel and Word projects for a very modest fee.
I would like to offer to work with you to create the Volunteer Certification
Database for you. If you are interested, contact me.

Steve
(e-mail address removed)

 

[Gina Whipp]

Stuart,

Have a look http://www.databasedev.co.uk/data_models.html. There is a FREE
Data Model for Employee and Qualifications which help to get you started.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

Hello Stuart,

I provide help with Access, Excel and Word projects for a very modest fee.
I would like to offer to work with you to create the Volunteer Certification
Database for you. If you are interested, contact me.

Steve is perennially inviolation of the starred section of the group's rules:

http://www.microsoft.com/library/gallery/components/wn/3/locales/help/help_en-US.htm#RulesofConduct

Rules of conduct
Appropriate Language: The purpose of our communities is to exchange technical
information and expertise about Microsoft products. Please avoid personal
attacks, slurs, and profanity in your interactions.

Relevance to Topics: Please make sure that your postings in discussion groups
and chats are relevant to the subject at hand. It is normal for some topics to
drift from the stated subject. However, to ensure maximum benefit for
everyone, we encourage you to keep your postings as close to the subject as
possible.

Advertising/Solicitation: These communities were created as a forum for
providing peer-to-peer assistance on Microsoft products and services. **We ask
that you refrain from posting advertisements or solicitations that do not
pertain directly to the intended use and purpose of the newsgroup or chat.**

Confidentiality: Please keep in mind that our communities are public spaces,
so don't post anything that you don't want the world to see. Credit card
numbers, product keys, and other confidential information, including anything
covered under a non-disclosure agreement (NDA), should not be posted to a
discussion group, chat, or other community.

 

[John... Visio MVP]

Hello Stuart,

I provide help with Access, Excel and Word projects for a very modest fee.
I would like to offer to work with you to create the Volunteer
Certification Database for you. If you are interested, contact me.

Steve

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP