Hello Everyone,
After searching for a week I found the attached to be close to what I want. The attached only works for weeks and not months or years. I want to be able select an event, indicate the number of occurrence say once a week, month, quater or year starting from a particular day.
If for example I select 01/08/2010 as the starting date of an event which I want to repeat once a month on Fridays for the next four months, my ending date will be 01/12/2010.
Once I press the save button, I want the code to be able to write into table the only four dates that meets the criteria above. The same will happen when I select week, quarter or year. Once I get this working I am confident I can modify the code so that I can use it for recurring invoices. I already have on my database, code to duplicate an invoice but I want to be able to generate recurring invoices too.
Any help would be greatly appreciated please.
After searching for a week I found the attached to be close to what I want. The attached only works for weeks and not months or years. I want to be able select an event, indicate the number of occurrence say once a week, month, quater or year starting from a particular day.
If for example I select 01/08/2010 as the starting date of an event which I want to repeat once a month on Fridays for the next four months, my ending date will be 01/12/2010.
Once I press the save button, I want the code to be able to write into table the only four dates that meets the criteria above. The same will happen when I select week, quarter or year. Once I get this working I am confident I can modify the code so that I can use it for recurring invoices. I already have on my database, code to duplicate an invoice but I want to be able to generate recurring invoices too.
Any help would be greatly appreciated please.