Hi guys.
Have had a look around on this one and surprisingly can't find any answers. I'm simply trying to return the first record for each day based on a [Date/Time] field (see screen shot example below). Any help would be greatly appreciated.
I managed to get it working using VBA with the label. Only issue I now need to figure out is to apply it to each record individually as the data in the first record is affecting the label on all remaining 12 records. Would this be due to it being a 'Continuous Form'?
This is my validation rule:-
But i get no result:- Record one txt box should display 'Available' and the others should not, but the rule doesn't seem to be working.
Hi gang.
Trying to make the label 'Device Available' not visible if the 'Date In' field is not blank using code. Can anyone help out? Thanking you in advance. (screen shot attached)
When trying to remove the database it doesn't recognise that there it is in fact already password protected and only gives me the option to Encrypt and not Decrypt. I can feel a breakdown coming on....