Button to generate 2 years worth of data

[valgore]

Hello, I have a complicated question. I have a database that currently holds Employee data. I have a separate table that has their ID, the date (in days), the year, and the project they are working on for the given day. Basically, I'd like a button that populates these three fields with data for the next two years (730 days). The date field should increment for the days of the week (minus weekend) and the year to change once the date reaches 12/31. The project field can stay the same.

I am fairly new to Access so I'm having a hard time figuring out where to even start.

Thank you,

Josh

 

[KenHigg]

I don't think I'd go through the trouble of creating all the code and logic to do this just once every few years. Instead I would create the rows of data in excel and append it over. If you were a more experienced vba programmer and wanted to jump through the hoops of learning how to do it with vba anyway, then I think I would suggest doing this with DAO recordset objects...

 

[CraigDolphin]

Ken has given you good advice. If you do want to learn about DAO recordsets, you could start with this tutorial I found helpful once apon a time.
http://www.devdos.com/vb/lesson4.shtml

 

[valgore]

awesome, ill do it that way. thank you