Incorporating a "popup" calendar into Access

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

My boss has been asking me about whether we can incorporate a popup
calendar that will note the computer user when certain dates within
access tables are reached. It will just pop up on the screen with a
message saying "So and so has reached its deadline".

Is there a way to do this? I want to tell him that it's not possible
(within my skills) and this might require someone really experienced in
VB and Access as well.

Your thoughts please??
 
This is certainly possible. The first step is to create a query that finds
the data you want. It's hard for me to help with this part without knowing
your data structure, but you need a query that looks for records where the
deadline is in the past.

Then you need to run the query on some event. Maybe a button click, the
database being opened, or some other event.

The next trick is the way it's displayed. I would suggest a form or report
that shows the details from the record.

All fairly simple stuff, actually. It could be done with one query, one
report, and one macro.

Barry
 
That looks like something I could also use. A question I have though is that
it looks like you need an empty space on your form where the calendar would
appear. On a couple of my forms I have no empty space big enough for a
calendar. Would I still be able to do this somehow?

Thanks,

Chad
 
Could this be created so that the calendar would appear on a completely
seperate form that pops up to enter the date? This way one would not have to
worry about making room for a hidden calendar on the form being used. Does
this make sense?

Thanks,

Chad
 
Please disregard my previous post to this topic. After playing with it, I
discovered that I could just put the calendar control over the top of
another control.

Thanks,

Chad
 
Back
Top