[AccessD] Reorder Level

David McAfee davidmcafee at gmail.com
Wed Nov 11 14:30:55 CST 2009


I'm not sure what you mean by "not show"

You can use conditional formatting to hide it, or you can put an
double quote instead of a zero (but that would require a change in
your OnCurrentEvent code).
=IIf(([txtOnHand]+[txtOnOrder])<[ReorderLevel],[ReorderLevel]-([txtOnHand]+[txtOnOrder]),"")

You can also make it not visible in the OnCurrent event.

Also, I spelled parenthesis incorrectly :)

D


On Wed, Nov 11, 2009 at 12:13 PM, Hollis, Virginia
<hollisvj at pgdp.usec.com> wrote:
> Also, how do I have it not show if the value is 0 in txtReorderAmt? This
> gives me, "Item is 0 units below minimum level."
>
> Reorder Level = 1000
>
> OnHand = 535
>
> OnOrder = 600
>
> txtReorderAmt = 0
>
>
>
> On Current I have:
>
> If Not IsNull(Me!ReorderLevel.Value) Then 'There is a reorder level
> entered
>
>       ReorderLevel = Me!ReorderLevel.Value 'Show the value of the
> reorder level entered
>
>
>
>   If txtReorderAmt > 0 Then 'Reorder level is below.
>
> Me!ReorderLevel.ForeColor = lngRed 'reorder level is red
>
>              Me.DaysPastDue.Visible = True 'Show past due label
>
>    Else
>
>            Me!ReorderLevel.ForeColor = lngBlack 'Reorder level is not
> low, reorder level is black
>
>            Me.DaysPastDue.Visible = False 'No order label.
>
>        End If
>
>    End If




More information about the AccessD mailing list