By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,253 Members | 1,690 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,253 IT Pros & Developers. It's quick & easy.

set reminder

P: 64
hi...hello..can anyone tell me how to set reminder if the item out of stock in access?
Apr 25 '15 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 5K+
P: 5,397
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).

Apr 25 '15 #2

P: 64
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 @zmbd
Apr 25 '15 #3

Expert Mod 5K+
P: 5,397
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.
Apr 25 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.