Supermom
asked on
Special Feature in MS Access Database?
I have very little expiernce in MS Access. I currently use Access to keep up with my inventory. I have managed to edit the program slightly to fit my needs, but i am unable to do one thing that seems so simple.
I need an indicator to flash up when a part number has the same amount on hand as the minimum on hand level. I have managed to create a query that will give the information. I also can get the program to send up a message box, but it does this on every part number. I need to limit it to the part numbers where the two specific fields match. I am doing this with macros since I have no idea how to use Visual Basic.
Any help is greatly appreciated.
Supermom
I need an indicator to flash up when a part number has the same amount on hand as the minimum on hand level. I have managed to create a query that will give the information. I also can get the program to send up a message box, but it does this on every part number. I need to limit it to the part numbers where the two specific fields match. I am doing this with macros since I have no idea how to use Visual Basic.
Any help is greatly appreciated.
Supermom
Seems like a pretty easy thing but i would probably need to see the db. if it's not to confidential can you send a copy of the db and where (what form etc) you want this to happen? I can add the code and explain what I did if that helps. funke@ravenswoodsoftware.c om
If you are using a form for inputting this information (are you?), then you can just put a macro in the AfterUpdate event of your PartsOnHand field that has a condition that checks to see if it equals your PartMinimum.
When creating the macro, turn on the Condition column (11th button in on the toolbar), and put in a condition of (for example) [PartsOnHand] = [PartMinimum]. Then put an Action of MsgBox, and fill in whatever message you want displayed in the Action Properties.
When creating the macro, turn on the Condition column (11th button in on the toolbar), and put in a condition of (for example) [PartsOnHand] = [PartMinimum]. Then put an Action of MsgBox, and fill in whatever message you want displayed in the Action Properties.
ASKER
Funke,
I will send you a version of the Database and see what you can do. Please send me your e-mail and i will attach the specs.
I will send you a version of the Database and see what you can do. Please send me your e-mail and i will attach the specs.
try a loop.
Do Until Me.PartsOnHand = Me.PartMinimum
MsgBox ("Your parts on hand equals minimum parts.")
Loop
Do Until Me.PartsOnHand < Me.PartMinimum
MsgBox ("Your parts on hand are less than minimum parts.")
Loop
need help applying the code?
nex
Do Until Me.PartsOnHand = Me.PartMinimum
MsgBox ("Your parts on hand equals minimum parts.")
Loop
Do Until Me.PartsOnHand < Me.PartMinimum
MsgBox ("Your parts on hand are less than minimum parts.")
Loop
need help applying the code?
nex
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
BCAD,
I am using a form, but the info in the form is only updated after an item is allocated or picked from inventory. Where else can i place the macro?
I am using a form, but the info in the form is only updated after an item is allocated or picked from inventory. Where else can i place the macro?
When you say "allocated or picked from inventory" what exactly do you mean (because any change to the field will trigger the AfterUpdate event). Is this form being used for data entry purposes, or for viewing only??
ASKER
BACD,
Viewing only.
Viewing only.
Use On Current- if you go from one record to the next, you get the desired results.
When you say "allocated or picked from inventory" what exactly do you mean (because any change to the field will trigger the AfterUpdate event). Is this form being used for data entry purposes, or for viewing only??
Sorry about the repeated post...I mistakenly refreshed and it reposted!!
As CRaqsdell said, OnCurrent would work as well if no actual changes are being made to the info.
As CRaqsdell said, OnCurrent would work as well if no actual changes are being made to the info.
supermom,
you must change a field or click a button when you drop the inventory, right?
p.s. did you eval my code, or at least look at it?
nex
you must change a field or click a button when you drop the inventory, right?
p.s. did you eval my code, or at least look at it?
nex
ASKER
CRaqsdell
That works perfectly and it was not hard!! Can I make it flash so my boss does not miss it????
That works perfectly and it was not hard!! Can I make it flash so my boss does not miss it????
ASKER
CRaqsdell
My text box wants to be bound to other info so it comes up #name. Am I using the right type of text box?
My text box wants to be bound to other info so it comes up #name. Am I using the right type of text box?
ASKER
nex,
I do not know how to eval the code? I do not know what a loop is and do not know where to apply it. I thank you very much for trying to help me.
I do not know how to eval the code? I do not know what a loop is and do not know where to apply it. I thank you very much for trying to help me.
make the warning bigger and a bright red. unfortunately, no flash. sorry (at least without a lot of code)
Not sure, but you could try an animated GIF instead of the text box...
No, you need a Label, not a text box. Sorry... my bad...
ASKER
THANK YOU SO MUCH!!!
This has made my day!!
This has made my day!!
I tried an animated GIF, and it just sits there in Access... no animation...