Search results

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...

Please don't hijack my post to back up your arguements. It's an indication of your predjudice that your read my post to be an attack on all Americans. That post was ment against both sides of this 'debate'. Allthough I have to admit it's the Americans that are just rising to the bait set by the...

Oh get a life! I looked at your post history, you were posting from 1942hrs to 2357hrs yesterday and then your first post today is at 0735hrs. I wonder, where do you find the time to research all these facts and carefully formulated opinions you keep spouting.

Why does almost every thread in this forum end up with xenophobic UK vs. US arguments? Always with the same people, always becoming more pedantic as each side refuses to back down. I know who the antagonists are and their opinions, in my opinion, are worth sweet fanny adam. ;)

Create a table with all the report names. Create a combo box on your form that uses this table to populate it's list or just populate it manually with the report names, depending on if you intend to add more reports later. In the 'After Update' property of the combo box run a macro that opens a...

Could it be because on my [TrainingFrm] The perameter for the query is on the main form. If I was allowed to change the subform it would effect the queries results, therefore I can't do it. I'm thinking this because on the [Enter Hours] form I don't try and change the query perameter in the sub...