Color box with tables values

[SaPires]

I have a calendar to let the users pick up the days and will be saved temporarily in a table to print but i only can display the current month in calendar, when the user change the month the color of the boxes change to normal, in attached i send the DB, i need help with the code.


In resume, the users select the days in calendar and when change from one month to another the days picked stay with color.

https://www.dropbox.com/s/5illuh5p5t...dar.accdb?dl=0

[rpeare]

if you're still working on this problem could you say if you are (it's 2 weeks old and I just looked at it)

From my understanding if you have picked (the background color of the day is green) and you switch months, you want the same days on the next month to be highlighted as well.

So for instance if the 1st and 2nd of october are green and you switch to november you want the first and second of november to be green as well.


Nothing gets appended to your temp table (TMP) simply by clicking the dates so what you're asking would likely involve building an array of dates which isn't too hard but I don't want to work on this if it's already done.

If you want to copy those dates after you hit your 'print record' button that would be a bit easier because you could just bulk insert data into the temp table adding a month to existing records. You would have to be careful for things like dates on the 31st of the month when the following month only has 28, 29 or 30 days.