Hi guys, I’m a beginner in VBA.
In the Example.zip file I have a table “tblqryCountPerSore”. This table is created by the “qryCountPerStore Maketable”.
The table “tblqryCountPerSore” shows the number of products (A, B and C) per customer and storenumber.
Now. There a a number of reasons to delete a store from the “tblqryCountPerSore”-table (closed, no products, not efficient, not reachable, etc.). This can only be done by human interaction.
What I want to do in “tblqryCountPerSore”:
-For the shops that won't be delivered I want to be able to delete them from the table so I have a clean list of what will be deliverd.
-I want to be able to send an e-mail to the shop that are deleted so the won’t expect any products. Als for the shops that have no products.
-Somehow it must be clear witch product (from tblMutations) are not delivered.
E-mailadresses are stored in tblStores. I necessary (for simplicity) I can put them in the “tblqryCountPerSore”.
Can someone put me in the right direction? Maybe there is a way to use checkboxes in the "tblqryCountPerSore”.