Solved

ActiveX Calendar 9.0 Access 2000

Posted on 2000-05-01
2
207 Views
Last Modified: 2011-10-03
I'm looking for a good self help book or instruction sheet(basic-intermediate)on implementing ActiveX Calendar9.0  control in a form using Access 2000.

Specificly, I would like to be able to click on a date field and have the calender pop-up for that field, select the date from the calendar and then the calendar closes.

0
Comment
Question by:Neal_Mickley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Accepted Solution

by:
AllenHare earned 200 total points
ID: 4787523
Neal,

Can't let you know where to find a book but heres how you do the second part of you question.

1.Create a new form with only a Activex Calendar 9.0 object on it.

2.Then use the 'on enter' event property of your date field to open new calendar form.

3. Next in your calendar form design use the 'build event' option with your Calendar 9.0  object. This should give you the 'click event'

4. Here, just copy the calendar 9.0 value to your date field. eg
    Form1.Goal_Review_Date.Value = Cal.Value

'cal being the name of my calendar 9.0 object.'

5. Then add  DoCmd.Close to close the calendar form.

Done




   
0
 

Expert Comment

by:amp072397
ID: 6222127
Answer force-accepted. Any problems with that, please post a reply here.

Thanks!
amp
Community Support Moderator
Experts Exchange
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question