How to put reminder

[confuse]

Hi to all..

Anyone have any idea how to put a reminder or any code for the reminder. I've search many forum for this but then the code make an error.

Because i want the reminder to function if the remaining products will be equal to 0.


Thanks in advance..

 

[khawar]

Because i want the reminder to function if the remaining products will be equal to 0.

Try to explain your question as much as possible to get the best answer

What do you mean by "remaining products will be equal to 0"

 

[confuse]

Try to explain your question as much as possible to get the best answer

What do you mean by "remaining products will be equal to 0"

Sorry for that..

I have a query named products with fields product id, name, description,unitsold,unit received, remaining product.

This query will calculate the amount sold and the remaining product. And if the remaining product = 0 then the reminder form will pop up and show that there is no product left..

Can this be possible??

Thanks

 

[oumahexi]

You could try placing the following code on the "on open" section of your form:

If remaining product <0 then
msgbox "please order more stock"

I would recommend though that you alert the user before the stock level gets to 0.

Hope this helps.

 

[confuse]

You could try placing the following code on the "on open" section of your form:

If remaining product <0 then
msgbox "please order more stock"

I would recommend though that you alert the user before the stock level gets to 0.

Hope this helps.

Thanks for the reply..

But i want to display all the list of products that the remaining is equal to 0.

How to do the code for this?

 

[dkinley]

How about avoiding code altogether? The reason I sugges this is what if 100 products are getting low? Now you have 100 message boxes you have to close (and write down) to get to the application.

Recommendation is to create a tickler report based on your query. As oumahexi pointed out, it would be nice to know before you run out.

Say for instance, section 1 of the report is all products that have a quantity between 20 - 10. Section 2 is between 10 - 5. Section 3 is 5 - 0.

Then each morning/afternoon, just run the report. Now you don't have to write/remember or wade through pop-ups.

Just my .02,
-dK