Roll Time field by 30 Minutes



Hello Everyone,

Thank you for helping. I am stuck.

My issue is as follows:

1. I have a "Medium Time" field in a form.
2. I put an "Up Arrow" button and a "Down Arrow" button
next to the field.
3. When the user hits the "Up Arrow" button, I would
like to roll the time up 1/2 hour (30 minutes), and vice
versa with the "Down Arrow" button.

I have experiemented with the following functions: (1)
DateAdd(), (2) Format(), and I have experimented
manipulating the time field 100 different ways. I also
have check the Access Web and the Knowledge Base, but I
have not been able to jump the hurdle.

Any ideas would be greatly appreciated. I also would be
open to other techniques that will improve managing a
time field.




Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question