how insert 8 month in table by 1 button

[POM]

Hai all please help me to insert in my table 8 month by using 1 click like this

row one 1/2/2015
row two 1/3/2015
row three 1/4/2015
.
... row Eight 1/9/2015

 

[pbaldy]

Generally speaking the tools required would include a For/Next loop, the AddNew method of a recordset and the DateAdd() function to increment the date inside the loop.

 

[Chintsapete]

You can do that in excel, put the date format in the first two cells and pull them down to the last date. Copy the column and paste it into your table. You have to make sure that the line numbers match though, else it wont work.

 

[POM]

thanks guy

dear pbaldy could make a simple db like i want please do for me
i don't know how create this function

 

[pbaldy]

This should get you started:

http://www.baldyweb.com/Function.htm