I have a very single macro in access which is executed when I create a new record in table1 (after insert) , table1 has 2 fields: date of start and date of end.
When I add a new record, macro should create so many records in table2 as the intervale of dates I have entred in table1.
for example, if I enter in table 1 : 1-1-2017 1-23-2017
my macro should create in table 2 next records:
for any reason the macro creates only 8 records, from 1-1-2017 to 1-8-2017, I think maybe is caused by sequrity reasons in macros of access.
Is there any solution?