Recent content by JEA

Thanks for the reply, but I want to sum all the values in a column not row. The values in the column are calculated using workedHours(), according to Access help, I can't just sum them. I have to calculate them again and then sum them in the same statement. The workedHours() function takes it's...

Not trying to argue, just curious. Would the square parenthesis not be enough to show that any quotation mark in 'ComboTitle' is part of the control name?

Try "[Title] = '" & "(Me.[" & ComboTitle & "])" & "'"

I want to do a For each loop on a column of textboxes on a report. The number of boxes (rows) is not constant so I was hoping to achieve something like this: Public Function SumCalculatedColumn(columnName As String) Dim ctl As Control Dim rpt As String Dim runningTotal As Int...

Is that because you're opening the report in print preview? When I use the print button on my reports, it is in Report View. The button works for me in this view (Access 2007). All you need to do is add the above code to the on click event when you build the print button in a form, before...

Ok, trying to use this in a textbox: =SELECT Sum(workedHours( [Day1] , [StaffPIN] )) AS [Total Worked] FROM [Service Schedule Query_Crosstab] in the hope of performing workedHours() on each [StaffPIN] (row), for the collumn heading [Day1]. Cay anyone help?

Try creating the button as I described above and using: OtherControl.setfocus ButtonName.Visible = False In the On click event. Can't claim credit for this. It's The_Doc_Man's and adsmmg's work here...

I use a print button on my reports. I use the wizard to build it on a from, then copy and paste it on to the report. It works, but the button does print.

OK, think I can now give a better description of the problem. The Report is in the format: [StaffPIN]...|.......................[Day1]..............|.......................[Day2]..............|.......................[Day3]..............|...

I'm struggling to find a way of creating a column total in a dynamic report. My db is attached below. If you open the form [ServiceSchedDateCollector], enter 01/11/07 and click the button it will show you the report I'm talking about ([Service Schedule Report]). I would like to have a Sum for...

Ok, let's get pedantic again... I take it you're implying that I was aiming that "xenophobic remark" at Americans. I wasn't .... etc (see above). I'm not going to trawl through all the past posts to prove you wrong, and neither are you judging on how you cleverly challenged me to do it. Can...

Yeah, you definatly wouldn't want to mention a "fanny pack" :D If you said "booger" in Cornwall you might get a few funny looks. :D

No, I live in the South of England, but am originaly from the North of England.

Try creating a brand new form. In design view, drag and drop your query from the navigation menu (on the left of the screen) on to the Detail section of your form. This will use it as a sub form. Resize your query, but don't make it the same size as the Detail section, leave a border. Put your...

Ok then, let's get pedantic... Lol, it is prejudice. I personally fail to see how the post could be misinterpreted in the way you misread it. In no way, shape, or form do I imply that post was targeted at an American, never mind ALL Americans. Just because I (purposefully) didn't specify who I...