Conditional Data Entry
in [General]
|
From: Stuart on 30 Nov 2009 13:01 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? -- Stuart
From: Jeff Boyce on 30 Nov 2009 13:12 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. "Stuart" <stuartbennett-online(a)ntlworld.com> wrote in message news:D36C5DD7-9588-43C7-8926-D50B5E024D07(a)microsoft.com... >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? > -- > Stuart
From: Steve on 30 Nov 2009 15:46 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 santus(a)penn.com "Stuart" <stuartbennett-online(a)ntlworld.com> wrote in message news:D36C5DD7-9588-43C7-8926-D50B5E024D07(a)microsoft.com... >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? > -- > Stuart
From: Gina Whipp on 30 Nov 2009 16:12 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 "Stuart" <stuartbennett-online(a)ntlworld.com> wrote in message news:D36C5DD7-9588-43C7-8926-D50B5E024D07(a)microsoft.com... >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? > -- > Stuart
From: John W. Vinson on 30 Nov 2009 16:17
On Mon, 30 Nov 2009 15:46:35 -0500, "Steve" <notmyemail(a)address.com> wrote: >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 W. Vinson [MVP] |