Recent content by Gigitty

Thanks for the info Larry.

Thankyou Ken.

I did perform a Compact & Repair and it made no difference. I just performed the 'Decompile' and it seems to have solved the problem. Thank you so very much to you both. Any ideas why this may have occurred??

what is C&R?

Hi all. Set up a second form to open from my main form showing only records that contain a unique value (Patient Id). Works fine and as expected the first time. If I close then re-open the database, open the primary form the click the command button to open the secondary form I receive...

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.