Search results

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

Hi again guys. Trying to Compact and Repair my database however it keeps asking me for the password. After having to re-enter the password 3 times I get the 'Not a valid password' message. Ordinarily when performing and Compact and Repair you're prompted for the password once, you enter it...

Hi guys. Not sure why but one of my Forms is allowing Edits after I have set the 'Allow Edits' property to 'No' both in the Form design and in the 'On Load' event. Anyone have any ideas why this might be occurring? I'm not having this issue with any of my other databases. Thankyou in advance.

I did have the code in the 'On Current' event. I've moved my 'End If' comments as you have illustrated. For some reason I though if you had multiple 'If' statements you placed all the 'End If's' at the end. My bad. Thanks again Arnel.

So i've added in more of the fields to be updated but only the first field that is 'True' is being updated. Clearly if missed something :-(

Fixed!! Damn label property was 'Transparent' and not 'Normal'. Thanks so much Arnel (y)