How to automatically update stock levels in Microsoft Access

[@ITsEasyTraining1st]

How to automatically update stock levels in Microsoft Access. Check out courses at www.itseasy.co.uk or online at: itseasytraining.teachable.com/

[@hassanismail7963]

thank you very much , would you pls explain how we stop that massage for update q

[@ITsEasyTraining1st]

Do you mean the warning message?

[@hassanismail7963]

yes please !

[@Syameerajmi]

Yes , could you explain how the warning message will not appear?

[@ITsEasyTraining1st]

@@Syameerajmi I don't know how to disable it. I think you can do it in VBA but I don't know how

[@maximnaulaers5724]

Hello, I am struggling with the email add on in access. I am building a stock inventory and once a certain stock amount is below the minimum quantity, I want it to send an email to inform someone to order new items. But Access always sends the email double and I don't know why, are you able to help me?

[@ITsEasyTraining1st]

Would you be able to show me, can you send an example

[@maximnaulaers5724]

@@ITsEasyTraining1st Yes ofcourse, but I can't send screenshots in a youtube comment I think

[@maximnaulaers5724]

But as soon as in my table the stock quantity reaches a number which is lower then the minimum stock quantity, I want access to send a mail. Therefore, I added a "macro after update" in the table, stating that "For each record in" the table parts (which is the main table with all the information", where condition is stock quantity < minimum stock quantity --> send email

[@policeman87]

I cant make this work. I have no clue whats wrong :(

[@ITsEasyTraining1st]

ru following the example exactly?

[@policeman87]

@@ITsEasyTraining1st Im following your instructions and applying them to an assignment database im making

[@grannysaxton9568]

Very easy to understand thanks

[@ITsEasyTraining1st]

Glad it helped

[@EasyMSAccess]

Thanks for this

[@ITsEasyTraining1st]

No problem

[@liveoffline4317]

Thank You Sir❤

[@ITsEasyTraining1st]

Most welcome

[@libreofficetutorials9499]

I will use this

[@ITsEasyTraining1st]

good

[@Albertbullterrier]

Good info

[@ITsEasyTraining1st]

Glad you think so!

[@VenturiNL]

This is not good way to manage stock levels, its much better to add a table like ''StockMutations'' that tracks all mutations on the stock and add them all up to come up with the actual stock level.

[@ITsEasyTraining1st]

Do you have a video on it, so I have a look

[@VenturiNL]

@@ITsEasyTraining1st Im no youtuber, but think of it as a new table that has quantity, product, status. In which you store all mutations and track the status such as sold, received and then you have a query that adds them all up to calculate the stock level of each unique product. If you use a update query you can never backtrack if something is already reduced from stock or how that number came to be

[@ITsEasyTraining1st]

@@VenturiNL good idea

[@livingstonemainya1568]

Thanks but Improve on video clarity

[@ITsEasyTraining1st]

Ok next time