Solved

ActiveX Calendar 9.0 Access 2000

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

685 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