Date Picker

I'm trying to use a date picker on an Access Form. The problem is that this control ("Microsoft Date & Time Picker") is not in the controls list. I'm using Access 2003.

Can anyone tell me what I need to do to get it to show up. I've tried adding a reference to MS common controls, but that's not listed in the Refs list in VBA.

Help!


LVL 5
gbentleyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Mike
0
gbentleyAuthor Commented:
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.
0
Data-ManCOOCommented:
I see...sorry I can't help you....Mike
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mike EghtebasDatabase and Application DeveloperCommented:
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
0
gbentleyAuthor Commented:
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
0
gbentleyAuthor Commented:
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?
0
HakimCommented:
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
0
gbentleyAuthor Commented:
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?
0
gbentleyAuthor Commented:
I've tried registering it, but it isn't in the Tools/ActiveX list at all.
0
gbentleyAuthor Commented:
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

0
HakimCommented:
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

0
HakimCommented:
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.
 
0
gbentleyAuthor Commented:
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?
0
HakimCommented:
Since I am not using office 2003 I don' know the correct sequence. But I tried on office xp It is already there and there is no need for registering it. but the correct title in the list is "Microsoft Date and Time Picker Control, Version 6.0" tha is the version no in Office xp.

If it is not there you add from office xp. the file you looking for is mscomct2.ocx.

After adding the file, you can regist it from the menu select TOOLS  the select ActiveX Controls. This will display list of all the ActiveX controls avail(inclding the file you have added). Scrol down to find the date and Time picker an highlight it, then click regist buton on the right hand corner. this will ask you where controls are. then browns where you copied the mscomct2.ocx and click okay that will add a tools icon on the tools box.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gbentleyAuthor Commented:
Thanks. That fixed it.
0
acommissoCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.