Simplify entry of date/time

[B4Geyer]

Hi, hope someone has an idea of where to start on this.

Our company offers projects to multiple contractors and we have to enter when we spoke to them and their response. I put a textbox with default of Now(), thinking these would be recorded in real time and it would be no effort at all. But the offers are frequently entered days later, and keying in dozens of specific dates/times in the long format is very irritating for users.

Does anyone know of something similar to the DatePicker or calendar popups that will let you use arrows or comboboxes or something to quickly enter a time? We record date, hour & minute (no seconds) because it updates the contractor's order on the rotation list (i.e., next call is made to the contractor who has been waiting the longest for an offer). No ActiveX please, we're in secured network environment.

Thanks in advance.

 

[comptechbranden]

Ok, I dont have much time but I know of a good way to do half what you want lol. mhartman told me a way to make a button next to your field and use this code so that when they click the box it will autofill the field with the date. You can prob ask or figure out how to have it do the time also. Should be easy.

Private Sub Command1_Click()
Text1.Value = Date
End Sub

 

[ghudson]

Search around for there are plenty of date and time picker samples within this forum. I suggest you stick with the ones that use API codes instead of the ActiveX examples. www.utteraccess.com also has plenty of samples to play with.

 

[B4Geyer]

Date & time

We are using the automatic time stamp - that's the problem we want to bypass.
ghudson, thanks for pointing some specific places to start - although I have spent much time searching I hadn't found too many date/time options that our system would download.

MVP John Viesca's date time version at http://www.viescas.com/Info/links.htm#Downloads
was exactly what we needed.

Thanks for the help!!