Search results

Hi trying to design a very simple spreadsheet that calculates wages. the problem I'm having is this I have one sheet that has all the personnel detail 1 line per person (data) I have another sheet that has all the times. on this sheet one person has 4 rows (input) The key details are...

HI hoping someone can help me I hope this will make sense I have a form that calculate the price of a job ( using a query to retrieve and calculate the data ) This form is used in two main forms ( as a subform ). The fields that need to be passed to the query are the same on each of the...

Hi Hoping someone can help me I am trying to have 2 main forms and 1 sub-form were the sub- form show the same information but is based on a query with criteria from the main form. Rather then having to create 2 query's and 2 sub forms is there a way of telling the query to pull the criteria...

Hope someone can help I've done a query by form ie the user can select their own criteia via drop downs. What I need to do is, if there is more then one crtieria , the second drop down needs to only show data from results of the first criteria at the minute the query is run when the user...

HI Confused below is some code I'm using to filter a report on opening. Private Sub cmd_specfic_Click() DoCmd.OpenReport "rpt_specfic_panel_time_detail", acViewReport, , _ "[house number]='" & Me.txt_h_no & "'" And _ "[project code]= '" & Me.txt_pc & "' " And _ "[panel ref]='" & Me.txt_p_ref...

Please help no matter what I do I get a type mismatch error 13 with the code below. If I try them seperatly they work If I feed the filter directly into the report it works but as soon as i use the code below I get the error The house number is a text field and the run date as the title...

Please help I want my DB so that 1 report can be filtered easily by any user with as little interaction as possible so I have a form that has combo box's linked to differant fields the idea being that an operator can select for exmple a project code and on the press of a button the report is...

Hi I need the data for a field to be calculated from 2 other fields so the user enters for example the start time and finish time the db then calculate the differance and put that in another field which the user can see on the form.. I know best practise is to use reports and queries for this...

Can some one help please I have 3 times Start time finish time Downtime I need to calculate the total hours and minutes that the machine is running for IE (start time - finish time )-downtime as it needs to calculate for a number of machines the total time will go over 24hrs which is why I...