PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Excel > Microsoft Excel Programming > DT Picker

Reply
Thread Tools Rate Thread

DT Picker

 
 
matthew.dalton@aktivkapital.co.uk
Guest
Posts: n/a
 
      20th Jun 2007
Hello all,

I have created a userform with a DT picker. The problem I am having is
that I am trying to make the user enter a date using the date picker
by using a blnvalid code. It seems to work fine with everything else
but not with the DT picker. Any ideas?
 
Reply With Quote
 
 
 
 
RB Smissaert
Guest
Posts: n/a
 
      20th Jun 2007
Not sure how your datepicker is done, but I would go with the Monthview
control that comes with Microsoft Windows Common Controls-2 6.0
It will save you all the validating and it is easy for the user as well.

RBS

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello all,
>
> I have created a userform with a DT picker. The problem I am having is
> that I am trying to make the user enter a date using the date picker
> by using a blnvalid code. It seems to work fine with everything else
> but not with the DT picker. Any ideas?
>
 
Reply With Quote
 
=?Utf-8?B?TWlrZQ==?=
Guest
Posts: n/a
 
      20th Jun 2007
What is a blnvalid code ?

"(E-Mail Removed)" wrote:

> Hello all,
>
> I have created a userform with a DT picker. The problem I am having is
> that I am trying to make the user enter a date using the date picker
> by using a blnvalid code. It seems to work fine with everything else
> but not with the DT picker. Any ideas?
>
>
 
Reply With Quote
 
matthew.dalton@aktivkapital.co.uk
Guest
Posts: n/a
 
      22nd Jun 2007
On 20 Jun, 22:54, Mike <M...@discussions.microsoft.com> wrote:
> What is a blnvalid code ?
>
>
>
> "matthew.dal...@aktivkapital.co.uk" wrote:
> > Hello all,
>
> > I have created a userform with a DT picker. The problem I am having is
> > that I am trying to make the user enter a date using the date picker
> > by using a blnvalid code. It seems to work fine with everything else
> > but not with the DT picker. Any ideas?- Hide quoted text -
>
> - Show quoted text -

It is a Boolean Validation code
 
Reply With Quote
 
=?Utf-8?B?TWlrZQ==?=
Guest
Posts: n/a
 
      22nd Jun 2007
Post your code Boolean Validation code should not be a problem

"(E-Mail Removed)" wrote:

> On 20 Jun, 22:54, Mike <M...@discussions.microsoft.com> wrote:
> > What is a blnvalid code ?
> >
> >
> >
> > "matthew.dal...@aktivkapital.co.uk" wrote:
> > > Hello all,
> >
> > > I have created a userform with a DT picker. The problem I am having is
> > > that I am trying to make the user enter a date using the date picker
> > > by using a blnvalid code. It seems to work fine with everything else
> > > but not with the DT picker. Any ideas?- Hide quoted text -
> >
> > - Show quoted text -
>
> It is a Boolean Validation code
>
>
 
Reply With Quote
 
matthew.dalton@aktivkapital.co.uk
Guest
Posts: n/a
 
      25th Jun 2007
On 22 Jun, 13:26, Mike <M...@discussions.microsoft.com> wrote:
> Post your code Boolean Validation code should not be a problem
>
>
>
> "matthew.dal...@aktivkapital.co.uk" wrote:
> > On 20 Jun, 22:54, Mike <M...@discussions.microsoft.com> wrote:
> > > What is a blnvalid code ?
>
> > > "matthew.dal...@aktivkapital.co.uk" wrote:
> > > > Hello all,
>
> > > > I have created a userform with a DT picker. The problem I am having is
> > > > that I am trying to make the user enter a date using the date picker
> > > > by using a blnvalid code. It seems to work fine with everything else
> > > > but not with the DT picker. Any ideas?- Hide quoted text -
>
> > > - Show quoted text -
>
> > It is a Boolean Validation code- Hide quoted text -
>
> - Show quoted text -

Private Sub Ok_Click()
Dim BlnValid As Boolean
BlnValid = True
If PortfolioName.Value = "" Or _
ContractualParty.ListIndex < 0 Or _
TypeOfCredit.ListIndex < 0 Or _
Vendor.ListIndex < 0 Or _
ClientCode.ListIndex < 0 Or _
DTPicker1.Enabled = False Or _
Category.ListIndex < 0 Or _
TypeOfContract.ListIndex < 0 Or _
UID.Value = "" Or _
Debts.Value = "" Or _
FaceValue.Value = "" Or _
AcquisitionCost.Value = "" Or _
Owner.ListIndex < 0 Or _
CurrencyBox.ListIndex < 0 Or _
FirstYearCash.Value = "" Or _
Year2Decay.Value = "" Or _
Year3Decay.Value = "" Or _
Year4Decay.Value = "" Or _
Year5Decay.Value = "" Or _
Year6Decay.Value = "" Or _
Year7Decay.Value = "" Or _
Year8Decay.Value = "" Or _
Year9Decay.Value = "" Or _
Year10Decay.Value = "" Then
BlnValid = False
MsgBox ("You must complete all sections with white boxes."),
vbCritical, "Error"
End If
If BlnValid Then Update
End Sub
 
Reply With Quote
 
matthew.dalton@aktivkapital.co.uk
Guest
Posts: n/a
 
      25th Jun 2007
On 22 Jun, 13:26, Mike <M...@discussions.microsoft.com> wrote:
> Post your code Boolean Validation code should not be a problem
>
>
>
> "matthew.dal...@aktivkapital.co.uk" wrote:
> > On 20 Jun, 22:54, Mike <M...@discussions.microsoft.com> wrote:
> > > What is a blnvalid code ?
>
> > > "matthew.dal...@aktivkapital.co.uk" wrote:
> > > > Hello all,
>
> > > > I have created a userform with a DT picker. The problem I am having is
> > > > that I am trying to make the user enter a date using the date picker
> > > > by using a blnvalid code. It seems to work fine with everything else
> > > > but not with the DT picker. Any ideas?- Hide quoted text -
>
> > > - Show quoted text -
>
> > It is a Boolean Validation code- Hide quoted text -
>
> - Show quoted text -

Private Sub Ok_Click()
Dim BlnValid As Boolean
BlnValid = True
If PortfolioName.Value = "" Or _
ContractualParty.ListIndex < 0 Or _
TypeOfCredit.ListIndex < 0 Or _
Vendor.ListIndex < 0 Or _
ClientCode.ListIndex < 0 Or _
DTPicker1.Enabled = False Or _
Category.ListIndex < 0 Or _
TypeOfContract.ListIndex < 0 Or _
UID.Value = "" Or _
Debts.Value = "" Or _
FaceValue.Value = "" Or _
AcquisitionCost.Value = "" Or _
Owner.ListIndex < 0 Or _
CurrencyBox.ListIndex < 0 Or _
FirstYearCash.Value = "" Or _
Year2Decay.Value = "" Or _
Year3Decay.Value = "" Or _
Year4Decay.Value = "" Or _
Year5Decay.Value = "" Or _
Year6Decay.Value = "" Or _
Year7Decay.Value = "" Or _
Year8Decay.Value = "" Or _
Year9Decay.Value = "" Or _
Year10Decay.Value = "" Then
BlnValid = False
MsgBox ("You must complete all sections with white boxes."),
vbCritical, "Error"
End If
If BlnValid Then Update
End Sub
 
Reply With Quote
 
=?Utf-8?B?TWlrZQ==?=
Guest
Posts: n/a
 
      25th Jun 2007
DTPicker1.Enabled = True

"(E-Mail Removed)" wrote:

> On 22 Jun, 13:26, Mike <M...@discussions.microsoft.com> wrote:
> > Post your code Boolean Validation code should not be a problem
> >
> >
> >
> > "matthew.dal...@aktivkapital.co.uk" wrote:
> > > On 20 Jun, 22:54, Mike <M...@discussions.microsoft.com> wrote:
> > > > What is a blnvalid code ?
> >
> > > > "matthew.dal...@aktivkapital.co.uk" wrote:
> > > > > Hello all,
> >
> > > > > I have created a userform with a DT picker. The problem I am having is
> > > > > that I am trying to make the user enter a date using the date picker
> > > > > by using a blnvalid code. It seems to work fine with everything else
> > > > > but not with the DT picker. Any ideas?- Hide quoted text -
> >
> > > > - Show quoted text -
> >
> > > It is a Boolean Validation code- Hide quoted text -
> >
> > - Show quoted text -
>
> Private Sub Ok_Click()
> Dim BlnValid As Boolean
> BlnValid = True
> If PortfolioName.Value = "" Or _
> ContractualParty.ListIndex < 0 Or _
> TypeOfCredit.ListIndex < 0 Or _
> Vendor.ListIndex < 0 Or _
> ClientCode.ListIndex < 0 Or _
> DTPicker1.Enabled = False Or _
> Category.ListIndex < 0 Or _
> TypeOfContract.ListIndex < 0 Or _
> UID.Value = "" Or _
> Debts.Value = "" Or _
> FaceValue.Value = "" Or _
> AcquisitionCost.Value = "" Or _
> Owner.ListIndex < 0 Or _
> CurrencyBox.ListIndex < 0 Or _
> FirstYearCash.Value = "" Or _
> Year2Decay.Value = "" Or _
> Year3Decay.Value = "" Or _
> Year4Decay.Value = "" Or _
> Year5Decay.Value = "" Or _
> Year6Decay.Value = "" Or _
> Year7Decay.Value = "" Or _
> Year8Decay.Value = "" Or _
> Year9Decay.Value = "" Or _
> Year10Decay.Value = "" Then
> BlnValid = False
> MsgBox ("You must complete all sections with white boxes."),
> vbCritical, "Error"
> End If
> If BlnValid Then Update
> End Sub
>
>
 
Reply With Quote
 
matthew.dalton@aktivkapital.co.uk
Guest
Posts: n/a
 
      25th Jun 2007
On 25 Jun, 11:58, Mike <M...@discussions.microsoft.com> wrote:
> DTPicker1.Enabled = True
>
>
>
> "matthew.dal...@aktivkapital.co.uk" wrote:
> > On 22 Jun, 13:26, Mike <M...@discussions.microsoft.com> wrote:
> > > Post your code Boolean Validation code should not be a problem
>
> > > "matthew.dal...@aktivkapital.co.uk" wrote:
> > > > On 20 Jun, 22:54, Mike <M...@discussions.microsoft.com> wrote:
> > > > > What is a blnvalid code ?
>
> > > > > "matthew.dal...@aktivkapital.co.uk" wrote:
> > > > > > Hello all,
>
> > > > > > I have created a userform with a DT picker. The problem I am having is
> > > > > > that I am trying to make the user enter a date using the date picker
> > > > > > by using a blnvalid code. It seems to work fine with everything else
> > > > > > but not with the DT picker. Any ideas?- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > It is a Boolean Validation code- Hide quoted text -
>
> > > - Show quoted text -
>
> > Private Sub Ok_Click()
> > Dim BlnValid As Boolean
> > BlnValid = True
> > If PortfolioName.Value = "" Or _
> > ContractualParty.ListIndex < 0 Or _
> > TypeOfCredit.ListIndex < 0 Or _
> > Vendor.ListIndex < 0 Or _
> > ClientCode.ListIndex < 0 Or _
> > DTPicker1.Enabled = False Or _
> > Category.ListIndex < 0 Or _
> > TypeOfContract.ListIndex < 0 Or _
> > UID.Value = "" Or _
> > Debts.Value = "" Or _
> > FaceValue.Value = "" Or _
> > AcquisitionCost.Value = "" Or _
> > Owner.ListIndex < 0 Or _
> > CurrencyBox.ListIndex < 0 Or _
> > FirstYearCash.Value = "" Or _
> > Year2Decay.Value = "" Or _
> > Year3Decay.Value = "" Or _
> > Year4Decay.Value = "" Or _
> > Year5Decay.Value = "" Or _
> > Year6Decay.Value = "" Or _
> > Year7Decay.Value = "" Or _
> > Year8Decay.Value = "" Or _
> > Year9Decay.Value = "" Or _
> > Year10Decay.Value = "" Then
> > BlnValid = False
> > MsgBox ("You must complete all sections with white boxes."),
> > vbCritical, "Error"
> > End If
> > If BlnValid Then Update
> > End Sub- Hide quoted text -
>
> - Show quoted text -

All that does is check whether the DTPicker is enabled. What I want it
to do is force the user to pick a date. There is the possibility of
using a check box on the DTPicker if anyone knows how to setup a
Blnvalid based on that?
 
Reply With Quote
 
 
 
Reply

« Add-in with IDTExtensibility2 and worksheet formulae | Use of COUNTA »
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
DT Picker Alex Martinez Microsoft Excel Programming 2 13th May 2005 12:36 PM
DT Picker Alex Martinez Microsoft Excel Discussion 1 13th May 2005 10:42 AM
picker.dll? =?Utf-8?B?S2Vycnk=?= Microsoft Access Security 1 18th Jan 2005 10:57 PM
I am trying to use the Microsoft Date and Time Picker control and I am getting the following error "an error occured in a call to the windows date and time picker control" in access 2000 Ralph Malph Microsoft Access Forms 0 25th Oct 2004 07:00 PM
DT picker Armin Microsoft Access Forms 1 5th Sep 2004 04:17 AM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 04:37 PM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top