CALCULATION

  • Thread starter Thread starter Vic
  • Start date Start date
V

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
 
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".
 
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

Dorian said:
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 said:
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
Click to expand...
Click to expand...
 
Vic

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

Jeff B.
Vic said:
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

Dorian said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top