Code:
If UnitsOnHand <= FrmParts.ReorderLevel Then MsgBox "This
BaneMajik
Last Activity: Dec 21 '07, 01:32 PM
Joined: Nov 7 '07
Location:
-
I have tried putting the code into the Afterupdate as well as the Change Events for the UnitsOnHand control on the Form as well as the Subform. No matter where I put the code it doesn't do anything. I have changed the values to be equal and less than ReorderLevel but there is still no change. I also tried adjusting the code when I put it in the subform UnitsOnHand contrel
... -
Thanks for all of the help so far!
The ReorderLevel is set different for different parts so I need this to popup the Message Box when the UnitsOnHand is equal to or less than the value entered in the ReorderLevel Field. I can't set the ReorderLevel for everything the same....Leave a comment:
-
Show message on certian conditions
I have an Access 2003 database that I'm building. In part of this DB I am tracking repair parts being ordered and used. I have a field called ReorderLevel that tells me when a parts on hand quantity drops to this level or below it needs to be reordered. I then have a UnitsOnHand unbound text field that is pulling the number of units on hand from an unbound text field also called UnitsOnHand in a subform (TblPartsTransa ction subform). The UnitsOnHand... -
That did the trick!
Thanks for all of your help again Rabbit....Leave a comment:
-
I just setup the Save Command button with the Command button wizard. So that is VBA.
Code as follows:
[code=vb]Private Sub SaveChanges_Cli ck()
On Error GoTo Err_SaveChanges _Click
DoCmd.DoMenuIte m acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Exit_SaveChange s_Click:
Exit Sub
Err_SaveChanges _Click:
MsgBox Err.Description
Resume...Leave a comment:
-
I originally couldn't get this to work so I took a break from this problem and worked on a few other things. When I came back it was no problem and I got it up and working right away. I guess I just had to take a break from it. Thanks for all of your help Rabbit!
I do have one other question for you, kinda dealing with the same thing, I am appending data to a different table in my database from a form to track equipment history...Leave a comment:
-
I got the append query up and running but I can't figure out what criteria to set in the query so that it just selects the current selected record in the form. Right now if I use a command button on my form to run this query it wants to append the entire table. I just want to append the current record that is being viewed in the form.Leave a comment:
-
Ok, I'll try that. Thanks for your help so far.Leave a comment:
-
As I am not very knowledgable about setting up a query so I didn't try too much with that. I did try a macro and had it bring up a message box with a confirmation. It properly cancelled but would not run. I thought I could use the CopyObject and DeleteObject action to make this work but haven't had any luck with those as well. I am not sure if these actions will work with a record in a form or not.
Here is how I setup the...Leave a comment:
-
Copy Data from Table to Table with Command Button
I am working with an Access 2003 inventory database. When a piece of equipment goes bad we junk it and delete it from the database. We have been copying the record to an excel form for storage just so we have a record of the former piece of equipment. I am trying to make the database more user friendly and keep all of the data in Access so have created another table called JunkedEquipment . I would like to be able to use a command button on a form...
No activity results to display
Leave a comment: