Re: Finding, Searching and next available Date return to UF TextBox
Having taken a look look at the amendments we are definitely moving in the right direction. What you have coded works so far well thank you.
What I did notice during testing, is that the date search only seems to look at the last iPad selection entry in the list of return dates, e.g. If the chosen iPad is booked earlier in the sheet - refer row 2 retuning 28 October, the coding won't pick this up suggesting the lookup date function is searching for the last entry - or bottom up (?) which you made reference to earlier in our thread.
I would like the code to find the latest date in the return (booking in) list, so if I enter today's date for booking out, the code I cannot as the selected iPad is booked out until 28 October.
The other item I noticed, if there is a few days in between dates, the code only allows the next available date based on latest booking in (return) date. e.g. iPad 1 booked out 10 Oct to 12 Oct, then another booking for the same iPad 15 Oct to 19 Oct, then the same iPad cannot be booked out between 13 and 14 Oct.
is is this something that can be adjusted or is this not possible?
I belive this is your question earlier looking from bottom up for last entry. I would like to search all booking in (return) dates column for the specific User selected iPad so that the latest date (or longest date) in the list dictates the next available booking out date.
If you look at the your provided update example re-attached, you will see those entries I have added, where I can enter dates in October for iPad 1, yet in row 2 it has already been booked out until 28 October. I hope this makes sense?
if we can tweak this bit, we will be over the main hurdle, as I think the other bits will fall into place.
In parallel, I am adjusting the UF to control the user more appropriately when entering date to force the check in.ine with your current adjustments so will share when completed.
look forward to your feedback, thank you