Increment Time

[access7]

Good morning all

Hoping someone can point me in the right direction, I'm still quite new to VBA ...

I have a form which is to record conversation logs (e.g. date of call, time of call, what was said etc). I have a time field on my forms which is set to default at the current time (which is fine as in the majority of cases the user will be adding data at the time of the call). However, upon showing my database so far to our MD he has requested that the user be able to change the time in case they are adding in notes of a conversation at a later point. He does not want the user to just 'over type' the default time, rather he would like arrow buttons which will increase or decrease the time slot by half hour per click
Therefore - I need to now add a function which will allow the user to choose to change this time by pressing command buttons either < or > which will decrease / increase the time shown in half hour slots...

Can anyone give me a clue as to the best way to go about this?

Thanks

 

[tehNellie]

txtDateValue = dateadd("n",txtdateValue, 30)

Adds 30 minutes

txtDateValue = dateadd("n",txtdateValue, -30)

Subtracts 30 minutes.

So if I can't just enter a time myself, what happens when I have to cover a two week time period incrementing in 30 minute slots?

 

[access7]

Its not that the user cant enter the time themselves, they can. I thought that would be sufficient but the director wanted this extra option of being able to scroll through to pick times... I dont get it personally but hey... he's paying me so I have to do what he asks
Thanks for the code

 

[tehNellie]

Can't argue with that logic