<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV><STRONG>Susan,</STRONG></DIV>
<DIV> </DIV>
<DIV> The topic appears interesting. Keeping in view the
typical requirements for handling notes/articles/tasks, with facility for
setting dates & intervals for reminders (where needed), I have
developed an Access .mdb application for my use (finishing touches in
progress).</DIV>
<DIV> </DIV>
<DIV> Whenever this database is opened, a message box will pop
up giving a summary as follows -</DIV>
<DIV> (a) Nos of Items already overdue</DIV>
<DIV> (b) Nos of Items due today</DIV>
<DIV> (c) Nos of Items that will become due within next seven
days</DIV>
<DIV> </DIV>
<DIV> The msgbox will appear only if total of (a) to (c) is
more than zero. Deselecting a Yes/No field will mean the item will be ignored
while generating scheduling alert. Provision has also been made to view on
demand the overall position of all items whose scheduling status is
active</DIV>
<DIV> </DIV>
<DIV> In addition, the program should be useful in storing and
retrieval of articles/notes etc apart from printing reports of
selected items.Lookup row sources for various combo boxes are self generated
based upon progressive accumulation of data.</DIV>
<DIV> </DIV>
<DIV> I would be glad to send you the database but it is not
clear whether attachments are supposed to be sent to the list address. If you
like, I could send it to you directly (on hearing from you).</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>---------------------</STRONG></DIV></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=harkins@iglou.com href="mailto:harkins@iglou.com">Susan Harkins</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, May 10, 2003 23:38</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] scheduling</DIV>
<DIV><BR></DIV>Can't work, so I might as well get out of dodge! ;)<BR><BR>It
happens every year and then I forget about it and once I'm behind,
it<BR>affects the entire summer. So, I will definitely be giving some thought
to<BR>your suggestion -- I don't actually "schedule" articles in Access, but
I<BR>think I'll add some kind of validation to assigned topics as I enter the
due<BR>date -- which will promptly reject an article if there are too
many<BR>scheduled already. Or, perhaps I'll simply show a list of dates and
the<BR>number of open slots -- either way, it shouldn't be difficult at all
and I<BR>don't know why I didn't think of it before. I've been using Outlook
to keep<BR>all that straight and it's a pia to use two different applications.
But I<BR>just haven't had time to really add it to the Access db that tracks
them all<BR>for invoicing, but it's all there already. This will be a simple
feature to<BR>add and will be very helpful.<BR><BR>Susan H.<BR><BR><BR>>
...the better solution is to install real electrical surge protectors
at<BR>> your electrical panels rather than the toy suppressors we all have
for our<BR>> computers and phones ...most of those sold at computer/office
outlets<BR>can't<BR>> handle more than a short, mild surge ...for areas
like south Florida where<BR>> we get frequent lightning storms you need
much more ...the ones we have in<BR>> our main panel and phone distribution
block cost $300+ but handle over<BR>26MVA<BR>> surges ...anything but a
direct hit ...before we installed them we had<BR>> constant hits on our
computers despite each having their own suppressors<BR>> ...after
installation, I've been able to work through the worst storms<BR>...as<BR>>
long as power stays on, I can without worrying ...HTH :)<BR>><BR>> ...of
course if I needed a handy excuse to take off this time of year<BR>>
anyway, yours would work :))))<BR>><BR>> William Hindman<BR>><BR>>
----- Original Message -----<BR>> From: "Susan Harkins" <<A
href="mailto:harkins@iglou.com">harkins@iglou.com</A>><BR>> To: <<A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A>><BR>>
Sent: Saturday, May 10, 2003 11:20 AM<BR>> Subject: [AccessD]
scheduling<BR>><BR>><BR>> > I use Access to keep articles, etc. on
schedule, keep up with invoicing,<BR>> > etc. and it works just fine.
The one thing I don't really know how to<BR>> handle<BR>> > is the
following -- occasionally I want to note something that I may not<BR>> >
need for months -- and I can do that -- just don't really know how to
go<BR>> > about displaying it -- reminding myself to look -- know what I
mean?<BR>> ><BR>> > For instance, this past two weeks has been bad
because of the weather.<BR>> Even<BR>> > though I have surge
protectors, I still turn off everything when the<BR>> > lightning starts
and that's been hours every day for the past two weeks.<BR>> I'm<BR>>
> grossly behind as a result. Now, what I need to do is make a note
to<BR>> myself<BR>> > that sometime in Jan, Feb, March -- maybe even
all three -- that I<BR>remind<BR>> > myself NOT to schedule fully for
April and May because of the weather.<BR>> ><BR>> > Just not sure
how to approach it. Right now, I'm using Outlook and<BR>Access<BR>> >
and I'm working toward phasing Outlook out of the picture -- it's
just<BR>too<BR>> > difficult to work with for what I need.<BR>>
><BR>> > Susan H.<BR></BLOCKQUOTE></BODY></HTML>