Reminders

[René]

On the front sheet/Switchboard of my dbase, I would like to have a window/box?? where employee or clients birthdays for that month would show up. It would also be awesome to have a space where all annual reviews for that particular month would show up

Any ideas?

Thanks

 

[Steve Schapel]

René,

Whack a continuous form as a subform onto your FrontSheet. Assuming
you have your Employees' dates of birth in the Employees table, the
subform will be based on a simple query where you put a calculated
field in the query like this...
BirthMonth: Month([DateOfBirth])
.... and then in the criteria of this field, you put...
Month(Date())
The SQL of this query would look something like:
SELECT EmployeeName FROM Employees
WHERE Month([DateOfBirth])=Month(Date())

- Steve Schapel, Microsoft Access MVP

 

[René]

Thank you, that worked great

I went to apply this same proceedure to having a subform for when Annual Reviews would be due and ran into the following problem.

The [Next Review] date of the [Employee Requirements] form is a calculated field. It is derived from ([Annual Review]+364) // I couldn't figure out +1 yr and that worked//

It is my understanding that the calculated fields from a form don't carry over onto the table. If that is the case then there is not value in the table // this is true unless you have physically entered instead of using default date for what I can tell -- although I'm working with existing records and haven't entered new ones//

Could this also be done as a report?

 

[René]

Oops, failed to complete sentenc

This was returning an empty query, please advise on how to do correctl

Thanks

 

[Steve Schapel]

René,

ReviewMonth: Month(DateAdd("yyyy",1,[Annual Review]))

If you do this as a calculated field in the query, rather than in the
control source of a form control, you can then apply your
Month(Date()) criteria to it, and base your form or report on the
query.

You are correct that data that is calculated or derived from existing
data should generally not be stored in a table.

- Steve Schapel, Microsoft Access MVP