Excellent tutorial. watching this live, from kumasi ghana.
@datatechstutorials
2 жыл бұрын
Awesome! Thank you!
@faisalrafiq2107
Жыл бұрын
Thanks for sharing very useful 👍 Thanks for your efforts appreciated
@dezainsdezains5048
Жыл бұрын
Easy and nice way to explain
@christianadugyanson1547
Жыл бұрын
Very useful tutorial. Keep doing it
@datatechstutorials
Жыл бұрын
Thank you sir
@tevinmoodley349
11 ай бұрын
Thank you for the assistance
@datatechstutorials
9 ай бұрын
I'm glad the video helps you.
@tevinmoodley349
9 ай бұрын
@@datatechstutorials it did, passed a final year engineering project using some of your tips. Much appreciated.
@datatechstutorials
9 ай бұрын
@@tevinmoodley349 glad you succeeded bro
@dafinehun8874
Жыл бұрын
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.
@datatechstutorials
Жыл бұрын
Hello...sorry for this. Try watching this second video in the playlist and I'm sure you will be sorted. kzitem.info/news/bejne/1IqHn5yPhop1mGU
@dafinehun8874
Жыл бұрын
@@datatechstutorials Yes, thanks for your next videos. It's very helpful. My database is completed. Thank you so much.
@usmanyousaf567
Жыл бұрын
Thank you for the great tutorial. I am a noob in terms of MS Access, but I was able to make my own customized stock database based on your video.
@SothearakHeng
4 ай бұрын
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?
@datatechstutorials
4 ай бұрын
sorry for this sir. Could you check out this video to correct that kzitem.info/news/bejne/1IqHn5yPhop1mGU . If it is still not resolved afterwards, you can send me a message. Good luck
@asroofficial2044
Жыл бұрын
thank you teacher
@datatechstutorials
Жыл бұрын
you're welcome
@Charley-k3b
11 ай бұрын
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
@datatechstutorials
11 ай бұрын
Yes, there are two videos on inventory can you check
@lokalitepam8395
Жыл бұрын
A super video
@datatechstutorials
Жыл бұрын
Thanks
@Sillywitchlove
Ай бұрын
I LOVE your tutorials! So easy to folllow along. Thank you so very much!
@datatechstutorials
Ай бұрын
You are welcome.thanks for following.
@ams7039
2 жыл бұрын
This really helpful thank you. But where is the download link ?
@datatechstutorials
2 жыл бұрын
Sorry sir, unfortunately there is no download link for this lesson. looking forth to placing download links in future videos. Thank you
@josephmalcolmcaymo4852
4 ай бұрын
Wheres the link for the download file? thanks
@datatechstutorials
4 ай бұрын
unfortunately this file is not available
@kenowusu2155
11 ай бұрын
Excellent video. I have a long list of items but are in Excel. How do i import the list to my product list in access?
@datatechstutorials
9 ай бұрын
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.
@tuamaleos4519
2 жыл бұрын
Please share this file example MS Access... Thankyou
@datatechstutorials
Жыл бұрын
Ok wait
@totalcuretosexualdysfuncti9899
2 ай бұрын
Thank sir.
@sardaruzairtechno9346
2 жыл бұрын
sir please download link
@trent3191
2 жыл бұрын
This was very helpful! Thank you
@datatechstutorials
Жыл бұрын
Glad it was helpful!
@kumarabhijeetranjan2304
Жыл бұрын
Hi, thank you for the useful video. How can we add inventory levels like reorder level or minimum reorder quantity features. Thank you
@datatechstutorials
Жыл бұрын
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
@usamahameed5873
Жыл бұрын
How can i add the lest box like product name stockin dates and qty for each product separately. Same for the stockouts
@kaaviya8213
4 ай бұрын
Your tutorial was very much helpful ❤
@datatechstutorials
3 ай бұрын
Thank you.
@abbyjchannel8462
Жыл бұрын
Thank you sir, I successfully create my inventory, what I want to know is how to create the sales daily sales report and how to add amount
@credov.k2594
9 ай бұрын
good but not files to share?
@datatechstutorials
9 ай бұрын
Yes, sorry this file is not available.
@odunayoemmanuel6274
2 жыл бұрын
This is so helpful. Buy you forgot to drop a link to download this *winks
@datatechstutorials
2 жыл бұрын
Yes sorry sir, email me to receive the file.
@wanjeridaniel-qm5fh
Жыл бұрын
Thanks for the video but I need your help for I created the system but on the search button isn't working
@datatechstutorials
Жыл бұрын
okay send me WhatsApp message. Thx
@azharkhanlangah
6 ай бұрын
can i get this file please?
@datatechstutorials
5 ай бұрын
Sorry, currently we have lost this file. but you can check the playlist for similar ones
@SamiGhaith-by2yw
5 ай бұрын
🫥🫥
@essicstroman5485
Жыл бұрын
Best tutorial I've seen on MS Access. Thank you
@datatechstutorials
Жыл бұрын
Glad it helps sir.
@kennethfrank
Жыл бұрын
Hi, this is such an important video. Many Thanks
@datatechstutorials
Жыл бұрын
Glad it was helpful!
@atokwamena4139
Жыл бұрын
Please I want access to deduct loan principal and interest automatically from the customer's account every weekly or monthly
@datatechstutorials
Жыл бұрын
Check video description to contact me pls
@jamesmakau
Жыл бұрын
Am stuck where you are adding "new" and "delete" buttons to stockings form. when I try to add a new button the command box isn't popping out
@datatechstutorials
Жыл бұрын
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.
@deenourdunyaeksaath5784
2 жыл бұрын
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
@datatechstutorials
2 жыл бұрын
Alright sir. Thank you
@nightmare1411
Жыл бұрын
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?
@datatechstutorials
Жыл бұрын
please watch this other video to get around this: kzitem.info/news/bejne/1IqHn5yPhop1mGU
@tangopeter1
7 ай бұрын
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
@datatechstutorials
7 ай бұрын
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.
@MultiBert29
6 ай бұрын
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...
@mohei95
Жыл бұрын
Thank you for your effort but I can tell that you make the sample things goes very hard to follow
@datatechstutorials
5 ай бұрын
Sorry for this sir.
@simongunyali
Жыл бұрын
Hi....How can i use this system to calculate profits made?
@datatechstutorials
Жыл бұрын
you need to update it sir. You can contact me via the description for help
@MukweLaif
5 ай бұрын
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
@datatechstutorials
5 ай бұрын
Sorry sir. I will work on this so try to check later on.
@hafeez1434
Жыл бұрын
Sir, It was a very beneficial , How can i add the rate and multiply with quantities to see the value of stock ?
@datatechstutorials
Жыл бұрын
At product add rate, now call in in queries to perform such calculation
@mokkefuhua9928
Жыл бұрын
Once we know how much the remaining of the items went out, how do you calculate if another items is being added in or stock in?
@datatechstutorials
Жыл бұрын
This video in the playlist will help: kzitem.info/news/bejne/1IqHn5yPhop1mGU
@justiceeffuate4993
Жыл бұрын
how do I create monitoring systems of medical products in ms access
@datatechstutorials
Жыл бұрын
Contact me via email sir. Check video description for details.
@sopatsartajwani
Жыл бұрын
my tables show an error " no unique index found for the reference field of the primary table" while creating relationship plz help
@datatechstutorials
Жыл бұрын
ensure that, your foreign key is properly set as primary key in the source table
@rubenrivera1931
Жыл бұрын
@@datatechstutorials Hi, I have the same issues and the Primary key is properly set but still shows the error.
@rubenrivera1931
Жыл бұрын
I tried to redo it again and almost copy your tutorials but still the same.
@thomascolley5912
8 ай бұрын
How do we add pricing, package price, piece price, total out, total in of each item
@albayano
Жыл бұрын
thank you for this.... i am looking for the Print menu
@datatechstutorials
Жыл бұрын
ok sir
@opentrainingcamp
2 жыл бұрын
🥰🥰🥰🥰🥰🥰🥰🥰
@abufkes1
11 ай бұрын
👌
@ebadkhan3286
Жыл бұрын
Superb
@samuelbystrian559
Жыл бұрын
Hello sir, can I ask one question? Is it possible somehow to get a monthly summary of stock ins and stock outs?
@datatechstutorials
Жыл бұрын
Yes sir, it is very possible. a lil bit of querying and reporting skills will do.
@samuelbystrian559
Жыл бұрын
Do you have any additional video about this?
@datatechstutorials
Жыл бұрын
@@samuelbystrian559 check for additional videos in the playlist.
@CodingwithSaim
2 жыл бұрын
Best Tutorial which absolutely need appreciation
@datatechstutorials
2 жыл бұрын
Many many thanks
@CodingwithSaim
2 жыл бұрын
@@datatechstutorials I am also a KZitemr and I know how much difficult this is
@datatechstutorials
2 жыл бұрын
@@CodingwithSaim Yes you're indeed right.
@thilansasintharandeniya9747
Жыл бұрын
Hi
@datatechstutorials
Жыл бұрын
Hello, feel free to contact me via details in the video description sir. If it's regarding the tutorial kindly share here. Thx
Пікірлер: 102