CALCULATION

[Vic]

I put the following code on a field calld LdPdMt on when you double click on
that field.

Private Sub LdPdMt_DblClick(Cancel As Integer)
[LdPdMt] = [LdMilRteMT].Column(2) * [ldmtmiles]

End Sub

When I go to double click on the field I get an error 13 type mismatch.

I'm trying to calculate LdMilRteMt column 2 which is a currency field that
LdMtMiles which is a number field and have that result stored in LdPdMt which
is a currency field.

Any idea's what I've done wrong.

Thanks

 

[Dorian]

Do you know how to use the debugger?
Its an essential tool.
Set a breakpoint in the code and examine the contents of each variable.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Vic]

Nope have no idea. Don't use this enough to really know what I'm doing.
Tried it from some idea's in the the help menu.

As for fishing I've never done that either.

Thx

Do you know how to use the debugger?
Its an essential tool.
Set a breakpoint in the code and examine the contents of each variable.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

I put the following code on a field calld LdPdMt on when you double click on
that field.

Private Sub LdPdMt_DblClick(Cancel As Integer)
[LdPdMt] = [LdMilRteMT].Column(2) * [ldmtmiles]

End Sub

When I go to double click on the field I get an error 13 type mismatch.

I'm trying to calculate LdMilRteMt column 2 which is a currency field that
LdMtMiles which is a number field and have that result stored in LdPdMt which
is a currency field.

Any idea's what I've done wrong.

Thanks

 

[Jeff Boyce]

Vic

Learning to fish might be a couple orders of magnitude more simple...<g>

Jeff B.

Nope have no idea. Don't use this enough to really know what I'm doing.
Tried it from some idea's in the the help menu.

As for fishing I've never done that either.

Thx

Do you know how to use the debugger?
Its an essential tool.
Set a breakpoint in the code and examine the contents of each variable.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and
they
eat for a lifetime".

I put the following code on a field calld LdPdMt on when you double
click on
that field.

Private Sub LdPdMt_DblClick(Cancel As Integer)
[LdPdMt] = [LdMilRteMT].Column(2) * [ldmtmiles]

End Sub

When I go to double click on the field I get an error 13 type mismatch.

I'm trying to calculate LdMilRteMt column 2 which is a currency field
that
LdMtMiles which is a number field and have that result stored in LdPdMt
which
is a currency field.

Any idea's what I've done wrong.

Thanks