 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / February 2008Date Control
I have a text box that holds data for a date field. I would like to use the Date Callender Control so the user can pick a date but since I new to Access I don't understand how the object is attached to a control source and thus I can not apply the results to a text box or to a field in the form. How do I change the control source or how to I apply the selection to the record. In a general sense stay away from ActiveX controls when possible. Take a look at either http://allenbrowne.com/ser-51.html or http://www.lebans.com/monthcalendar.htm  SignatureHope this helps, Daniel Pineault If this post was helpful, please rate it by using the vote buttons. > I have a text box that holds data for a date field. I would like to use the > Date Callender Control so the user can pick a date but since I new to Access [quoted text clipped - 3 lines] > How do I change the control source or how to I apply the selection to the > record. Ok, thanks but what's wrong with ActiveX controls? > In a general sense stay away from ActiveX controls when possible. Take a > look at either [quoted text clipped - 10 lines] > > How do I change the control source or how to I apply the selection to the > > record. ActiveX controls can be prone to problems with versioning. Your application may work fine with version 8.341, but when some other application installs version 8.353, your application can stop working. And the worst part is that when there is a versioning problem, it can affect more than just the part of the application that uses the calendar: regular VBA functions such as Left and Date can stop working! SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > Ok, thanks but what's wrong with ActiveX controls? > [quoted text clipped - 16 lines] >> > the >> > record. Thanks again. I went ith the "Microsoft Date and Time Picker 6.0" It's int he ActiveX list but it's microsoft so I don't know how that applies to your concern about versioning. Any concerns here? > ActiveX controls can be prone to problems with versioning. Your application > may work fine with version 8.341, but when some other application installs [quoted text clipped - 23 lines] > >> > the > >> > record. To be honest, I'm not sure, since I always use the API-only approach that Stephen Lebans has at http://www.lebans.com/monthcalendar.htm Microsoft was very bad at one time for not maintaining compatibility, but they have improved lately. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > Thanks again. I went ith the "Microsoft Date and Time Picker 6.0" > [quoted text clipped - 13 lines] >> Left >> and Date can stop working! > Thanks again. I went ith the "Microsoft Date and Time Picker 6.0" > > It's int he ActiveX list but it's microsoft so I don't know how that > applies > to your concern about versioning. Any concerns here? Yes, version can be a problem no matter whose control you are using. I do sometimes use ActiveX controls so let me give you a tip that has worked well for me. Make a copy of the control you are using and put it in the same folder as the database. Register it there and replace the control in your database with the one that you've just registered. If you do that, you maintain your own copy, and it should work as long as the OS system supports COM. I've had some working for the last 9 years. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com >I have a text box that holds data for a date field. I would like to use the > Date Callender Control so the user can pick a date but since I new to [quoted text clipped - 5 lines] > How do I change the control source or how to I apply the selection to the > record. A sample file that shows how to do it with an Access form is at: http://www.datastrat.com/Download/Calendar2K.zip One using an ActiveX control is at: http://www.datastrat.com/Download/XCalendar2K.zip and the one in Access 2007 is built in to a date field. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.