[AccessD] scheduling

Susan,

    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).

    Whenever this database is opened, a message box will pop up giving a summary as follows -
    (a) Nos of Items already overdue
    (b) Nos of Items due today
    (c) Nos of Items that will become due within next seven days

    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

    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.

    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).

Regards,
A.D.Tejpal
---------------------
  ----- Original Message ----- 
  From: Susan Harkins 
  To: accessd at databaseadvisors.com 
  Sent: Saturday, May 10, 2003 23:38
  Subject: Re: [AccessD] scheduling


  Can't work, so I might as well get out of dodge! ;)

  It happens every year and then I forget about it and once I'm behind, it
  affects the entire summer. So, I will definitely be giving some thought to
  your suggestion -- I don't actually "schedule" articles in Access, but I
  think I'll add some kind of validation to assigned topics as I enter the due
  date -- which will promptly reject an article if there are too many
  scheduled already. Or, perhaps I'll simply show a list of dates and the
  number of open slots -- either way, it shouldn't be difficult at all and I
  don't know why I didn't think of it before. I've been using Outlook to keep
  all that straight and it's a pia to use two different applications. But I
  just haven't had time to really add it to the Access db that tracks them all
  for invoicing, but it's all there already. This will be a simple feature to
  add and will be very helpful.

  Susan H.


  > ...the better solution is to install real electrical surge protectors at
  > your electrical panels rather than the toy suppressors we all have for our
  > computers and phones ...most of those sold at computer/office outlets
  can't
  > handle more than a short, mild surge ...for areas like south Florida where
  > we get frequent lightning storms you need much more ...the ones we have in
  > our main panel and phone distribution block cost $300+ but handle over
  26MVA
  > surges ...anything but a direct hit ...before we installed them we had
  > constant hits on our computers despite each having their own suppressors
  > ...after installation, I've been able to work through the worst storms
  ...as
  > long as power stays on, I can without worrying ...HTH :)
  >
  > ...of course if I needed a handy excuse to take off this time of year
  > anyway, yours would work :))))
  >
  > William Hindman
  >
  > ----- Original Message -----
  > From: "Susan Harkins" <harkins at iglou.com>
  > To: <AccessD at databaseadvisors.com>
  > Sent: Saturday, May 10, 2003 11:20 AM
  > 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030514/7d37d7fd/attachment-0001.html>