Search results

I will, thanks a lot.

Hi Sorry, I don't mean a simple new solution rather it is still what arnelgp suggested, however I was unable to combine two conditions in the update statement then I made it work. I also created a new field in table size called ItemMinimum to compare with when the user reaches the minimum...

Dear June7 I appreciate your input very much, however, I just figured out a simple solution for my issue. Thanks again.

Hi When the form loads it goes to a new record, You can use the navigation button to go back to see data. Open table tblPatient to see MRN to search for. I agree that what I am trying to do is not a good solution but I am doing this personally for my department and it is just enough to stop...

I want to deduct the prescribed item (e.g. what user choose in combo62 under tab Walking Aids say) from the ItemQuantity in table tblSize until we reach the ItemMinimum in tblSize then stop the user from completing the field and give him/her a msgbox saying "no more items available" This is in...

Thanks, I got busy last few days, I will try to send it soon.

should I send only the front end !

I don't know it just does not allow you to move any where, means if you click somewhere else like click on save or go to another tab it does not go. When you remove the code then everything is back to normal.

I also tried the following in the before update of my combobox but not working, I don't know what is wrong in my tables ? Dim MyQuantity As Integer MyQuantity = DLookup("[ItemQuantity]", "tblSize", _ "[SizeID] = " & Forms!tblPrescribedItemsSB_Subform3!SizeID) If MyQuantity < Me.Combo44...

Dear arnelgp, I will appreciate it very much if you help me in finalizing this issue.

Thanks for your suggestion, however Because I have the two combos (item, size) cascaded, I moved the code in PRSB_Size not in PRSB_item and when selecting any quantity in the combo44 it is calculating but it exceeds 0 so I keep having negative numbers. This is what I put in the before update...

Not really, I will go through it later to learn the good way. Thanks

Thanks a lot for your help, one more thing, I want to stop the user from proceeding if the stock reaches 0 and get him/her a message saying "Out of Stock You can't proceed". Is that possible.

Thanks very much for your reply, but what is the easy way to do so.

Perfect, thanks a lot.

Sorry to say it, it is not doing anything to the stock table (tblItemsSB), When I run the query it subtract the new value, same thing like before. Sorry, I am not that expert.

OMG, it keeps deducting every time the combobox is updated. I did not notice that, thank you. It looks I have wrong query. Now what should I do.

It is a combobox limited to 1,2 only.

Hi everybody I created this query (pic-3) to count down the quantity of any prescribed item and it is working fine and updating the table (pic-1) Now what I want is this: When the user want to update the quantity combobox (pic2), I want to show him/her a message box saying either "There is...

Thanks