¨Need help with function on form, date picker/calender

[tormodnt]

Hi!

Hope I ask in the right place now..

I've made a application kind of like a diary, and what I would like is when I push a button a small calendar pops up with small red (or any colors ) ring around the different dates that I have wrote in the book. This is the easiest way to find the dates since it would not be every day I write something..
Any idea how to do this?

 

[dkinley]

I was looking into this some time ago and my research said there are several approaches to this. One is to create your own. Others are you can use Outlook as an extension to Access, download ($$) a 3rd party software that snaps in, use (and modify) an Active X control, or modify the system Calendar API. The last was frown upon because it could have ramifications outside of Access. However, trust but verify! I would submit that you do your own research because this could have changed, you might interpret what I read differently, or there might be some newer information on this topic.

My solution was to create my own. It is here at this thread ...
http://www.access-programmers.co.uk/forums/showthread.php?t=155846

I started from a sample created by other authors at another website titled TimePieces97(.mdb). Found it floating on the web, but the authors provide assistance at another help site.

My second generation of this is to make it 'look and feel' like the system calendar although I haven't gotten around to this yet. I wanted a proof of concept for a visual indicator that a certain type of activity was scheduled on a particular day.

Anyhow - the extent of my knowledge is all contained inside the demo that is posted.

-dK

 

[dkinley]

Ya know, now that I think about it, you could probably do this with some smoke and mirrors.

Although circles are difficult in Access, let's use little boxes for the moment. If you noticed in my demo, on every calendar I have a dotted line box on every date. In it, if it is today's date - then display the dotted line box, if not - leave it invisible (assignment is based upon the control's tag).

If your calendar was to be displayed in the same position each and every time, you might get by with setting some little boxes visible or not. Each box would need to carry with it what the correct date is underneath it on the calendar and some trigger to tell it to display or not. This may or may not be more trouble than it's worth. Just food for thought ... and now I am really thinking about it. Don't wait on me for it though - I am probably a year away from revisiting this issue.

-dK

 

[Alansidman]

Have you ever looked at Allen Browne's website. He has a popup calendar that works ever so sweetly. Easy to install and very little vba.

http://allenbrowne.com/ser-51.html

Alan

OOPS. I mis-read your request. You are looking for multiple circles.