RE: Microsoft Date Time Picker properties
Try pulling up the type library for the control in the Object Browser. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder Sent: Thursday, July 16, 2015 7:57 PM To: profoxt...@leafe.com Subject: Microsoft Date Time Picker properties I have discovered by looking at others code that one can access properties of the control via: - thisform.ControlName.object.value - thisform.ControlName.object.MinDate - thisform.ControlName.object.MaxDate I am sure there are more properties but since they don't show in the VFP Properties window I don't know what they are or where to go to find them. I have not figured out how to use a datetime field in a table as the control source for such a control either. The properties window allows me to set a control source but the field and display values don't stay matched. Can someone point me in the right direction? Thanks in advance, Joe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn4pr10mb091358dc68bd8655af3502c7d2...@bn4pr10mb0913.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Microsoft Date Time Picker properties
Hi Joe, That would be under Tools Object Browser Open Hit the tab Com Libraries Scroll down till you find Microsoft Date and Time Picker Control n.0 (SPn) Check the check box and it will display the methods and properties in the Classes Members section of the Object Browser. -Philip B. On 7/16/2015 7:57 PM, Joe Yoder wrote: I have discovered by looking at others code that one can access properties of the control via: - thisform.ControlName.object.value - thisform.ControlName.object.MinDate - thisform.ControlName.object.MaxDate I am sure there are more properties but since they don't show in the VFP Properties window I don't know what they are or where to go to find them. I have not figured out how to use a datetime field in a table as the control source for such a control either. The properties window allows me to set a control source but the field and display values don't stay matched. Can someone point me in the right direction? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55a91aea.70...@netzero.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Microsoft Date Time Picker properties
Joe, Doug Henning has a good posting on the use of it here: http://doughennig.blogspot.com/2008/06/using-microsoft-date-and-time-picker.html And here's a good article on using it in a grid http://weblogs.foxite.com/sandstorm36/2009/08/25/datetime-picker-in-a-grid-how-toupdated/ -Philip On 7/16/2015 7:57 PM, Joe Yoder wrote: I have discovered by looking at others code that one can access properties of the control via: - thisform.ControlName.object.value - thisform.ControlName.object.MinDate - thisform.ControlName.object.MaxDate I am sure there are more properties but since they don't show in the VFP Properties window I don't know what they are or where to go to find them. I have not figured out how to use a datetime field in a table as the control source for such a control either. The properties window allows me to set a control source but the field and display values don't stay matched. Can someone point me in the right direction? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55a91b70.6010...@netzero.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Microsoft Date Time Picker properties
Joe, My experience, right or wrong technically, has been that if the object exposes the property through the OCX interface (right click on the object that is shown on a form in the development environment, choose the properties option at the bottom of the popup) then I can access it, set it, and read it. Like you, I have noticed that sometimes you have to include .object. and sometimes you don't. In other words, sometimes it's thisform.ControlName.object.value and sometimes it's thisform.ControlName.value No idea why but I've never noticed it causing a problem when .object. is used...unless it isn't necessary, in which case you'll find out soon enough when you try to use that property. Hope this helps. Mike Copeland Joe Yoder wrote: Thanks guys for the pointers with directions and examples! I should be able to find answers going forward now that I can get to the properties. I am still puzzled about how the VFP properties sheet lines up with the active-x control properties. Some of the VPF properties don't seem to work as expected. Why are they there if they don't work? Is a developer supposed to know that s/he should not expect them to work? Thanks again, Joe On Fri, Jul 17, 2015 at 11:12 AM, Philip Borkholder plbor...@netzero.net wrote: Joe, Doug Henning has a good posting on the use of it here: http://doughennig.blogspot.com/2008/06/using-microsoft-date-and-time-picker.html And here's a good article on using it in a grid http://weblogs.foxite.com/sandstorm36/2009/08/25/datetime-picker-in-a-grid-how-toupdated/ -Philip On 7/16/2015 7:57 PM, Joe Yoder wrote: I have discovered by looking at others code that one can access properties of the control via: - thisform.ControlName.object.value - thisform.ControlName.object.MinDate - thisform.ControlName.object.MaxDate I am sure there are more properties but since they don't show in the VFP Properties window I don't know what they are or where to go to find them. I have not figured out how to use a datetime field in a table as the control source for such a control either. The properties window allows me to set a control source but the field and display values don't stay matched. Can someone point me in the right direction? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55a9506c.4090...@ggisoft.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Microsoft Date Time Picker properties
Thanks Mike - I guess I'm not the only one wondering! Joe On Fri, Jul 17, 2015 at 2:58 PM, Mike Copeland m...@ggisoft.com wrote: Joe, My experience, right or wrong technically, has been that if the object exposes the property through the OCX interface (right click on the object that is shown on a form in the development environment, choose the properties option at the bottom of the popup) then I can access it, set it, and read it. Like you, I have noticed that sometimes you have to include .object. and sometimes you don't. In other words, sometimes it's thisform.ControlName.object.value and sometimes it's thisform.ControlName.value No idea why but I've never noticed it causing a problem when .object. is used...unless it isn't necessary, in which case you'll find out soon enough when you try to use that property. Hope this helps. Mike Copeland Joe Yoder wrote: Thanks guys for the pointers with directions and examples! I should be able to find answers going forward now that I can get to the properties. I am still puzzled about how the VFP properties sheet lines up with the active-x control properties. Some of the VPF properties don't seem to work as expected. Why are they there if they don't work? Is a developer supposed to know that s/he should not expect them to work? Thanks again, Joe On Fri, Jul 17, 2015 at 11:12 AM, Philip Borkholder plbor...@netzero.net wrote: Joe, Doug Henning has a good posting on the use of it here: http://doughennig.blogspot.com/2008/06/using-microsoft-date-and-time-picker.html And here's a good article on using it in a grid http://weblogs.foxite.com/sandstorm36/2009/08/25/datetime-picker-in-a-grid-how-toupdated/ -Philip On 7/16/2015 7:57 PM, Joe Yoder wrote: I have discovered by looking at others code that one can access properties of the control via: - thisform.ControlName.object.value - thisform.ControlName.object.MinDate - thisform.ControlName.object.MaxDate I am sure there are more properties but since they don't show in the VFP Properties window I don't know what they are or where to go to find them. I have not figured out how to use a datetime field in a table as the control source for such a control either. The properties window allows me to set a control source but the field and display values don't stay matched. Can someone point me in the right direction? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cabqednxz_mwwhs5shnjmtd91mpzb1d6guh3_ju2dx+-qofj...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Microsoft Date Time Picker properties
I have no idea why it is that way, it just always has been. I have always attributed it to VFP being a red-headed step-child at MSoft...although I'm sure it has a much more technical cause. Mike Joe Yoder wrote: Thanks Mike - I guess I'm not the only one wondering! Joe On Fri, Jul 17, 2015 at 2:58 PM, Mike Copeland m...@ggisoft.com wrote: Joe, My experience, right or wrong technically, has been that if the object exposes the property through the OCX interface (right click on the object that is shown on a form in the development environment, choose the properties option at the bottom of the popup) then I can access it, set it, and read it. Like you, I have noticed that sometimes you have to include .object. and sometimes you don't. In other words, sometimes it's thisform.ControlName.object.value and sometimes it's thisform.ControlName.value No idea why but I've never noticed it causing a problem when .object. is used...unless it isn't necessary, in which case you'll find out soon enough when you try to use that property. Hope this helps. Mike Copeland Joe Yoder wrote: Thanks guys for the pointers with directions and examples! I should be able to find answers going forward now that I can get to the properties. I am still puzzled about how the VFP properties sheet lines up with the active-x control properties. Some of the VPF properties don't seem to work as expected. Why are they there if they don't work? Is a developer supposed to know that s/he should not expect them to work? Thanks again, Joe On Fri, Jul 17, 2015 at 11:12 AM, Philip Borkholder plbor...@netzero.net wrote: Joe, Doug Henning has a good posting on the use of it here: http://doughennig.blogspot.com/2008/06/using-microsoft-date-and-time-picker.html And here's a good article on using it in a grid http://weblogs.foxite.com/sandstorm36/2009/08/25/datetime-picker-in-a-grid-how-toupdated/ -Philip On 7/16/2015 7:57 PM, Joe Yoder wrote: I have discovered by looking at others code that one can access properties of the control via: - thisform.ControlName.object.value - thisform.ControlName.object.MinDate - thisform.ControlName.object.MaxDate I am sure there are more properties but since they don't show in the VFP Properties window I don't know what they are or where to go to find them. I have not figured out how to use a datetime field in a table as the control source for such a control either. The properties window allows me to set a control source but the field and display values don't stay matched. Can someone point me in the right direction? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55a95307.4040...@ggisoft.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Microsoft Date Time Picker properties
Thanks guys for the pointers with directions and examples! I should be able to find answers going forward now that I can get to the properties. I am still puzzled about how the VFP properties sheet lines up with the active-x control properties. Some of the VPF properties don't seem to work as expected. Why are they there if they don't work? Is a developer supposed to know that s/he should not expect them to work? Thanks again, Joe On Fri, Jul 17, 2015 at 11:12 AM, Philip Borkholder plbor...@netzero.net wrote: Joe, Doug Henning has a good posting on the use of it here: http://doughennig.blogspot.com/2008/06/using-microsoft-date-and-time-picker.html And here's a good article on using it in a grid http://weblogs.foxite.com/sandstorm36/2009/08/25/datetime-picker-in-a-grid-how-toupdated/ -Philip On 7/16/2015 7:57 PM, Joe Yoder wrote: I have discovered by looking at others code that one can access properties of the control via: - thisform.ControlName.object.value - thisform.ControlName.object.MinDate - thisform.ControlName.object.MaxDate I am sure there are more properties but since they don't show in the VFP Properties window I don't know what they are or where to go to find them. I have not figured out how to use a datetime field in a table as the control source for such a control either. The properties window allows me to set a control source but the field and display values don't stay matched. Can someone point me in the right direction? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cabqednvjlr4axoktz8di5-7rvrgxne91uqoao3xkbbrh2nj...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Microsoft Date Time Picker properties
I have discovered by looking at others code that one can access properties of the control via: - thisform.ControlName.object.value - thisform.ControlName.object.MinDate - thisform.ControlName.object.MaxDate I am sure there are more properties but since they don't show in the VFP Properties window I don't know what they are or where to go to find them. I have not figured out how to use a datetime field in a table as the control source for such a control either. The properties window allows me to set a control source but the field and display values don't stay matched. Can someone point me in the right direction? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cabqednu2icpg+bsfoskc0z1e1xd7moem1z3b1tikjkzp3mb...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
