A97 overflow error returned when trying to calculate 192/(24*60*60) - why?

[MLH]

I have the following procedure in a form module in A97. I have
the NewOutRefDate global var declared in a standard module
named "Declarations". It is dim'd as Variant.

Private Sub Command9_Click()
NewOutRefDate = 192 / (24 * 60 * 60)
Debug.Print NewOutRefDate
End Sub

The attempted assignment fails with an overflow error when it
runs. Anybody know why? I thought variant sufficient to handle
this calculation.

[MLH]

The following code gives me an error
Private Sub Command9_Click()
Dim MyDbl As Double
MyDbl = 192 / (24 * 60 * 60)
Debug.Print MyDbl
But the following does not...
Private Sub Command9_Click()
Dim MyDbl As Double
MyDbl = 4 / 7
Debug.Print MyDbl

I thought this unusual. Am I doing something wrong?

[lesperancer]

(24 * 60 * 60) must be trying to evaluate to an integer

192 / (cdbl(24) * 60 * 60) seems to work = 2.22222222222222E-03

but I don't know why

[paii, Ron]

<le*********@natpro.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

(24 * 60 * 60) must be trying to evaluate to an integer

192 / (cdbl(24) * 60 * 60) seems to work = 2.22222222222222E-03

but I don't know why

(24 * 60 * 60) = 86400 which is a bigger number then an Integer can hold.

(cdbl(24) * 60 * 60) converts it to a double which can hold 86400

[MLH]

On Wed, 7 Sep 2005 10:34:56 -0500, "paii, Ron" <pa**@packairinc.com>
wrote:

<le*********@natpro.com> wrote in message
news:11**********************@g47g2000cwa.googleg roups.com...

(24 * 60 * 60) must be trying to evaluate to an integer

192 / (cdbl(24) * 60 * 60) seems to work = 2.22222222222222E-03

but I don't know why

(24 * 60 * 60) = 86400 which is a bigger number then an Integer can hold.

(cdbl(24) * 60 * 60) converts it to a double which can hold 86400

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I was thinking that declaring NewOutRefDate As Variant would take
care of any memory allocation requirements. I guess I was wrong. It
does seem strange, though. A variant is the one variable type that
is big enough to manage any of the others.

[paii, Ron]

"MLH" <CR**@NorthState.net> wrote in message
news:j8********************************@4ax.com...

On Wed, 7 Sep 2005 10:34:56 -0500, "paii, Ron" <pa**@packairinc.com>
wrote:

<le*********@natpro.com> wrote in message
news:11**********************@g47g2000cwa.googleg roups.com...

(24 * 60 * 60) must be trying to evaluate to an integer

192 / (cdbl(24) * 60 * 60) seems to work = 2.22222222222222E-03

but I don't know why

(24 * 60 * 60) = 86400 which is a bigger number then an Integer can hold.
(cdbl(24) * 60 * 60) converts it to a double which can hold 86400

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I was thinking that declaring NewOutRefDate As Variant would take
care of any memory allocation requirements. I guess I was wrong. It
does seem strange, though. A variant is the one variable type that
is big enough to manage any of the others.

A variant will store anything, but Access creates temporary storage while
doing math functions.
24, 60, 60 are all Integer so Access creates an Integer to store the
calculation,
then fails when the result overflows the Integer.

[MLH]

Well, you learn something new everyday.
I thought my computer was broke.