Incorporating a "popup" calendar into Access

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??
 
B

Barry Gilbert

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
 
C

CEV

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
 
C

CEV

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
 
C

CEV

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
 
Top