Recent content by leddy

I'm trying to find out how to unlock the fields in the report design view like the original question - can you post how you did it please? Many thanks leddy Edit: ha, as soon as I posted I figured it out - you right click and go to Layout > Remove (for anyone else with the same issue ;) )

If Hour(Now()) >= 9 And Hour(Now()) <= 15 Then HTH leddy see Bob's post above ;)

Hm, I'm not 100% then, but I *think* the txtSchool value would still be bound anyway, regardless of whether it is visible or not - therefore, the beforeupdate event would work fine. As I said though, I don't really use bound forms much so hopefully someone will jump in here :) Have you tested it?

Is it a bound form? I don't use them much tbh, but if it was an unbound form, I would do it in the beforeupdate of the combobox

You could do it: If Me.cboSchool = "2" Or Me.cboSchool = "3" Or Me.cboSchool = "5" then Me.txtSchool.Visible = True Else Me.txtSchool.Visible = False End if HTH leddy

Hi all, I'm trying to amend a query on the fly, but it includes a function and i'm getting all confused with how I write it in vba so that I can change it (if that makes sense!) Here is the sql of the query as is: SELECT DISTINCT tempExport.ROUNDCODE, tblpafdata.Str, tblpafdata.PCD...

Hi all, Here's hoping you can help, this is driving me nuts! I have a report that is grouped by 'Roundcode', and I want to be able to print duplex, but in order to do that, I need to be able to make sure the first page of each 'Roundcode' starts on a new page. I've searched and searched and...

Thank you both so much, got it sorted! :D leddy

Hi everyone, In desperate need of help! :o) I have two temp tables, temp_qryTotals and temp_qryTotalsOnService temp_qryTotals: sDate TimeSlot sCount eCount temp_qryTotalsOnService: sDate TimeSlot osCount What I need to do is if there is a record in temp_qryTotalsOnService, where the...