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

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

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

I did't mean to sound patronising. I hate communicating in text (much to my wife's dispair with SMS messages :rolleyes: ) as I lack a good enough command of the English language to express myself like I would with speach. (Even though it's my 1st, and only, language) :o Reading the above posts...

So, you've given the checkbox and the textfield the same name? How is Access supposed to tell the difference between the two?