K
Kevin Sprinkel
We are using Access to measure ductwork lengths as they
appear on finished construction drawings. The table has
the following fields; only the first 3 are enabled:
Dim1
Dim2
Length
MultFactor
SF
LB
Both Dim1 and Dim2 are entered for rectangular duct, for
round, either dimension may be left blank or contain a
zero. Code attached to Update events selects the proper
multiplying factor, and calculates the area (SF) and the
weight (LB).
I would like to check that each dimension does not exceed
a maximum. The number will be different for round and
rectangular duct, and I won't know which it is until both
dimensions have been entered.
I'd like the code to display a warning message and let him
accept the non-standard number and move to the next field
or cancel moving to the next field, and return him to the
appropriate field to edit it.
Can anyone suggest how to do this? Thanks.
appear on finished construction drawings. The table has
the following fields; only the first 3 are enabled:
Dim1
Dim2
Length
MultFactor
SF
LB
Both Dim1 and Dim2 are entered for rectangular duct, for
round, either dimension may be left blank or contain a
zero. Code attached to Update events selects the proper
multiplying factor, and calculates the area (SF) and the
weight (LB).
I would like to check that each dimension does not exceed
a maximum. The number will be different for round and
rectangular duct, and I won't know which it is until both
dimensions have been entered.
I'd like the code to display a warning message and let him
accept the non-standard number and move to the next field
or cancel moving to the next field, and return him to the
appropriate field to edit it.
Can anyone suggest how to do this? Thanks.