I have a form that displays personnel data with the start and end dates of their work term. What I would like to do is notify someone who accesses the form if the end date on any of the records is the current or past date via a pop up or something to that effect. How would I do this? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Alarm in Forms
- Thread starter Cero21
- Start date
- Thread starter
- #3
Cero,
Do you mean *any* of the records, or just the currently displayed record?
If only the current one then, as PHV advised, conditional formatting is an easy solution (although I have had a few minor glitches with this in the past with A2K - it may be sorted in later versions of Access).
If you mean you want the form to check *all* records and display a notification if any of them satisfy the criteria you specified you'll have to delve into a little coding.
Let me know and I'll post examples of what you need.
Ed Metcalfe.
Please do not feed the trolls.....
Do you mean *any* of the records, or just the currently displayed record?
If only the current one then, as PHV advised, conditional formatting is an easy solution (although I have had a few minor glitches with this in the past with A2K - it may be sorted in later versions of Access).
If you mean you want the form to check *all* records and display a notification if any of them satisfy the criteria you specified you'll have to delve into a little coding.
Let me know and I'll post examples of what you need.
Ed Metcalfe.
Please do not feed the trolls.....
To apply conditional formatting to a field:
1. Open the form in form view, not design view.
2. Click in the field you want to apply formatting to.
3. Got to Format > Conditional Formatting...
4. Specify condition(s) and resultant formats accordingly (it's fairly straight forwrd).
Ed Metcalfe.
Please do not feed the trolls.....
1. Open the form in form view, not design view.
2. Click in the field you want to apply formatting to.
3. Got to Format > Conditional Formatting...
4. Specify condition(s) and resultant formats accordingly (it's fairly straight forwrd).
Ed Metcalfe.
Please do not feed the trolls.....
- Thread starter
- #6
Ed2020:
Yes I'm looking for an alarm to check *all* the records at once and if any of them at on or past the current date the user will recieve a notification.
I would appreciated the examples you mentioned. Thanks.
Oh, btw I realized I should have named the Topic "Date Alarms" verus data.
Yes I'm looking for an alarm to check *all* the records at once and if any of them at on or past the current date the user will recieve a notification.
I would appreciated the examples you mentioned. Thanks.
Oh, btw I realized I should have named the Topic "Date Alarms" verus data.
- Thread starter
- #7
Well, I managed to figure it by searching a little more with google. I found a website that posted a solution that I modified to fit my intentions.
Thanks a lot for your help everyone.
Thanks a lot for your help everyone.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question