Solved

Use calendar control to populate a text box

Posted on 2012-04-03
7
417 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 300 total points
ID: 37803505
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 200 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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

623 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