Some popular programs (i.e. Quicken) allow you to either use the default date that is displayed in a date field, or click the Combo Box to reveal the calendar and use an alternative date from the Calendar Control. Does the (ActiveX Control) Calendar Control that ships with Access 2002 allow me do the same thing: display the current date in a date field, plus allow me to click the Combo Box to reveal a calendar then select another date? If I can not do this with the Active X Calendar Control, is there any other way to do this in Access, or do I need to purchase another ActiveX Control to perform this precedure? If I need to purchase another ActiveX Control, does anyone have any suggestions on which ones are the easiest to work with?

Also, is there an ActiveX Control within Access 2002 that allows me to place a note within a field? For instance, if an employee is absent from work, I may want to place a note in the calendar on the date that she/he was off (or in some other field for that employee) by clicking a note icon or tab? If I need to purchase an ActiveX Control to perform this, does anyone have any suggestions on which ones are the easiest to work with?

Thanks for your help,

David

In form view select Insert -> ActiveX Control. Look for a control named 'Microsoft Data and Time Picker Control'. The one on my machine is version 6.0. This is your drop-down combo that displays a small calendar you can pick dates from.

Thing is, I don't know if this control was installed with Access or with my VB 6.0 installation. I can use it in both.

If you don't see it, its because you don't have MSCOMCT2.OCX library registered on your machine (this is where the datetimepicker control lives). If you don't have it, you could install VB6, or find a copy of MSCOMCT2.OCX, place it in your machines System32 directory, and run "regsvr32 C:\Windows\System32\MSCOMCT2.OCX" from the run dialog. This might register it for you. If it does you could use it in Access.

As far as notes go, you'd need to design your own calendar control with that functionaliy. I've seen a few around, and will post a URL if I can come up with one.

HTH,

Bob

http://www.ddisolutions.com.au used to have a freeware demo db called DemoCalendar.mdb that does the note posting you're looking for (using a custome calendar and a pop-up form to enter notes). I don't see it on their downloads page any more though. Have a look or I could send you a copy if you're interested.

Regards,

Bob

Bob,

As a novice programmer in VBA, it it builds my confidence to know that I have people such as you who are willing to give a helping hand.

Thanks,

David

Hey Dave,

Thanks for the kind words. :) The forums are without question the single most indispensable resource I've found in trying to learn this stuff. Hope you visit often.

Regards,

Bob

Here is a link to the ocx file you'll need to get that control. It is part of the VB install but i managed to find it on the internet. Isn't it wonderful. Here's the link.

http:\\www.digitalborneo.com/downloads/mscomct2.ocx

Instal it like the instructions in this thread says and it will work fine. I tested it and the calendar control is there. Talk to you later.

Branden

Great help!! Echo David's comments and appreciation.

I tried the control and it works great. I also tried to use it in a continuous form in MS Access, but it apparently does not allow one to use an Active X component in such a form. Any way around this?

Thanking you,
Toni

Drew Wutka has a downloadable appointment calendar demo application (probably in Access 97 though I haven't looked at the last few versions) at:

http://www.wolfwares.com/Access/microsoft_access.htm

I've never bothered with the common control ocx's because they were restricted from the envrionment in which I was working. I don't know that the ActiveX components wouldn't work in a continuous form. I wrote my own pop up calendar using a grid of labels as dates and month tabs. It works on continuous forms by using an event procedure that passes a reference to the date display control to the pop up calendar such that the calendar form can work with the specific instance of the control in the continuous form. A control name reference does not work in a continuous form. I would expect that the ocx could be used in a similar fashion.

Jurgen Welz

[email protected]
Edmonton AB Canada

Also have a look at:

www.lebans.com

He has a couple demo calendars. It's been a while since I've looked but I recall he has a purely Win API pop up calendar demo which is lean and efficient for the purposes of reading and setting dates for controls.

Jurgen Welz

Thanks Jurgen. All done and wrapped up.