PC Review


Reply
Thread Tools Rate Thread

Create a To-Do-List?

 
 
=?Utf-8?B?QnJvb2s=?=
Guest
Posts: n/a
 
      15th Feb 2006
Good day all,

i'm interested in finding out if anyone has created a to-do-list for
access? to be able to print? to view... change... etc?

Thanks,

Brook
 
Reply With Quote
 
 
 
 
Steve Schapel
Guest
Posts: n/a
 
      15th Feb 2006
Brook,

No. But I can recommend this...
http://www.safarisoftware.com/mlp.htm

--
Steve Schapel, Microsoft Access MVP


Brook wrote:
> Good day all,
>
> i'm interested in finding out if anyone has created a to-do-list for
> access? to be able to print? to view... change... etc?
>
> Thanks,
>
> Brook

 
Reply With Quote
 
=?Utf-8?B?S0FSTCBERVdFWQ==?=
Guest
Posts: n/a
 
      15th Feb 2006
Here is how you can build one.
Create your table with at least the following fields --
DueDate - DateTime
Item - Text - 255
Done - Yes/No field

Create a query from the table.
For the DueDate field use criteria --
<=Date()-7
Change the seven to the number of days before an item is due that you want
to display.
For the Done field use criteria --
0 (That is a zero)

Create a form using the query as record source and the fields.

Create a macro named Autoexec. For Action use OpenForm and the form as
agurment.

When Access is started the form will open and display all records that are
not marked as Done and as many days in the future as you set in the DateDue
criteria.


"Brook" wrote:

> Good day all,
>
> i'm interested in finding out if anyone has created a to-do-list for
> access? to be able to print? to view... change... etc?
>
> Thanks,
>
> Brook

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create unique list of names from list of duplicates and that arefound within another range Jake Microsoft Excel Worksheet Functions 1 17th Feb 2011 11:33 PM
How to create multi-level collapsible sortable to-do list/task list ajkessel Microsoft Excel Discussion 7 30th Jun 2008 06:04 PM
How to create adress list so can mail merge and create labels? =?Utf-8?B?YWRlY29jcQ==?= Microsoft Excel Misc 2 25th Oct 2006 12:32 AM
Create a distribution list from a category list in Business Contact Manager??? =?Utf-8?B?SVQgTmlnaHRtYXJl?= Microsoft Outlook Contacts 2 26th Jun 2004 07:19 PM
Best way to create a Global Address list and Create Distribution List. Michael Hernandez Microsoft Outlook Contacts 0 1st Jul 2003 03:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:45 AM.