hi...hello..can anyone tell me how to set reminder if the item out of stock in access?
-
-
Well, you need to be a tad bit more specific; however the general principle would be to run a tad of VBA code (or Macro if one insists) against your data looking at either your inventory count or some target value and then use a conditional to popup a message box, flag the cell, or any number of different methods.
Please review our sticky on how to ask a good question and try to reword your post (just make a new post within this thread, we can take care the housekeeping).
-=---
-=--- -
Thanks for replying....How do I start...just now I trying to set the validation rule of the field [Quantity]<10 and for validation text is "Out Of Stock"...but it's only working in the table but not mention it to my form in access @zmbdComment
-
Validation rules are not intended for the purpose you have posted. These are intended to ensure that invalid data entries are not made (like a negative number when only positive numbers should be used or that date entries make sense.) What you have here would prevent data entry when the value in the current record field [Quantity]<10 which doesn't make any sense from reading your other posts (assuming that this is for your inventory project :) )
You really need to read thru the FAQ links in my first reply to your thread.
Once again, this will be a either an Access Macro or a VBA coding. You can do this within the form or (if you ACC2010 or newer) via table level macros as a sort of trigger.
IN any-case, the code will need to take your current entry, compare it to the formula based on your data, and then provide a prompt if needed.
We need some info about versions of the OS, Office/Access, tables and their relationships. Otherwise this thread will dead-end quite quickly.
WE do want to help; however, we need you to help us to help you by providing enough detail.Comment
Comment