Hi All,
I’m trying to write a Rota planning system.
The actual programme is working ok except it would be great if the user could see a screen showing which employees were already allocated to which job on which day. This is similar in concept to a spreadsheet page. Days across the top, Shift Venue and descriptions down the side and then employee’s names inserted where applicable.
I have a reasonable solution to this using a Pivot Table but am hoping someone out there has more elegant solution .
Ideally when the user enters a new shift using my frmRotaCreate there should be a pop up showing already committed shifts/workers.
Any ideas please?
Thank you
Alan
======