Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Use calendar control to populate a text box

Posted on 2012-04-03
7
Medium Priority
?
418 Views
Last Modified: 2012-04-10
I have an ACCESS 2003 form with a calendar contorl, Calendar1.  When the user clicks on a date, I want that date toappear in a text box.  I tried using the On Updated event in the Calendar control, but that did not change the date in the text box.  So, how is this control used?

Sandra
0
Comment
Question by:ssmith94015
[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
7 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 37803450
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1200 total points
ID: 37803505
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 800 total points
ID: 37804340
ssmith94015,

Is the code you tried a secret?
;-)
Why not post it so we can see what you may have done wrong...?
Is the Calendar on a separate popup form, or is it on the same form as the textbox?
...etc

This is typically done on the "AfterUpdate" event of the calendar control (not the "On updated" event)

This works fine for me...
AccessSimpleCalendarContolOnForm.mdb
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 

Author Comment

by:ssmith94015
ID: 37807277
No, the code is not a secret, I just thought it gave enough information.  Am going to try both sample suggestions later today.  Just tired...

Sandra
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37809188
But investigate the samples that capricron1 and I posted first, to see if they resolve your issue.
0
 

Author Comment

by:ssmith94015
ID: 37820228
Have not forgotten, users have a problem with a databsae I am unfamiliary with so resolve.  Will return to this issue Monday.

Sandra
0
 

Author Closing Comment

by:ssmith94015
ID: 37829616
THey both worked, but wound up using Capricorn's.  So split a bit.
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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

670 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