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
Solved

ActiveX Calendar 9.0 Access 2000

Posted on 2000-05-01
2
203 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
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

828 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