ms access macro creates only 8 records

aplimedia
aplimedia used Ask the Experts™
on
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:
1-1-2017
1-2-2017
1-3-2017
1-4-2017
1-5-2017
1-6-2017
1-7-2017
1-8-2017
1-9-2017
...
1-22-2017
1-23-2017

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?
thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
Post your macro to see what is going on....probably you have some validation rule on your table thats why the macro is not running correctly

Author

Commented:
This is my access database, when I create a record in "Creacionhoras" table, the macros should create as many records as days between Fechainicio fechafin in "dias" table
and for each day, as many records as times between "horainicio" and "horafin" in minutes intervals in the table "horas"

Please, try to add a new record in "creacionhoras" and you will see the records are not created property.

Jon
Datesandtimescreator.accdb

Author

Commented:
maybe in this example my problem is easier to see, can you please enter a new record in table1 for example:
firstnumber:   1
lastnumber:  500

macro should create 500 records in table2 but only 9 are created.

Is there a limitation in access macros creating records in a table?
Can I change this limitation?

thanks

Author

Commented:
last example
Database3.accdb

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial