[ms_access] Calendar Control
Folks Can you help me out with this calendar control? I would like to have the calendar default to the current month and date when it comes up on the form. Is there a way to include code that will allow this to occur? It always comes up showing the month I installed it April and the date that I installed itthe 14th...not sure why. Thanks! Dave - Private Sub Rcalendar_Click() Select Case Me.ROption.Value Case Is = 1 Me.Opsdate.Value = Me.RCalendar.Value Case Is = 2 Me.EndDate.Value = Me.RCalendar.Value End Select End Sub This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ms_access] Calendar Control
put this code in the Form_Load Event YourCalendarControlName.Value = Date Rgrds, Fauzie - Original Message - From: Dave Moreau To: Access Newsgroup (E-mail) Sent: Friday, September 15, 2006 6:19 AM Subject: [ms_access] Calendar Control Folks Can you help me out with this calendar control? I would like to have the calendar default to the current month and date when it comes up on the form. Is there a way to include code that will allow this to occur? It always comes up showing the month I installed it April and the date that I installed itthe 14th...not sure why. Thanks! Dave -- Private Sub Rcalendar_Click() Select Case Me.ROption.Value Case Is = 1 Me.Opsdate.Value = Me.RCalendar.Value Case Is = 2 Me.EndDate.Value = Me.RCalendar.Value End Select End Sub This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Calendar Control
Hi John, Yes, I am opening this form from a switchboard. I may just put a button on the form that says Full Screen and go from there. Have you seen my other post about the long date problem I'm having with my query? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Friday, January 20, 2006 10:07 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Mike- Most bizarre! Putting that code in the Load event works. Putting it anywhere else (such as Open or Activate) does not work. It also does not work if there's any code that forces the form to get the focus - your Maximize is doing that, but a simple Me.SetFocus screws it up as well. Are you opening this form from another one? If so, you could try putting the code in that procedure. Like this: DoCmd.OpenForm MyCalendar ' Make sure the form is loaded Forms!MyCalendar.SetFocus ' .. and the calendar Forms!CalendarStart.SetFocus Me.CalendarStart.Year = Year(Date) Me.CalendarStart.Month = Month(Date) Me.CalendarStart.Day = Day(Date) ' .. any other cleanup code here - perhaps closing this form John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Thursday, January 19, 2006 11:16 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Hi John, I figured it out, but it creates another problem. I had a docmd.maximize in the On Open event. When I took this out, the calendar started working properly. Where else can I put the docmd.maximize? Can I swap the two (put the calendar code in the on open event and the docmd.maximize in the on load event? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Thursday, January 19, 2006 11:47 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Hi John, Inserted that code, but it's not working. I have it in the On_Load event for the form. Should I move it to a different event? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Thursday, January 19, 2006 9:30 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Mike- The stupid Calendar control has separate Year, Month, and Day properties that determine what current date is displayed. So, do: Me.CalendarStart.Year = Year(Date) Me.CalendarStart.Month = Month(Date) Me.CalendarStart.Day = Day(Date) John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Wednesday, January 18, 2006 10:37 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Well, I thought I had it figured out... Here goes again - I have a form with 2 calendar controls on it 1) is named CalendarStart and 2) is named CalendarStop. What I've done is in the Form_Load event, I've added the following code: CalendarStart.Value = Date CalendarStop.Value = Date But the calendars are not displaying the current date when I view the form, they are displaying the date I added the calendars to the form. As usual, any help is greatly appreciated :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 17, 2006 2:31 PM To: ms_access@yahoogroups.com Subject: [ms_access] Calendar Control Never mind, I figured it out! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Calendar Control
Mike- The stupid Calendar control has separate Year, Month, and Day properties that determine what current date is displayed. So, do: Me.CalendarStart.Year = Year(Date) Me.CalendarStart.Month = Month(Date) Me.CalendarStart.Day = Day(Date) John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Wednesday, January 18, 2006 10:37 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Well, I thought I had it figured out... Here goes again - I have a form with 2 calendar controls on it 1) is named CalendarStart and 2) is named CalendarStop. What I've done is in the Form_Load event, I've added the following code: CalendarStart.Value = Date CalendarStop.Value = Date But the calendars are not displaying the current date when I view the form, they are displaying the date I added the calendars to the form. As usual, any help is greatly appreciated :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 17, 2006 2:31 PM To: ms_access@yahoogroups.com Subject: [ms_access] Calendar Control Never mind, I figured it out! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Calendar Control
Thanks John :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Thursday, January 19, 2006 9:30 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Mike- The stupid Calendar control has separate Year, Month, and Day properties that determine what current date is displayed. So, do: Me.CalendarStart.Year = Year(Date) Me.CalendarStart.Month = Month(Date) Me.CalendarStart.Day = Day(Date) John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Wednesday, January 18, 2006 10:37 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Well, I thought I had it figured out... Here goes again - I have a form with 2 calendar controls on it 1) is named CalendarStart and 2) is named CalendarStop. What I've done is in the Form_Load event, I've added the following code: CalendarStart.Value = Date CalendarStop.Value = Date But the calendars are not displaying the current date when I view the form, they are displaying the date I added the calendars to the form. As usual, any help is greatly appreciated :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 17, 2006 2:31 PM To: ms_access@yahoogroups.com Subject: [ms_access] Calendar Control Never mind, I figured it out! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Calendar Control
Hi John, Inserted that code, but it's not working. I have it in the On_Load event for the form. Should I move it to a different event? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Thursday, January 19, 2006 9:30 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Mike- The stupid Calendar control has separate Year, Month, and Day properties that determine what current date is displayed. So, do: Me.CalendarStart.Year = Year(Date) Me.CalendarStart.Month = Month(Date) Me.CalendarStart.Day = Day(Date) John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Wednesday, January 18, 2006 10:37 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Well, I thought I had it figured out... Here goes again - I have a form with 2 calendar controls on it 1) is named CalendarStart and 2) is named CalendarStop. What I've done is in the Form_Load event, I've added the following code: CalendarStart.Value = Date CalendarStop.Value = Date But the calendars are not displaying the current date when I view the form, they are displaying the date I added the calendars to the form. As usual, any help is greatly appreciated :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 17, 2006 2:31 PM To: ms_access@yahoogroups.com Subject: [ms_access] Calendar Control Never mind, I figured it out! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Calendar Control
Hi John, I figured it out, but it creates another problem. I had a docmd.maximize in the On Open event. When I took this out, the calendar started working properly. Where else can I put the docmd.maximize? Can I swap the two (put the calendar code in the on open event and the docmd.maximize in the on load event? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Thursday, January 19, 2006 11:47 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Hi John, Inserted that code, but it's not working. I have it in the On_Load event for the form. Should I move it to a different event? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Thursday, January 19, 2006 9:30 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Mike- The stupid Calendar control has separate Year, Month, and Day properties that determine what current date is displayed. So, do: Me.CalendarStart.Year = Year(Date) Me.CalendarStart.Month = Month(Date) Me.CalendarStart.Day = Day(Date) John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Wednesday, January 18, 2006 10:37 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Well, I thought I had it figured out... Here goes again - I have a form with 2 calendar controls on it 1) is named CalendarStart and 2) is named CalendarStop. What I've done is in the Form_Load event, I've added the following code: CalendarStart.Value = Date CalendarStop.Value = Date But the calendars are not displaying the current date when I view the form, they are displaying the date I added the calendars to the form. As usual, any help is greatly appreciated :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 17, 2006 2:31 PM To: ms_access@yahoogroups.com Subject: [ms_access] Calendar Control Never mind, I figured it out! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Calendar Control
Mike- Works for me. I created a new form, added a Calendar control, named it CalControl, and put this in the form's Load event: Me.CalControl.Month = Month(Date) Me.CalControl.Year = Year(Date) Me.CalControl.Day = Day(Date) Note that you must use the name of the control, not the name of any bound field - but I think you said this is unbound. I purposefully set the values of these three properties to something other than today before loading the form, and it does move to today's date. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Thursday, January 19, 2006 10:47 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Hi John, Inserted that code, but it's not working. I have it in the On_Load event for the form. Should I move it to a different event? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Thursday, January 19, 2006 9:30 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Mike- The stupid Calendar control has separate Year, Month, and Day properties that determine what current date is displayed. So, do: Me.CalendarStart.Year = Year(Date) Me.CalendarStart.Month = Month(Date) Me.CalendarStart.Day = Day(Date) John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Wednesday, January 18, 2006 10:37 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Well, I thought I had it figured out... Here goes again - I have a form with 2 calendar controls on it 1) is named CalendarStart and 2) is named CalendarStop. What I've done is in the Form_Load event, I've added the following code: CalendarStart.Value = Date CalendarStop.Value = Date But the calendars are not displaying the current date when I view the form, they are displaying the date I added the calendars to the form. As usual, any help is greatly appreciated :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 17, 2006 2:31 PM To: ms_access@yahoogroups.com Subject: [ms_access] Calendar Control Never mind, I figured it out! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Calendar Control
Well, I thought I had it figured out... Here goes again - I have a form with 2 calendar controls on it 1) is named CalendarStart and 2) is named CalendarStop. What I've done is in the Form_Load event, I've added the following code: CalendarStart.Value = Date CalendarStop.Value = Date But the calendars are not displaying the current date when I view the form, they are displaying the date I added the calendars to the form. As usual, any help is greatly appreciated :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 17, 2006 2:31 PM To: ms_access@yahoogroups.com Subject: [ms_access] Calendar Control Never mind, I figured it out! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] Calendar Control
Hi All, I have a form which contains 2 calendar ActiveX Controls. The first one is called StartDate and the second is called StopDate. The problem is that they always default to the date that I orginally added them to the form. How do I make them default to the current date? As always, thanks in advance! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] Calendar Control
Never mind, I figured it out! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/