Recent content by Gint3232

So sorry, but you've lost me, I am not sure what your asking me, I only have two textboxs one is solely for hiding the other in order to prevent access/entry to it. Other than that it would not be on the form, if that helps explain things! Thanks

Thanks for that, Also, will this work for locking combo boxs as well, or ?

Just a thought, is it possible to programmatically send a text box to the front or back or will the same thing happen again and all instances will go to the back or front?

Thanks, What I am attempting to achieve is : If a user clicks a checkbox then I wish to prevent access to an adjacent (other)textbox, by means of not visible by either hiding it or setting just that Text (not all of them to not for editing) or alternatively overlaying the textbox so it appears...

thanks for your suggestion, The thing is my checkbox is bound and therefore acts as it should do, the issue I am having as I said in my O/P is that all textboxs(which are also bound) either get hidden or become visible, when I use my code which runs off the checkbox.event, which doesn't really...

I have form that has a textbox that overlays another Textbox, I am attempting to hide one textbox and make the other visible depending on the checkboxs value = "True" or "False" . I have placed my code on the afterupdate event, but the issue I am having if I click the checkbox on any row , then...

Thanks, everyone for all your input I did exactly as in the link here and therefore now have working true average.

Yes correct on all of the above, but not on the rest Our Org, bases allocation on the person with the least amount of accrued hours, gets asked first. So for that reason its crucial that new comers get allocated a fair average if they come in mid-end financial period, and are not not...

Hi Roger, I think I have found the fairest way to do this maths wise, but vba group query wise Not sure!, https://gcseguide.co.uk/maths/statistics/average/ As below is the fairest example in my given situation When you are given data which has been grouped, the mean is Sfx / Sf , where f is...

Thanks for your suggestion, Yeh! I already had an alias within the query qry AverageHours, I just realized that none of these averages even if I got them to run would be a close to true and fair representation of averages, So I am thinking the best possible way would to 1. divide/split the...

Thanks for your patience, I amended the sql to reflect what I think was your suggestion. as follows: UPDATE tbl_staff SET tbl_staff.hours = DLookUp("[hours]","Qry_AverageHours") WHERE (((tbl_staff.hours)=-1));note Qry_AverageHours now filters the -1 out I now get an error message "unknown"

Thanks, as I said in my OP I have already created a query that averages 'hours' within 'Tbl_staff', I can easily amend to excluding 'hours' of -1, but not sure of the rest your suggestion ..meaning how to incorporate a Dlookup function into the same query!

I am having difficulty attempting to update all records in a table that match the value -1 in a field named [Hours] with the average value to that to that same field. At the moment the sql view shows the following UPDATE tbl_Staff SET tbl_Staff.hours = Avg([hours]) WHERE...

My issue with the function was when stepping through my code I had to go through the Function line by line, but now that you supplied a much more simplified version its now not an issue, Thanks for all your help

Can't get any of this to work ,do you have a working.mdb example