Dear Teacher, When I entry 2 or 3 stock out transactions of the same product, the data in field "SumofQuantity Added" of Query "Remains" is increased double (for example: firstly, stock in of keyboard is 200. after you stock out keyboard 6 then the stock in of keyboard is increased from 200 to 400.). Please kindly check it again. Thanks.
Hello...sorry for this. Try watching this second video in the playlist and I'm sure you will be sorted. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sTQ9hYMXDe0.html
Hello, thank for the tutorials. They are the best ive seen. But the link to this partivular project is not available whilst you mention it is in the video
use the external tab in microsoft access to import from excel. but make sure excel sheet columns are consistent with that of the ms access table in terms of datatype and note attribute necessarily.
Great suggestion. You can add a minimum level field in the product table. Whilst having that you can call the field in queries to be used in further programmng
hi there, I can see that the stock remains query will not include some products if the stock out is 0. Is there a way around this, the other You Tube video has a completely different start of the stock management system but I really like this format is there a way to do it with this template? Ty
Hello sir I follow your tutorial but my quantity in stockin always multiply by everytime I add stockout and I don't know why it always multiply when I query it to calculate the remainings Can u give me any feedback?
sorry for this sir. Could you check out this video to correct that ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sTQ9hYMXDe0.html . If it is still not resolved afterwards, you can send me a message. Good luck
Hi the form showing a stock quantity only works when a stock out transaction is made, until then it does not show the stock. How can you get around this?
It's because you do this whilst the form is opened as subform. Try editing a subform alone I mean having on the subform opened in it's design view and this should work.
Sir I made as you thought us but after finalized I made new inventory unfortunately nothing being updated accept product TB kindly make new inventory in this project to understand clearly thanks
i have problem inserting the two buttons with the wizard add and delete in stock in form in stockings part. I can insert a button manually but then i'm stuck since i don't got wizard part... @40:10 mins. i don't know how to do that part with wizard or activate wizard
Hello, make sure you are not adding the button to the subform whilst it is in the parent form. Open the subform as a single form, add the button and the wizard will come.
I have the same issue; I tried a different way and it worked for me. Close the current "Stock In" form and go to "Stockings" form instead. From there, add the two buttons (New and Delete). Save it, Close the "Stockings" form and go back to "Stock In" form. I hope this helps you too...