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

thanks fro the reply I have tried that the subform is linked via unique reference so that the jobs codes it pull up match are the correct ones for that job. The price of the job is dictated by the client and I couldn't get it to link to both so i need to put a criteria in the query which...

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

worked thank you very much

tried it still get a type mismatch error this may be due to my ignorance now so apologies if the code i copy below is "silly" tried a number if different combinations. MsgBox (" & Me.txt_h_no & " And " & Me.txt_pc & " And " & Me.txt_p_ref & ")

RuralGuy thanks for the reply but, I fairly new to vba so can you explain in a bit more detail please

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

Thanks fro the help worrked a treat

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

thanks for the help I did read the inforamtion in the link you posted but didn't pick up the format issue my bag thanks again

found the answer to the side question it's microsoft being ever helpfull when using VB if someone can show me how to send the information to VB in us format I'll be gratefull

thanks fro the help can you expand a little please Below is the code I use to send the date to the report, how do I then tell it to change the fromat to us DoCmd.OpenReport "rpt1_detail", acViewPreview, , "[run date]= #" & Me.txt_report_date & "#" thanks again as a side question why is...

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

Thanks for the advice it worked a treat

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

Thanks for the help will test and let you know

Thanks for the reply yes the downtime is a quantity of time As it's not me using the dadabase is there a way to convert 1.20( 1hr 20min) to 80mins if theres not then I'll just have to make sure the forms they use to collate the data are fool proof

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