Search results

That's grand of you to help out, and so speedily, thanks very much. Simple perhaps, once it's pointed out... But, as a struggling novice, I do find it difficult to pull together all the strands of half-learnt, part-comprehended bits and pieces of SQL and VBA. IIf has been one such for me. Maybe...

In my table I have two date fields (accomStart and opStart). In a select query I need to fill an expression field with the earliest of those two date fields. Could anybody give some guidance on how to do this, please? (I do also have 2 matching Enddate fields but am presuming any solution to...

False Alarm Sorry, false alarm... Not sure how nor why but that problem seems to have righted itself. I reconstructed the Form and it behaves just as i'd hoped... No need for the SetFocus correction and no sign of any scroll bars...! Yet I feel I'll be back with lots more need for help before...

What I have is 1 main form (let's say: MF) and 2 subforms (say SF1 and SF2). Both are to be positioned beneath the fields of MF. SF1 is always present but can have varying number of records (i.e. its height will not remain constant). SF2 is optionally present, depending on checkbox in MF...