Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Marked Solved
Views: 9244

Sep 24th, 2007

using calendar picker from Microsoft calendar control 8.0

Expand Post »

hi, i need help on calendar picker.i placed a calendar control on a form.once i click on any date,i want the date value to be inserted into fields in database.i tried searching for the codes bt what i got was a manually designed calendar by a programmer.is it possible to insert those codes in calendar control 8.0?do we need to do the codings manually when using this component?(microsoft calendar control 8.0)

thanks in advance..

Similar Threads

calendar inside datagrid in ASP.NET
Calendar control in ASP.NET
DOB field-how to use text field and pop out calendar same time? in ASP
I want to Edit Calendar Class in ASP.NET in ASP.NET
Edit Calendar in ASP.NET

nuBudDy

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

32 posts
since Aug 2007

Permalink

Sep 24th, 2007

Re: using calendar picker from Microsoft calendar control 8.0

what exactly are you trying to do? Do you mean that the following doesn't work?
adodc1.recordset("datepicked") = calendar1.value

Last edited by plusplus; Sep 24th, 2007 at 2:16 am.

plusplus

Reputation Points: 10

Solved Threads: 16

Posting Whiz in Training

Offline

207 posts
since Jul 2007

Permalink

Sep 24th, 2007

Re: using calendar picker from Microsoft calendar control 8.0

There is also something called monthview, maybe that's what you need?

plusplus

Reputation Points: 10

Solved Threads: 16

Posting Whiz in Training

Offline

207 posts
since Jul 2007

Permalink

Sep 24th, 2007

Re: using calendar picker from Microsoft calendar control 8.0

i now realize that my main problem is : "i don't exactly know how to use it."
do u mean that by just placing the calendar control on the form, i can straight away use them without having to program anything n just call them with

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
adodc1.recordset("datepicked") = calendar1.value
adodc1.recordset("datepicked") = calendar1.value

when i click on certain date from calendar control, i want the value to be inserted into a field in database.how do i do that?

thanx again plusplus

nuBudDy

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

32 posts
since Aug 2007

Permalink

Sep 24th, 2007

Re: using calendar picker from Microsoft calendar control 8.0

calendar.value
gives you the value of the date clicked
so in the click event of calendar do
adodc1.recordset("datepicked") = calendar.value
That's all
Like I mentioned before, there is also something that's called monthview, it's like the calendar but I think it looks nicer.

plusplus

Reputation Points: 10

Solved Threads: 16

Posting Whiz in Training

Offline

207 posts
since Jul 2007

Permalink

Sep 24th, 2007

Re: using calendar picker from Microsoft calendar control 8.0

hey, i think i'm using it,the monthview you said.i used this :

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
booking_date = MonthView1.Value 'add values into a global variable for use in another form
Unload Me 'unload the current form
CR1.Show 'load another form (where global variable will be used)
End Sub
Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
booking_date = MonthView1.Value 'add values into a global variable for use in another form
Unload Me 'unload the current form
CR1.Show 'load another form (where global variable will be used)
End Sub

and it worked well.thank you very much for your help plusplus

nuBudDy

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

32 posts
since Aug 2007

Permalink

Sep 25th, 2007

Re: using calendar picker from Microsoft calendar control 8.0

i have another thing to add.i want to detect whether date clicked falls on weekend or weekdays so that different form will be loaded.how do i retrieve "day" from the date clicked so i can check it?btw,here are my codes:

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
booking_date = MonthView1.Value 'add values into a global variable for use in another form
Unload Me 'unload the current form
//*If MonthView1.Value = saturday Or MonthView1.Value = sunday Then 'check if date falls on weekend
CR2.Show 'load another form (where global variable will be used)
Else
CR1.Show
End If
 
End Sub
Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
booking_date = MonthView1.Value 'add values into a global variable for use in another form
Unload Me 'unload the current form
//*If MonthView1.Value = saturday Or MonthView1.Value = sunday Then 'check if date falls on weekend
CR2.Show 'load another form (where global variable will be used)
Else
CR1.Show
End If

End Sub

thanx again in advance

nuBudDy

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

32 posts
since Aug 2007

Permalink

Sep 25th, 2007

Re: using calendar picker from Microsoft calendar control 8.0

Select Case weekday(booking_date)'the function weekday gives you a number 1 sunday, 2 monday etc
Case 1,7
'if it's sunday or saturday
Case else
'if it's any other day
End Select

plusplus

Reputation Points: 10

Solved Threads: 16

Posting Whiz in Training

Offline

207 posts
since Jul 2007

Permalink

Sep 25th, 2007

Re: using calendar picker from Microsoft calendar control 8.0

i got it.thanx a lot plusplus

nuBudDy

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

32 posts
since Aug 2007

Permalink

Feb 7th, 2011

setting a military time

hello there I would like to ask on how can set a military time with hours/min./sec. using visual basic. because I needed it for my project can you please give a detail code to program it. please send me your reply... thanks for the big help! =)
godbless..

ask_girl

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Feb 2011

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Inventory System

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Datagrid Columns

DaniWeb Message

Cancel Changes

User Name
Password