Search results

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

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

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

SELECT Training.ID, Training.StaffPIN, Training.Module, Training.DatePassed, Training.DateExp, Training.Comments FROM TrainingModules INNER JOIN Training ON TrainingModules.[TrngModule] = Training.[Module] WHERE (((Training.StaffPIN)=[Forms]![TrainingFrm]![StaffPIN])); Does anyone know why this...

It might be an idea to have a noob forum where newbies like me don't feel like an idiot for asking simple questions. It could have stickies for the most common questions. The top sticky would have to be froum rules: search before you ask, what info should be in question etc... A sticky for...

Don't worry, this isn't about parameters. I've searched the forum and can't find the answer to this (but loads on crosstab perameters!). I have a table: DateWorked | StaffPIN | StartTime | FinishTime | ShiftType ------------|-------- -|-------- --|-----------|----------...

I want to combine the data from 2 tables in a report. I think I need to do this through a crosstab query, but I've no idea how as it needs to calculate it's data. The row heading needs to be [DateWorked] from the "Hours" table. Each Column heading needs to be every [StaffPIN] from the...

I started a thread in the VBA section about a problem with a function I'd written. I think it's more to do with how I'm implementing it in a query. http://www.access-programmers.co.uk/forums/showthread.php?t=139066 Please help.

Edit: 6th post (5th reply) is simpler version of the problem This function works in the immediate window of the VB builder. When I use it in a query it throws up an Invalid use of null error for each reccord. Public Function dayMissedHours(WorkedDay As Date) Dim s1 As Integer If...

I need to wite a function that will count the number of field in a record that are not null. I don't want it to count all fields that are not null, just the fields specified in the function's code. The record's index is passed to the function as an argument. The solutions that I think I've...

This line keeps throwing an error: DLookup("[NoOfStaffRequired]", "Hours", "[DateWorked] = " & WorkedDay) WorkedDay is a variable passed as a Short Date in to the function. It is Declared As Date. The [DateWorked] field in the 'Hours' table contains Short Dates. The error I keep getting...

I'm new to Access, so please be patient. I'm trying to write an expresion that will work out how many hours were missed from a given shift, using the start and finish times, how long the shift was ment to be, and how many staff showed up compared to how many were ment to. The expression is...

I want to refresh more than one text box after a combo box is updated. The text boxes contain expresions that use the info from the combo box. If the combo box changes, the text boxes need to change. I know that to refresh one text field I put "Refresh([textbox])" in the "After Update" field of...

does anyone know of a cheap/free 3rd party programme that can query multiple .mdb files (in the same directory) and generate a custom report? It needs to be as user friendly as possible.