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 September 7th, 2006, 06:42 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Calendar Control

Hi All
I have a calendar control connected to a combo box.The combo box has nothing in it the user selects the combo box drop down and selects the date required.What I am trying to do is when the combo box becomes dirty it changes the status of the call from open to closed.But on the combo box becoming dirty this will not change the status.Is there a way around this
Thanks

Brendan Bartley
__________________
Brendan Bartley
 
Old September 7th, 2006, 10:00 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I am not sure what you want here. Do you want to prevent the status from changing when the combo box is dirty, or do you want to change the status when the box is dirty?



mmcdonal
 
Old September 7th, 2006, 10:04 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Change the status when dirty

Brendan Bartley
 
Old September 7th, 2006, 10:07 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I would put this on the Form's Before Update Event;

'--------
Sub Form_BeforeUpdate ...

If IsNull(Me.DateCombo) Or Me.DateCombo = "" Then
   Exit Sub
   Else
   Me.Status = "Closed"
End If
End Sub
'----------

That should do it.


mmcdonal
 
Old September 8th, 2006, 03:58 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for you're reply
All working ok

Brendan Bartley





Similar Threads
Thread Thread Starter Forum Replies Last Post
Calendar control cJeffreywang ASP.NET 2.0 Basics 2 July 4th, 2007 01:05 PM
Calendar Control with Tab Control Slicemahn Access 1 June 12th, 2006 10:35 PM
Multiday Calendar Control Alcapone C# 1 August 31st, 2004 04:52 PM
Calendar Control stu9820 ASP.NET 1.0 and 1.1 Basics 3 January 28th, 2004 11:22 AM
Calendar Control ActiveX - Where umagrama Access VBA 0 December 9th, 2003 01:42 PM





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