Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: sunil madhav
  Where is sunil madhav?
 
 United Kingdom
 sunil madhav
 Tags
Subject: RE: Calendar Control in VFP
Thread ID: 248804 Message ID: 248818 # Views: 1 # Ratings: 1
Version: Visual FoxPro 6 Category: Active X Controls & OLE Automation
Date: Wednesday, December 23, 2009 4:03:43 PM         
   


> Hi,
>
> I have used the Olecontrol for the calendar in VFP 6.0.
>
> I have a table where the books has a date and i have a form in which there are two calendars i.e from && to.
> whenever i select a date FROM and date TO it has to get the details of the dates given in the form and should get the details from the table.
>
> I have tried to do but not able to get the details from the table..
>
> can any one help me.
>
> thnaks
> sunil


Assuming your OleControl for Calendar means the DTPicker ActiveX, then you can use the _value property like this:
Thisform.oleControl1._value = yourtable.yourdatefield


or you can use the day, month and year properties of your DTPicker:

Thisform.oleControl1.day = day(yourtable.yourdatefield)
Thisform.oleControl1.month = month(yourtable.yourdatefield)
Thisform.oleControl1.year = year(yourtable.yourdatefield)


Jun Tangunan
http://weblogs.foxite.com/sandstorm36/default.aspx
http://www.coderisland.com/forum/viewforum.php?f=10

ENTIRE THREAD

Calendar Control in VFP Posted by sunil madhav @ 12/23/2009 1:32:31 PM
RE: Calendar Control in VFP Posted by ho me @ 12/23/2009 2:41:02 PM
RE: Calendar Control in VFP Posted by Yuri Rubinov @ 12/23/2009 2:58:17 PM
RE: Calendar Control in VFP Posted by sunil madhav @ 12/30/2009 12:29:27 PM
RE: Calendar Control in VFP Posted by Yuri Rubinov @ 12/30/2009 2:28:30 PM
RE: Calendar Control in VFP Posted by Jun Tangunan @ 12/23/2009 4:03:43 PM
RE: Calendar Control in VFP Posted by kulwant singh @ 12/23/2009 5:48:39 PM
RE: Calendar Control in VFP Posted by Khurram Khan Khan @ 12/24/2009 9:14:46 AM
RE: Calendar Control in VFP Posted by kulwant singh @ 12/24/2009 6:55:54 PM
RE: Calendar Control in VFP Posted by Khurram Khan Khan @ 12/25/2009 1:50:16 PM
RE: Calendar Control in VFP Posted by Khurram Khan Khan @ 12/26/2009 8:34:17 AM
RE: Calendar Control in VFP Posted by kulwant singh @ 12/26/2009 3:14:43 PM
RE: Calendar Control in VFP Posted by M. Akram Bhatti @ 12/30/2009 1:00:56 PM