Solved

Use calendar control to populate a text box

Posted on 2012-04-03
7
409 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
7 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 37803450
0
 
LVL 119

Accepted Solution

by:
Rey Obrero 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

912 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now