Recent content by owen

Wow. Thanks ever so for both great answers. I'll go and try now.

I have a bunch of figures used in a report which are each associated with a day of the week. I want to sort these figures by the day. The day is a string literal 'Monday' through to 'Friday'. Can't use weekday as I don't use actual dates. Do I have to put the days into a table with a number...

Simple question from a novice.. I have multiple forms (each with a slightly different format but shouldn't affect the code), each form on a click of a command button performs the same task in calculating a bunch of figures which are put into variables then updated back on to the form into text...

woohoo just tried this and it works! - thanks. Didn't realise there was a controls collection - learn something new every day..

Thanks for that. I've been using a variable though to get the checkbox name because the digits vary to save hardcoding each name. Here's a bit of the code: strCheckboxName = "chk" & intDaySubst & intSessSubst testname = Me.strCheckboxName strchkbox = Nz(testname, False) was doing the last bit...

Excuse my ignorance I am a newbie to vba and attempting to learn as I code.. Have a form with multiple checkboxes with names from chk11 .. chk 57 where the first digit represents a day and the second digit represents a 'session'. In my code, I want to loop through each session within each day...

Hi thanks for that - the reason I used a loop through a recordset was because one of the dates in the calculation was gotten from the previous row - so I moveprevious, get the date, then movenext to carry on - is there another way to grab this previous date. I thought this morning about creating...

Please excuse my ignorance, am teaching myself vba whilst trying to construct a database.. my problem is that, in report code, I use a do while (not .eof) loop through a recordset based on a query - within this loop, a variable calculates the number of days for each row then loops to the next. I...