pastorandy
IS-IT--Management
Hi
I am a Pastor of a church and have a database that I am creating to help me plan services much more quickly.
I have a small Access 2002 DB that generates an 'order of service' report each week.
I enter 4 hymns for the AM service and 4 hymns for the PM service (in the same service_id record for the date, as well as some other details that works ok thus far.
I have two tables. Hymn and Service.
The service table has fields such as: service_id, service_date, AM1 (these are just hymn_no's), AM2, AM3, AM4, PM1, PM2, PM3, PM4, etc.
The hymn table has the following fields: hymn_id, hymn_no, hymn_name
I do not have the tables joined. I just use the hymn table as a lookup.
The AM hymns are defined as AM1, AM2, AM3, and AM4 in the Service table.
The PM hymns are defined as PM1, PM2, PM3, and PM4,
I have a main form for data entry for the service.
The form is based on the service table with another query on hymn for the combi drop downs to select hymns in the service form.
What I am trying to do is have a check on selecting a hymn number from the combi box that will alert me if the hymn I am selecting in either of the AM1, AM2, AM3, AM4, PM1, PM2, PM3, or PM4 slots for the service - has already been selected within the last 60 days.
I don't mind how I am alerted - but it would be good if it was quite simple and unobtrusive.
Not sure if I have explained that well, but does anyone have an idea on how I could get the hymn alert?
Many thanks in advance.
I am a Pastor of a church and have a database that I am creating to help me plan services much more quickly.
I have a small Access 2002 DB that generates an 'order of service' report each week.
I enter 4 hymns for the AM service and 4 hymns for the PM service (in the same service_id record for the date, as well as some other details that works ok thus far.
I have two tables. Hymn and Service.
The service table has fields such as: service_id, service_date, AM1 (these are just hymn_no's), AM2, AM3, AM4, PM1, PM2, PM3, PM4, etc.
The hymn table has the following fields: hymn_id, hymn_no, hymn_name
I do not have the tables joined. I just use the hymn table as a lookup.
The AM hymns are defined as AM1, AM2, AM3, and AM4 in the Service table.
The PM hymns are defined as PM1, PM2, PM3, and PM4,
I have a main form for data entry for the service.
The form is based on the service table with another query on hymn for the combi drop downs to select hymns in the service form.
What I am trying to do is have a check on selecting a hymn number from the combi box that will alert me if the hymn I am selecting in either of the AM1, AM2, AM3, AM4, PM1, PM2, PM3, or PM4 slots for the service - has already been selected within the last 60 days.
I don't mind how I am alerted - but it would be good if it was quite simple and unobtrusive.
Not sure if I have explained that well, but does anyone have an idea on how I could get the hymn alert?
Many thanks in advance.