Gasman
Enthusiastic Amateur
- Local time
- Today, 16:25
- Joined
- Sep 21, 2011
- Messages
- 14,238
Yes.
I had to modify the sql slightly to get the correct recordset, (for what you want at least). I removed TextInput field from the sql as I was going to get it with the functions. All you need is the InputDate for the recordset?
I then used the function to populate the textboxes.
Very little change to what was there. the key part was understanding how it all works, which is why I was not just going to give you the code. That way we would be back to square one. You would have code that works, but no knowledge of how it works.? The less you change, the better chance it will still work. I always tended to use existing processes when I could, rather than reinvent the wheel.
Once that is working, you can address the issue of coloring the text control differently if that day is full already.
There is method in my reluctance to just give code out, believe me
In fact I had to test it to see if I was correct in my logic.?, but as always there probably is another way to do it as well.
I had to modify the sql slightly to get the correct recordset, (for what you want at least). I removed TextInput field from the sql as I was going to get it with the functions. All you need is the InputDate for the recordset?
I then used the function to populate the textboxes.
Very little change to what was there. the key part was understanding how it all works, which is why I was not just going to give you the code. That way we would be back to square one. You would have code that works, but no knowledge of how it works.? The less you change, the better chance it will still work. I always tended to use existing processes when I could, rather than reinvent the wheel.
Once that is working, you can address the issue of coloring the text control differently if that day is full already.
There is method in my reluctance to just give code out, believe me
In fact I had to test it to see if I was correct in my logic.?, but as always there probably is another way to do it as well.
