DTPicker: Incrementing Time Value

[Brandon P]

I have a form with the following DTpicker's

InterviewStart (format= "mm/dd/yyyy HH:mm")
InterviewEnd (format= "mm/dd/yyyy HH:mm")

When the user inserts a record, the InterviewStart field updates to Now().

I would like to set the default value of InterviewEnd to be 1.5 hours from
Now(). How does the VBA code look in order to accomplish this?

TIA!

[theDBguy at dot]

Hi Brandon,

You might try something like:

Me.InterviewEnd = DateAdd("h", 1.5, Now())

or

Me.InterviewEnd = DateAdd("h", 1.5, Me.InterviewStart

Hope that helps...

[John W. Vinson]

I think you'll need to use:

Me!InterviewEnd = DateAdd("n", 90, Me!InterviewStart)

The increment argument to DateAdd needs to be an integer so you can add 90
minutes but not 1.5 hours.
--

John W. Vinson [MVP]

[KARL DEWEY]

>InterviewStart (format= "mm/dd/yyyy HH:mm")
>InterviewEnd (format= "mm/dd/yyyy HH:mm")

This is wrong as "m" is used for Months and not Minutes.

Correct would be --
InterviewStart (format= "mm/dd/yyyy HH:nn")
InterviewEnd (format= "mm/dd/yyyy HH:nn")

--
Build a little, test a little.

"John W. Vinson" wrote:

> .
>

[Linq Adams via AccessMonster.com]

John is, of course, correct. Help says that it has to be a "numeric
expression" which it defines as a "any expression that can be evaluated as a
number." Then about a page down, after listing all the various intervals and
the rest of the ins and outs of using the function, it mentions that if it
isn't a Long type it'll round it to the nearest whole number.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1

[John W. Vinson]

On Thu, 7 Jan 2010 09:06:01 -0800, KARL DEWEY
<KARL...@discussions.microsoft.com> wrote:

>>InterviewStart (format= "mm/dd/yyyy HH:mm")
>>InterviewEnd (format= "mm/dd/yyyy HH:mm")
>This is wrong as "m" is used for Months and not Minutes.

To my moderate surprise, the Format feature is sufficiently context-sensitive
that it interprets the first mm as month and the second as minutes:

?format(now,"mm/dd/yyyy hh:mm")
01/07/2010 16:34

I'd still use n for miNutes and m for Months, though!

[theDBguy at dot]

Thanks for the correction, John.

"John W. Vinson" wrote:

> .
>

[John W. Vinson]

On Fri, 8 Jan 2010 13:55:01 -0800, theDBguy <thedbguy(at)gmail(dot)com> wrote:

I remember a very confusing afternoon trying to figure out why my DateAdd
wasn't working. IIRC I asked a question here and someone pointed me the right
direction.