Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 29th, 2003, 12:40 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default


It is difficult to get the calendar control to automatically update the textbox. The events do not fire as you would like them to fire.
It is easier to put the calendar control on a different form. You could also omit the textbox and use only a bound Calendar control. Bound to the date field you are using.

By binding it and giving it a default value, you automatically update the table.






Sal
 
Old October 29th, 2003, 04:20 PM
Authorized User
 
Join Date: Jun 2003
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry but I keep on getting an error on the [Date] part of the code!!?

'Forms![Form1]![Date].SetFocus
'Forms![Form1]![Date].Text = Me.Calendar0.Value

My textbox on the form is named Textbox1, so what is [Date]?

thank you
 
Old October 29th, 2003, 04:46 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry.

Instead of Date put the name of your textbox

Forms![Form1]![TextBox1].SetFocus

I need some coffee...




Sal





Similar Threads
Thread Thread Starter Forum Replies Last Post
disply calender sharadavani6 Servlets 2 November 5th, 2007 06:14 AM
calender event chandrasekhar ASP.NET 2.0 Professional 1 April 16th, 2006 11:32 PM
calender crmpicco Classic ASP Basics 2 March 23rd, 2005 01:21 PM
MSCAL. Calender.7 Markyd Access 1 January 23rd, 2005 04:21 AM
Calender gmoney060 Classic ASP Basics 4 August 23rd, 2004 12:10 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.