Recent content by Gigitty

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've taken another approach and solved the issue. Thankyou to everyone for your responses.

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'?

Didn't work. :-(

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.

Conditional Format doesn't allow me to format based on the data value of another field.

i've attached a copy of the database here, free of any data.

Sorry what does the 'NZ' refer to?

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)

very handy to know. thanks guys.

Just to confirm, yes database was corrupted and a restore has solved all the problems. Thanks guys.

Just to confirm, yes database was corrupted and a restore has solved all the problems. Thanks guys.

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....

I've got a horrible feeling that is the case.

Hey June7. Unable to compact and repair at the moment. Have just submitted a post regarding that. Something strange definitely going on here.. :-(