Ideas On How to Create A To Do List?

[mcongdon]

I would like to be able to have a form that pops up on the open of the database with a to do list. This would have calls to make and tasks to complete for the day. This data will come from a query of a table with a bunch of company representatives in it each with a specific call back date. I would like these names and numbers to show up as people to call for the day, as well as other tasks that a user can enter on this form. If a new task comes in, I want the user to be able to enter it into a text box, then have it in the list of things to do. When done with a task, a check box should be there so the user can click it and remove that task from he list of things to do.

I just wanted to see if anyone had any great ideas, I could probably fudge something together, but I figured someone on here might have had some experience doing something like this and could give some pointers on where to start. Thanks

 

[fneily]

You don't describe your tables. Did you see:
Fundamentals of Relational Database Design

http://r937.com/relational.html

I'll assume you have a table, let's say tblWork. There's a checkbox field to indicate completion. I'd then have a startup form (see Tools - Startup) that's a switchboard. One button says Today's Calls, which when pressed will bring up a form based on the query you described showing calls that need to be done by checking the checkbox field.
Another button can be Today's Tasks. It'll bring up a form with incompleted tasks, obtained from a query checking the checkbox field. This form is just a regular form so any new tasks can be inputted as a new record.

Maybe I'm thinking too basically.