Dick7Access
Dick S
- Local time
- Yesterday, 22:40
- Joined
- Jun 9, 2009
- Messages
- 4,203
are their any reliable time pickers available?
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.
Did you see the example I posted?
Do you want a Popup control or build it on your form? I think Micron was suggesting to build this directly on your form. But you could make a popup.How do I get the chosen value into the DB?
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?
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.
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).I will give it a try
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).