datestamp with a check box
in [Forms]
|
From: Terrence Carroll on 26 Jan 2010 17:13 I need to know how to code a check box so that when it is checked another field called resolved date will populate with date coinciding with when the checkbox was checked. The resolved date will also need to return to blank status if the checkbox is deselected (i.e. situations where the user accidentally checked the checkbox and then they check the checkbox a second time to "deselect" the checkbox.
From: Jeff Boyce on 26 Jan 2010 17:25 Terrence Is the only purpose of the checkbox to insert (/remove) a date (or date/time) value from another control? If so, why bother?! Instead, use the double-click event of the control to handle this. 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. "Terrence Carroll" <TerrenceCarroll(a)discussions.microsoft.com> wrote in message news:BF50C967-25CD-4DF2-B3AE-8DEF59DD5687(a)microsoft.com... >I need to know how to code a check box so that when it is checked another > field called resolved date will populate with date coinciding with when > the > checkbox was checked. The resolved date will also need to return to blank > status if the checkbox is deselected (i.e. situations where the user > accidentally checked the checkbox and then they check the checkbox a > second > time to "deselect" the checkbox.
From: Barry A&P on 27 Jan 2010 11:37 Terrance You posted this question yesterday as "How to use a combo box as timestamp" it was responded to twice. But i often loose track of my posts too so here it is again.. you could change marshall's suggestion in the checkboxes afterupdate event to If Me.ChkBoxResolved = True Then Me.[resolution date] = Date Else Me.[resolution date] = Null End If this will also clear the resolution date if the check box is unchecked. Please check this post as answered if it was any help Thanks Barry "Terrence Carroll" wrote: > I need to know how to code a check box so that when it is checked another > field called resolved date will populate with date coinciding with when the > checkbox was checked. The resolved date will also need to return to blank > status if the checkbox is deselected (i.e. situations where the user > accidentally checked the checkbox and then they check the checkbox a second > time to "deselect" the checkbox.
|
Pages: 1 Prev: Select Case fails to fire with Data Users Next: Calendar Form |