PC Review


Reply
Thread Tools Rate Thread

Blank Date Option

 
 
Bob
Guest
Posts: n/a
 
      19th Dec 2006


--

I have a Calander Select button, but on my Calender there is a [Blank Date]
Option , which is not working is there something i should add to this code
to get the Blank date option.
Below is the Code to [Blank Date] on Calender:

Private Sub cmdCancel_Click()
Dim nRtnValue As Integer, dtDefault As Date
If IsNull(Me.OpenArgs) = True Then
DoCmd.Close acForm, Me.Name
Else
nWeek = 1
If IsNull(Me.OpenArgs) = True Then
dtDefault = Now()
Else
dtDefault = CDate(Me.OpenArgs)
End If
cbMonths.value = Month(dtDefault)
tbMonth = Month(dtDefault)
[cbYears] = Year(dtDefault)
nRtnValue = funSetCalender(dtDefault)
lbMonthYear.Caption = Format(dtDefault, "Long Date")
'Format(dtDefault, "dd/mm/yyyy")
tbDate.value = Format(dtDefault, "dd/mm/yyyy")
tbDate.value = ""
Me.Visible = False
End If
End Sub
Thanks for any help





 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PLEASE HELP! need conditional formatting related to date, blank cellsand today's date Michelle Microsoft Excel Discussion 16 29th Mar 2011 02:57 AM
Prompted to Default Date or User Option to Change Date Emine Microsoft Access Form Coding 6 5th Dec 2008 01:22 AM
Use current date in the default date form field option amcferron@mac.com Microsoft Word Document Management 4 8th Apr 2007 08:27 AM
How do I make a blank cell with a date format blank? =?Utf-8?B?UmU6IFBpdm90IFRhYmxlL1F1ZXJ5?= Microsoft Excel Worksheet Functions 6 14th Jun 2005 11:19 PM
Default display of sample date in linked workbook with blank date in source cell Barbara Martens Microsoft Excel Worksheet Functions 2 15th Apr 2004 10:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:15 AM.