Recent content by Mous1

Thanks buddy, I can see now a result, but it s not the expected one , because 1-we need to count the number of orders, line by line by city by operation ID, 2-that correspond to the quantity field by ID by City 3-throwing the related date into those operation order records.

thanks a lot for your spontaneous answers Adam, still have this error message when the code reach the date row "update or cancelupdate without addnew or edit"

The Purpose of "quantity"? is the quantity of order forecasted for ID XXX in the City ABC SITE = CITY we can change the name and YEAR = 2020 for each OPERATION_ORDER : 2020 is the year where the order should be done. And the forecast table with bring us in witch specific month based on the...

thank you Adam for your quick answer. in fact, what I want is not you want a DATE for each OPERATION ORDER based on the ID from the forecast table but you want a DATE for each OPERATION ORDER based on the forecast from the forecast table. Yes, we can link the both table letft join on city...

hi everybody, I'm a VBA beginner and I need Please your help to create loop that will generate a date for each operation order based on a forecast by month. In one hand I've forecast table Site Operation_ID Month Quantity And in second hand detail table City Operation_ID Operation_Order...