Log book

[duchessofireland]

I want to create a "log book"...sort of a "diary" of each employee and what
they do each day. I want it to be "searchable" in the future. Any ideas on
how I could accomplish this in Access? Or is Access the right program to use
for this? Thanks so much

 

[KARL DEWEY]

Outlook calendar will schedule and prompt or a database like this --
Table with at least 4 fields -
DateDue - DateTime
Advanced - number - long integer - how many days ahead to prompt - default 3.
DateDone - DateTime
Notes - Text - 255

Create a macro named Autoexec with action to open query that has criteria
for how many days early to prompt.
Criteria for DateDue --
<= Date()+ [Advanced]