Recent content by joebox8

Actually its now slow when I open/close and switch views for the form.. arg

My main from takes 1min 43sec to close(A lifetime!) everytime. What could be causing this? I reckon it has something to do with the linked tables to another db... any help would be greatly appreciated as this delay would not be loved by the bosses! :eek: Thanks

Hi... I'm new to access! Hopefully someone can help. My DB has one table, Its not very big however I have roughly 50 fields in it. 32 of the fields are named x1, x2, x3, x4, ....x32(corresponding to 32 text boxes on my form) I have Tagged each text box with "T". How would i work it so I can...

Thanks guys, Just got that there! where would i place that code and how would i phrase it in vba? Im very new to access!

hey thanks Gina, Still no joy... .AVG = (Nz(.x1, 0) + Nz(.x2, 0) + Nz(.x3, 0) + Nz(.x4, 0) + Nz(.x5, 0) + Nz(.x6, 0) + Nz(.x7, 0) + Nz(.x8, 0)) / 8 At the moment i have an input mask of "00.00" as that's the format the numbers must be entered, Would the 00.00 be messing that up? Also the...

Hi there!...I have a fairly easy problem(i think!), Just wont work.. Up to now my basic average system was just fine.. I have 8 text boxes that HAD to be filled before any calculations could begin! .AVG = (.x1 + .x2 + .x3 + .x4 + .x5 + .x6 + .x7 + .x8) / 8 Now they don't all have to be filled...