TimeSerial

[Ray Hogan]

Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However, when
I enter values greater than 12:00 in [txtTeeTime], the result increases by 1
hour.
Please advise and what are my options.
Thanking you in anticipation.
Rayh.

 

[Douglas J. Steele]

Let's see more of the code you're trying to use.

 

[Ray Hogan]

I just have a number of Textbox with differnt minute values.
Regards.
Rayh

Let's see more of the code you're trying to use.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However, when
I enter values greater than 12:00 in [txtTeeTime], the result increases

by

1
hour.
Please advise and what are my options.
Thanking you in anticipation.
Rayh.

 

[Douglas J. Steele]

So what exactly is in them? In your original question, you mention "values
greater than 12:00". For your code to work, you must have only a single
number, not two separated by a colon. And now you're mentioning that the
textboxes contain minutes, yet you've got txtTeeTime in the Hours position
of the TimeSerial function. Why are you adding txtTeeTime to the results of
the TimeSerial function anyhow?

Let's go back a couple of steps. What exactly are you trying to achieve?

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I just have a number of Textbox with differnt minute values.
Regards.
Rayh

Let's see more of the code you're trying to use.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However, when
I enter values greater than 12:00 in [txtTeeTime], the result

increases

by

 

[Ray Hogan]

Hi,
In txtTeeTime I am entering a time value and I want to the other textboxs to
produce values say 11 minutes later or whatever value I enter in Timeserial.
regards.
Rayh

So what exactly is in them? In your original question, you mention "values
greater than 12:00". For your code to work, you must have only a single
number, not two separated by a colon. And now you're mentioning that the
textboxes contain minutes, yet you've got txtTeeTime in the Hours position
of the TimeSerial function. Why are you adding txtTeeTime to the results of
the TimeSerial function anyhow?

Let's go back a couple of steps. What exactly are you trying to achieve?

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I just have a number of Textbox with differnt minute values.
Regards.
Rayh

Let's see more of the code you're trying to use.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However,
when
I enter values greater than 12:00 in [txtTeeTime], the result

increases

by
1
hour.
Please advise and what are my options.
Thanking you in anticipation.
Rayh.

 

[Douglas J. Steele]

To add eleven minutes to a time, use DateAdd("n", 11, [MyTime])

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hi,
In txtTeeTime I am entering a time value and I want to the other textboxs to
produce values say 11 minutes later or whatever value I enter in Timeserial.
regards.
Rayh

So what exactly is in them? In your original question, you mention "values
greater than 12:00". For your code to work, you must have only a single
number, not two separated by a colon. And now you're mentioning that the
textboxes contain minutes, yet you've got txtTeeTime in the Hours position
of the TimeSerial function. Why are you adding txtTeeTime to the results of
the TimeSerial function anyhow?

Let's go back a couple of steps. What exactly are you trying to achieve?

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I just have a number of Textbox with differnt minute values.
Regards.
Rayh
Let's see more of the code you're trying to use.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However,
when
I enter values greater than 12:00 in [txtTeeTime], the result increases
by
1
hour.
Please advise and what are my options.
Thanking you in anticipation.
Rayh.