Message Box

[Ryan''s Girl]

I am new to Access so please be very specific...
I have created an inventory database for my company. I have a form where
users can enter in inventory information. I have three text boxes on my form
I need help with. I would like a message box to pop up when inventory levels
fall below the Reorder Level.
My text boxes are:
"Reorder Level"
"Units on Hand"
"Units on Order"
So I guess it would be something as follows...
If Units on Hand + Units on Order is < Reorder Level then the message box
will pop up..
How would I go about setting somthing like this up?

 

[Paolo]

Hi Ryan's Girl,

You can add this statement on the after update of your three text box so
when you change something in one of the three the control will be done

if [Units on Hand] + [Units on Order] < [Reorder] then
msgbox "write your message here",vbinformation,"warning or whatever
title you wanna give to the message box"
endif

HTH Paolo

 

[Ryan''s Girl]

So when I open the form in design view I right click on the text box then go
to properties then click the Event tab iand in the after update box do I
click event procedure then the ... ? then type the expression you gave me?

Hi Ryan's Girl,

You can add this statement on the after update of your three text box so
when you change something in one of the three the control will be done

if [Units on Hand] + [Units on Order] < [Reorder] then
msgbox "write your message here",vbinformation,"warning or whatever
title you wanna give to the message box"
endif

HTH Paolo

I am new to Access so please be very specific...
I have created an inventory database for my company. I have a form where
users can enter in inventory information. I have three text boxes on my form
I need help with. I would like a message box to pop up when inventory levels
fall below the Reorder Level.
My text boxes are:
"Reorder Level"
"Units on Hand"
"Units on Order"
So I guess it would be something as follows...
If Units on Hand + Units on Order is < Reorder Level then the message box
will pop up..
How would I go about setting somthing like this up?

 

[Paolo]

When you click in the after update box a little button with 3 dots will
appear on the right of the row, you click the button and a window will
appear. in this window you choose code builder so the code builder will open
and there you paste the expression.

Cherrs Paolo

So when I open the form in design view I right click on the text box then go
to properties then click the Event tab iand in the after update box do I
click event procedure then the ... ? then type the expression you gave me?

Hi Ryan's Girl,

You can add this statement on the after update of your three text box so
when you change something in one of the three the control will be done

if [Units on Hand] + [Units on Order] < [Reorder] then
msgbox "write your message here",vbinformation,"warning or whatever
title you wanna give to the message box"
endif

HTH Paolo

I am new to Access so please be very specific...
I have created an inventory database for my company. I have a form where
users can enter in inventory information. I have three text boxes on my form
I need help with. I would like a message box to pop up when inventory levels
fall below the Reorder Level.
My text boxes are:
"Reorder Level"
"Units on Hand"
"Units on Order"
So I guess it would be something as follows...
If Units on Hand + Units on Order is < Reorder Level then the message box
will pop up..
How would I go about setting somthing like this up?

 

[Ryan''s Girl]

Paolo,
I did exactly what you told me to do and it doesn't seem to be doing
anything...I didn't get any errors but on forms where the inventory is below
the Reorder Level no box is popping up. Any suggestions as to why this may
not be working?

When you click in the after update box a little button with 3 dots will
appear on the right of the row, you click the button and a window will
appear. in this window you choose code builder so the code builder will open
and there you paste the expression.

Cherrs Paolo

So when I open the form in design view I right click on the text box then go
to properties then click the Event tab iand in the after update box do I
click event procedure then the ... ? then type the expression you gave me?

Hi Ryan's Girl,

You can add this statement on the after update of your three text box so
when you change something in one of the three the control will be done

if [Units on Hand] + [Units on Order] < [Reorder] then
msgbox "write your message here",vbinformation,"warning or whatever
title you wanna give to the message box"
endif

HTH Paolo


:

I am new to Access so please be very specific...
I have created an inventory database for my company. I have a form where
users can enter in inventory information. I have three text boxes on my form
I need help with. I would like a message box to pop up when inventory levels
fall below the Reorder Level.
My text boxes are:
"Reorder Level"
"Units on Hand"
"Units on Order"
So I guess it would be something as follows...
If Units on Hand + Units on Order is < Reorder Level then the message box
will pop up..
How would I go about setting somthing like this up?

 

[Paolo]

Well, the three text box "Reorder Level", "Units on Hand" and "Units on
Order" are calculated or do you write the data in them?
If you write the data in them the after update event and the control is
triggered when you leave the box. Otherwise, if the text box contains a
calculated value the control must be put where you calculate the value.

HTH Paolo

Paolo,
I did exactly what you told me to do and it doesn't seem to be doing
anything...I didn't get any errors but on forms where the inventory is below
the Reorder Level no box is popping up. Any suggestions as to why this may
not be working?

When you click in the after update box a little button with 3 dots will
appear on the right of the row, you click the button and a window will
appear. in this window you choose code builder so the code builder will open
and there you paste the expression.

Cherrs Paolo

So when I open the form in design view I right click on the text box then go
to properties then click the Event tab iand in the after update box do I
click event procedure then the ... ? then type the expression you gave me?

:

Hi Ryan's Girl,

You can add this statement on the after update of your three text box so
when you change something in one of the three the control will be done

if [Units on Hand] + [Units on Order] < [Reorder] then
msgbox "write your message here",vbinformation,"warning or whatever
title you wanna give to the message box"
endif

HTH Paolo


:

I am new to Access so please be very specific...
I have created an inventory database for my company. I have a form where
users can enter in inventory information. I have three text boxes on my form
I need help with. I would like a message box to pop up when inventory levels
fall below the Reorder Level.
My text boxes are:
"Reorder Level"
"Units on Hand"
"Units on Order"
So I guess it would be something as follows...
If Units on Hand + Units on Order is < Reorder Level then the message box
will pop up..
How would I go about setting somthing like this up?