Well it was inevitable, for those of you who have been keeping track I have a lot of easily answered questions.

I have tried to find a step by step way to make a Pop-up Calendar. there are a lot of examples out there but none seem to explain it the way I need to do it.

I have a Field [Date] (obviously) and I have a Button with the calendar Icon on it. (woohoo) I made a form with the Calendar Control 11.0 in it.

What I am assuming is that the Button needs to open the form which I think is:

Docmd.OpenForm "frmCalandar",AcNormal

I am also assuming thar I need to Make the data go back to the text box but i have no idea how.

anyway if anyone knows a simple tutorial i would love to have it as a resource.

Antonio

Antonio,

Why not use the ActiveX DateTime Picker? It provides a textbox, check box and the drop down calendar. The user drops down the calendar, clicks to select the date and the date appears in the text box portion. The value of the control becomes the date.

One caveat- if the machine(s) you will run your app on do not already have the Date-Time Picker installed you must install it. This can be done by the Package and Deploy wizard. I use A2K and have the development edition, which contains both the DateTime Picker and Package and Deploy. Not sure which edition of Office you need to get both in the more recent versions of Access- Someone else may be able to shed some light on that.

HTH,

Loralee

Loralee,

How do I find the ActiveX Date/time picker i am looking the activeX controlls and I do not see it. What is it labeled as?

I will try looking to see if I can install it from someplace else.

I have been researching this and I think it requires the developers edition do you know of another way i can accomplish this task?

I found a great tutorial for creating a Popup tutorial.

http://www.techonthenet.com/access/forms/popup_cal.php

Now all I need to figuire out is how to use the same calendar form with multiple calendar buttons. Anyone have any hints?

Loralee,

I think I found what you were talking about.

http://www.fontstuff.com/access/acctut09.htm

This works pretty well. I couldnt figuire out how to make the frmCalendar work with multiple text boxes so I used this way.

Search: Multiple date fields and one calendar

Antonio-
Cool resource.

I believe A difference between the control you are using and the DateTime Picker is that the Calendar Control continues to use "screen real estate" and the DateTime Picker acts like a combo box in that the date continues to show in a "textbox" but the full month calendar becomes visible when the user clicks on the control.

At least for Access 2K you do need Development Edition to make use of the DateTime Picker and then to package it with the .mdb. Don't know about newer editions of Access. I have just a plain user's A2K license on my system at work. The DateTime Picker IS listed in the ActiveXes but when you drop it on a form you get a messagebox saying "You do not have a license to use this component." Also, I have found that when I create something on my home system with the developer's license with DateTimePicker on a form, then make a copy of that form on another machine, the control does not work on the new copy of the form within the MDB.

Sounds like you have a good solution for what you need.