[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Use calendar control to populate a text box

Posted on 2012-04-03
7
Medium Priority
?
423 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 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month8 days, 8 hours left to enroll

613 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