Search results

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

Much obliged, for your updated Function, Hey! I don't think I've explained myself correctly. As I stated in my OP.. I wish to just have a variable that once set to Public (at say after initial login), I can/will use throughout the Test.dmb meaning no matter if I open and close forms left, right...

Ok I've created a simple example of what not works ..thanks

Thanks, though I am not that sure how too So I tried with a sub Loggedonuser = GetCurrentUserName()and within a module any module public Loggedonuser as string So results =...inside the sub same as before and outside nothing happens out side it. ????

Thanks , yeh you helped me out on another forum, Thanks..but I don't know what a modDefinitions is, I tried google but was useless...If you mean a module then which one as I have lots of modules or in all of them or ?? Can you tell me in Laymans terms (English) please !

Hi Everyone! I am struggling with how to make a variable available throughout my Ms Access Test.mdb I am not that up on how to do this and have tried unsuccessfully to achieve this. I know how to pass a variable form one sub to another but that is about it for my level of expertise , can anyone...