- Jun 9, 2009
are their any reliable time pickers available?
Actually, it's for my wife's medical activities. She liked the one I built for myself for my VA doctors, so I tweaked it a bit to fit her needs. The date goes in as default, as does the time. However, she and I both can not always put our activities in at the moment it happens. I can go in and change the time later than night, but she can’t. She is in a nursing home and probable first stages of Alzheimer’s.You don't want this for always picking the current time do you? Or just deviating slightly from the current time? There are/were ActiveX controls for older versions but I would not advise the use of such controls.
AWF guys are super, thanks for answering, oops sorry and gals.Oddly enough, I was searching for one that I was playing with several months ago. I seem to recall that I deleted it, thinking I would never need it and can't find it now. However, it was a bit more complicated I think, as it advanced every second (it was keeping real time and looked like a digital clock) and I don't think that's what you want. If you provide a bit more information I could probably throw something together for you. If that info would be too personal to post here, you can send me a PM if you care to.
Private Sub cmdTime_Click() Dim theTime As String If IsDate(Me.enterDate) Then theTime = Format(Me.enterTime, "hh:mm") Else theTime = Format(Now, "hh:MM") End If DoCmd.OpenForm "TimeControl", , , , , acDialog, theTime If CurrentProject.AllForms("TimeControl").IsLoaded Then Me.enterTime = Forms("timeControl").txtTime DoCmd.Close acForm, "TimeControl" End If End Sub
Bind the control to a field in a record source. Your form is bound to an editable query, so I think all you'd have to do is change the code references to 'enterTime' because that's the name of your table field.How do I get the chosen value into the DB?
Thanks for the offer. I might take you up on that, but first I want to try it myself. A little bit of tears and cusing is the best teacher.If you get stuck, I will try to apply my code to your db and post back. Will have to wait until tomorrow (after midnight here and I just got in).