Date Picker

Click on the bottom right corner of the toolbox ("Additional Controls") and select Calendar Control ?.?

Mike

I'm after the picker rather than the calendar control. I want the user to see a date in a text box with the picker popping up when the user enters the cell or clicks a helper button. I don't want the full month to display all the time.

I see...sorry I can't help you....Mike

You need to do as Data-man says.  After creating a popup form and adding callendar control to it, you can work with its settings not to display year or month.  Now, in on enter event of the txtDate, you can put code to bring up this popup form allowing you to pick your date.  Just remember, there is no on click event on this controls unless you right click and select Build Event form its popup menu.  You need to do some fancy work because you are asking for a fancy feature.

mike

When I search for Data Picker in access on google, I found an MS site referring to a control called "Microsoft Date and Time Picker". It's an ActiveX control, but again, it's not in the list when I try to insert it.

That's why I really think I've got a settings problem or something similar.

PS this link is to the MS page describing the control.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platform/commctls/datetime/datetime.asp

Thanks

I'm attempting to get the required result as suggested using the Calendar control. The problem I'm having is figuring out how to trigger a function once the user has chosen a date without requiring them to click somewhere else. To clarify, clicking the date field (or a lookup button I've placed next to it), displays the calendar. The user clicks a date, and the Calendar should disappear and the value appears in the date field and triggers the fields OnChange event. This all works except I've got to click another field, or tab to get the focus off the calendar so it hides again.

What am I missing?

Method 1. Righ click on the toolbox and select more tools. This will add an extra icon on the toolbox. Click on the tools icon on toolbox and scrol down untill you get to what you want.

Alfternatively if It is not there you have to register it. To register it: from the menu select tools ->ActiveX controls. from the pop up box Scroll down the list until you find "Microsoft Date and Time picker version ...". when select it at the bottom of the that box it will show you the location and the file name note it and click on regist and search and open it. do method one you are there

good luck

Checking in Visual Studio .NET, I can use the Date & Time Picker(as opposed to the Calendar) on a form. So, what do I need to do to get access to this control from Access?

I've tried registering it, but it isn't in the Tools/ActiveX list at all.

OK I've got the Calendar control working.

I do still need to know what the deal is with the Date Time Picker as it would make the whole process far neater and mean one less routine to maintain in the longer term. As it's a standard MS ActiveX control, it shouldn't be too hard to get it to be available in Access.

I suspect that it's a versioning issue as I have several versions of Office (including Access) loaded. If so, can someone suggest how to fix the registration of the controls? Note the versions currently loaded are 2003 and 97, installed in that order.

I need a fix other than re-installing Office as having several versions is a requirement in my job, and installing the 3-4 versions including all the development tools, service packs,... is a fuil days work!

Thanks

on the toolbox there is an icon for tools if you click on that icon that will show you a whol list of stuff. You have scrool down to get it.

I tried it this morning on xp2002. I think if it is on xp2002 it should be on xp2003

The one in office xp is "Microsoft Date and Time Picker Conrol 6.o(SP4).

I found out just now that there is no need for registering it. all you have to do as add option more tools to your toolbox. whent hat is added simply click on tools icon that will giv a long list of all activeX controls.
 

I have the More Tools list, but the Date Picker is not on the list. I've got all sorts of other controls, but not the Date Picker.

What is the process for manually registering this control assuming something has gone wrong in the installation and registration process?

Thanks. That fixed it.

If it doesn't appear on your toolbox, make sure that you register the ocx file MSCOMCT2.ocx through ms access. You'll find it in the system 32 directory of windows.