Drop down calendar?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've looked up a number of sites that produce different calendar products but I need some way of making an easy to use drop down calendar on Access so that people can enter a date in a combo box or select it from a drop down calendar. Ideally, I need a calendar object that lets people customise which dates are available and which aren't by colour coding them on the calendar. Can anyone help with this? I'm desperate to solve this because this is the crux of the whole program needed
 
Katherine,

I have done something similar in the past. My advice
depends on your VBA knowledge. You could download an
access form (that reproduces a calendar effect). There are
loads on sites on the internet. The calendar could then
load data form a customised form table to suit the user
and then you could use the GetWindowRect function
from "User32" to determine the position on the form where
the calendar appears.

Easy!? If you are having further difficulties then re-post
and we can go off-group to discuss this further.

I hope I have given you a starter.

Alastair MacFarlane
-----Original Message-----
I've looked up a number of sites that produce different
Click to expand...
calendar products but I need some way of making an easy to
use drop down calendar on Access so that people can enter
a date in a combo box or select it from a drop down
calendar. Ideally, I need a calendar object that lets
people customise which dates are available and which
aren't by colour coding them on the calendar. Can anyone
help with this? I'm desperate to solve this because this
is the crux of the whole program needed.
 
Katherine said:
I've looked up a number of sites that produce different calendar products but I need some way of making an easy to use drop down calendar on Access so that people can enter a date in a combo box or select it from a drop down calendar. Ideally, I need a calendar object that lets people customise which dates are available and which aren't by colour coding them on the calendar. Can anyone help with this? I'm desperate to solve this because this is the crux of the whole program needed.
Click to expand...

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

I'd suggest using an Access form or one of the third party controls if
you can find one with the functionality you want.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top