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

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?

My advice is stop what you're doing. Bin your current DB, chalk it up to experience. Read up on Normalisation and start again from scratch. I did exactly the same as you. I ignored normalisation at my peril and had to bin weeks of work. You're in a real mess with your current DB, and it'll...

What's going on with your table structure? There's tables that blatantly should have a relationship but don't. You really need to sort that out before your forms. It will make things alot easier.

:confused: You're confusing me now. Could you post your db or even a screen shot of your form. I'm not sure what you want to achieve. Do you want an object on your form that when you click it, it updates a text box with the current time and date? If so a button would be better than a check box.

This doesn't save anything. It just displays it. Assuming that is what you want, create a check box on your form then use the code: If Me.checkBoxName Then Me.txtlastupdated = Now() End If

Not sure if this question should be here or in the query forum, but here goes. On my [Enter Hours] form, I have a query as a subform. I'm allowed to type in this subform and it updates the [Hours] table with what I type ([Hours] is the table that the query is run on). I want to do the same...