Hi Guys
I have almost no experience of VBA outside of working a little with codes generated for me like docmd etc. If I can explain in English what I am trying to do can someone point me in the right direction to start creating the code.
I am trying to create a database for resourcing staff.
Can anyone help me get started?
23/06/2014, 24/06/2014,25/06/2014,26/06/2014,27/06/2014,30/06/2014,01/07/2014,02/07/2014,03/07/2014,04/06/2014,07/07/2014 etc up to 18/07
I have almost no experience of VBA outside of working a little with codes generated for me like docmd etc. If I can explain in English what I am trying to do can someone point me in the right direction to start creating the code.
I am trying to create a database for resourcing staff.
- I have a form where the user inputs a start date and an end date which updates a table.
- I have a query that works out the number of working days between those dates.
- I have a table with all the working dates between now and 2016
- I want to put a duplicate record button on the form (I can do that bit)
- The tricky part is I want it to create a new record for each date in the dates table between the start and end dates.
Can anyone help me get started?
23/06/2014, 24/06/2014,25/06/2014,26/06/2014,27/06/2014,30/06/2014,01/07/2014,02/07/2014,03/07/2014,04/06/2014,07/07/2014 etc up to 18/07