datetime field display
in [Forms]
|
From: xbound on 25 May 2010 18:48 Have a form with a table as Record Resource. There's a datetime field in the table which I would like to break down programmatically and display in two unbound controls: a "hour" combo box and a "minute" combo box. If the user selects other values in the combos, I would like to update the datetime field accordingly. I prefer not having the user to touch the date portion of the datetime field. What's the "proper" way to implement this? Do I need to initiate another read of the record to populate the unbound combos? If so at what point (event) should I do that? Thanks for any advice. Using: Access 2007, SQL Server 2000
From: Jeff Boyce on 26 May 2010 10:43 A suggestion before you proceed any further ... Consider using a query against that table as your data source for the form. This would give you a way to use only portions of the table and/or modified portions (e.g., your time-only info). Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "xbound" <ekwong999(a)hotmail.com> wrote in message news:CE03E462-038E-4444-A95C-01706E9D0C04(a)microsoft.com... > Have a form with a table as Record Resource. There's a datetime field > in the table which I would like to break down programmatically and display > in two unbound controls: a "hour" combo box and a "minute" combo box. If > the user selects other values in the combos, I would like to update the > datetime field accordingly. I prefer not having the user to touch the > date portion of the datetime field. > > What's the "proper" way to implement this? Do I need to initiate another > read of the record to populate the unbound combos? If so at what point > (event) should I do that? Thanks for any advice. > > > Using: Access 2007, SQL Server 2000
From: golfinray on 27 May 2010 16:25 What I do for a date stamp is put a field in my table called Last_Updated. Then a textbox with the control source of Last_Updated. Then I will put a command button for the users to save thier changes and in the onclick of the button I put: Me.last_updated=Now() You may have to change that around for minutes and hours if you want to record those. -- Milton Purdy ACCESS State of Arkansas "xbound" wrote: > Have a form with a table as Record Resource. There's a datetime field in > the table which I would like to break down programmatically and display in > two unbound controls: a "hour" combo box and a "minute" combo box. If the > user selects other values in the combos, I would like to update the datetime > field accordingly. I prefer not having the user to touch the date portion > of the datetime field. > > What's the "proper" way to implement this? Do I need to initiate another > read of the record to populate the unbound combos? If so at what point > (event) should I do that? Thanks for any advice. > > > Using: Access 2007, SQL Server 2000 > > . >
|
Pages: 1 Prev: Webbrowser Activx Control Next: Assigning work to team 1 and team 2 |