Thread: Alert when STOCK is low ??
02-13-14, 14:52 #1Registered User
- Join Date
- Apr 2013
Unanswered: Alert when STOCK is low ??
I got the PRODUCT table which has stock field
is there a way of making an alert when stock falls below 10 (example) ??
or at least changing the color to red or some sort .
Pls advice what to do or how to tackle this.
02-14-14, 18:22 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
when do you want to run it
how do you want to run it
the usual answer to any question in Access (or any other front end, or any systems question is yes). there may be several ways of doing it.
classically you'd have a minim stock level set for a product, and or a warning stock level
then take action based on that. you may also have visibilty of orders placed (so that you'd know stuff is ordered but not yet here, but Im pretty certain your modell wont support that.
so what can you do
well first off you'd probably want a report a,d or form which identifies products at or near the warning level. use a query for that
allow the user to run off that report or use a form, depends if they are a screen user or a paper user.
you could also put some code in the forms on current event that changes the background colour of the stock level
lets say you have a WarningLevel, a ReorderLevel
if stock > warninglevel then
mystockcontrollabel.backcolor = vbwhite
elseif stock >reorderlevel then
mystockcontrollabel.backcolor = vbyellow
mystockcontrollabel.backcolor = vbred
another approach is to run the report say everynight so the buyer gets it emailed to them so they have it to hand when they come in from work. use a common backend that has the data and a separate front end. one that is kicked off by windows scheduler calls the autoexec macro to start the process OR just tell the buyer to open the form when they come in in the morning OR have a query which extracts the data and plonks it into an Excel spreadhseetI'd rather be riding on the Tiger 800 or the Norton
02-14-14, 19:03 #3Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007