[AccessD] scheduling

Susan,

What Lembit is describing is possible with MS Project.

If you don't have MS Project or any of the equivalents, then I suggest
putting your notes in a table and running a query from your startup that
searches the table for relevant notes.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Lembit Soobik [mailto:Lembit.Soobik at t-online.de] 
Sent: Saturday 2003 May 10 11:48
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] scheduling

Susan,
from your msg I'm not quite sure which of the two the real problem is:
- reminding yourself to look
this can be done with a timer on a form (hidden form)
- Schedule your work load
in the below case you would enter something like 30%  of your available
capacity loaded for April and May. This requires however that you define
how many (wo)manhours article 'JIT' takes  and when it will be started.
put everything in a table including holidays, vacation etc and hours per
day and it will tell you when the article is ready. In this context, you
would like to check for scheduling conflicts. this is done with a little
equation somewhere on our download area (equation by myself and some
friends here). HTH Lembit Soobik

----- Original Message -----
From: "Susan Harkins" <harkins at iglou.com>
To: <AccessD at databaseadvisors.com>
Sent: Saturday, May 10, 2003 5:20 PM
Subject: [AccessD] scheduling


> I use Access to keep articles, etc. on schedule, keep up with 
> invoicing, etc. and it works just fine. The one thing I don't really 
> know how to handle is the following -- occasionally I want to note 
> something that I may not need for months -- and I can do that -- just 
> don't really know how to go about displaying it -- reminding myself to

> look -- know what I mean?
>
> For instance, this past two weeks has been bad because of the weather.

> Even though I have surge protectors, I still turn off everything when 
> the lightning starts and that's been hours every day for the past two 
> weeks. I'm grossly behind as a result. Now, what I need to do is make 
> a note to myself that sometime in Jan, Feb, March -- maybe even all 
> three -- that I remind myself NOT to schedule fully for April and May 
> because of the weather.
>
> Just not sure how to approach it. Right now, I'm using Outlook and 
> Access and I'm working toward phasing Outlook out of the picture -- 
> it's just too difficult to work with for what I need.
>
> Susan H.