|
 |
access thread: calendar to open in today's date -How
Message #1 by "Joseph Valdez" <e-valdez@a...> on Sat, 15 Mar 2003 14:50:47 -0800
|
|
I have added a calendar control in the app but would like it to open in
today's date. I have the design in the parameters in the control
but it saves the date forever. Is there a way to default the value to
today's date when the calendar opens?
Message #2 by "Kenny Alligood" <kennyalligood@h...> on Sat, 15 Mar 2003 21:44:49 -0500
|
|
I added the Calendar Control and in the Form_Load event I did this:
Private Sub Form_Load()
ActiveXCtl0.Value = Date
End Sub
that should solve your issue....
Kenny Alligood
>From: "Joseph Valdez" <e-valdez@a...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] calendar to open in today's date -How
>Date: Sat, 15 Mar 2003 14:50:47 -0800
>
>I have added a calendar control in the app but would like it to open in
>today's date. I have the design in the parameters in the control
>but it saves the date forever. Is there a way to default the value to
>today's date when the calendar opens?
>
>
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
Message #3 by "Joseph Valdez" <e-valdez@a...> on Sat, 15 Mar 2003 21:31:36 -0800
|
|
Well, I have a button that fires the calendar control.Should the code go
behind this button?
-----Original Message-----
From: Kenny Alligood [mailto:kennyalligood@h...]
Sent: Saturday, March 15, 2003 6:45 PM
To: Access
Subject: [access] Re: calendar to open in today's date -How
I added the Calendar Control and in the Form_Load event I did this:
Private Sub Form_Load()
ActiveXCtl0.Value = Date
End Sub
that should solve your issue....
Kenny Alligood
>From: "Joseph Valdez" <e-valdez@a...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] calendar to open in today's date -How
>Date: Sat, 15 Mar 2003 14:50:47 -0800
>
>I have added a calendar control in the app but would like it to open in
>today's date. I have the design in the parameters in the control
>but it saves the date forever. Is there a way to default the value to
>today's date when the calendar opens?
>
>
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
Message #4 by "Joseph Valdez" <e-valdez@a...> on Sat, 15 Mar 2003 21:51:41 -0800
|
|
I found the solution. It should be on the form load event of the form that
contains the calendar control. Bingo!
Thanks!!
-----Original Message-----
From: Joseph Valdez [mailto:e-valdez@a...]
Sent: Saturday, March 15, 2003 9:32 PM
To: Access
Subject: [access] Re: calendar to open in today's date -How
Well, I have a button that fires the calendar control.Should the code go
behind this button?
-----Original Message-----
From: Kenny Alligood [mailto:kennyalligood@h...]
Sent: Saturday, March 15, 2003 6:45 PM
To: Access
Subject: [access] Re: calendar to open in today's date -How
I added the Calendar Control and in the Form_Load event I did this:
Private Sub Form_Load()
ActiveXCtl0.Value = Date
End Sub
that should solve your issue....
Kenny Alligood
>From: "Joseph Valdez" <e-valdez@a...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] calendar to open in today's date -How
>Date: Sat, 15 Mar 2003 14:50:47 -0800
>
>I have added a calendar control in the app but would like it to open in
>today's date. I have the design in the parameters in the control
>but it saves the date forever. Is there a way to default the value to
>today's date when the calendar opens?
>
>
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
Message #5 by "Kenny Alligood" <kennyalligood@h...> on Sun, 16 Mar 2003 09:07:38 -0500
|
|
You can - your code would be this:
Private Sub Command0_Click()
With ActiveXCtl1
.Visible = True
.Value = Date
End With
End Sub
Kenny Alligood
>From: "Joseph Valdez" <e-valdez@a...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Re: calendar to open in today's date -How
>Date: Sat, 15 Mar 2003 21:31:36 -0800
>
>Well, I have a button that fires the calendar control.Should the code go
>behind this button?
>
>-----Original Message-----
>From: Kenny Alligood [mailto:kennyalligood@h...]
>Sent: Saturday, March 15, 2003 6:45 PM
>To: Access
>Subject: [access] Re: calendar to open in today's date -How
>
>
>I added the Calendar Control and in the Form_Load event I did this:
>
>Private Sub Form_Load()
>
> ActiveXCtl0.Value = Date
>
>End Sub
>
>that should solve your issue....
>
>
>Kenny Alligood
>
>
>
>
>
> >From: "Joseph Valdez" <e-valdez@a...>
> >Reply-To: "Access" <access@p...>
> >To: "Access" <access@p...>
> >Subject: [access] calendar to open in today's date -How
> >Date: Sat, 15 Mar 2003 14:50:47 -0800
> >
> >I have added a calendar control in the app but would like it to open in
> >today's date. I have the design in the parameters in the control
> >but it saves the date forever. Is there a way to default the value to
> >today's date when the calendar opens?
> >
> >
>
>
>_________________________________________________________________
>MSN 8 with e-mail virus protection service: 2 months FREE*
>http://join.msn.com/?page=features/virus
>
>
>
>
>
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
|
|
|
View Cart
