Search results for query: *

Hello there I have a problem with a program, what i am trying to do is have a form that calculates employee performance. There are two fields, one is Name and the other is items sold. What i would like it to do is to store the best employee performance in the summary. Including the name of...

Thanks alot for the responce's....I will try out your suggestions. have a nice day! BT24

Thanks for the responce....I had to go back and bring all data back in. I wonder if it could be that the backend is in \\Ykr-fs1\Trans_Works\TW_Water_Wastewater\Works\W00 - Works General\TruckDB\OICDatabase.mdb" and so far back. would this have any baring on it. Also should i split the...

Hello Please can someone help me...I have a database and i never thought that it would be growing so fast, and i recently tried to split it and now no one but myself can get onto it. The backend is on the network and the frontend is also on the network but each computer has a short-cut to the...

Thanks for the reply this is what i am using for the calculation: Private Sub Finish_Time_ofCallout_AfterUpdate() Dim ElapsedTime ElapsedTime = DateDiff("n", [Start(time)ofCallout], [Finish(time)ofCallout]) / 60 [Duration] = ElapsedTime End Sub But if the Time is 12pm and i want to...

Hello My question is this, is there a way to have more then one control source. Why i want to know is because i need the text box to calculate a duration and then fill a field in the table. what it does now is that it will fill the table but the number is calculated after another text box...

Thank you MichaelRed that also works great BT24

Wow!! that worked perfectly! thanks alot for the help, sorry about the 3 extra submissions. BT24

Thanks But how will i write it so that it will populate the Duration text box? will i write it as Private sub Afterupdate_Duration() DateDiff("n",[Start Time],[Finish Time]) end sub is that what should be in the expression? thanks again BT24

Thanks But how will i write it so that it will populate the Duration text box? will i write it as Private sub Afterupdate_Duration() DateDiff("h",[Start Time],[Finish Time]) end sub is that what should be in the expression? thanks again BT24

Thanks But how will i write it so that it will populate the Duration text box? will i write it as Private sub Afterupdate_Duration DateDiff("h",[Start Time],[Finish Time]) end sub is that what should be in the expression? thanks again BT24

Hello What i need to know is how do i get a calculation to work when i already have a control source for a text box... What i have is a Start time box and a Finish time box but what i want is afterupdate of the finish time box that the duration text box gets a total of hours worked desplayed...

Wow thanks, i must have had a brain cramp yesterday. sorry for wasting your time Bt24

Hello I have a form and i would like to make it so when a Truck # and a date are entered that that is the only time that it can be entered for that truck and that date. The truck number field is based on a query and the date is used with Now(). if you can help me it would be greatly...

Hello there My problem is that i have a form and what it does is a simple filter of areas and locations inside that area. what i want is from what has been chosen on that form to filter all the main forms onto a report. if this is to vague sorry. thanks for the help BT24

Thanks again!! i should have known to look at that. BT24

Thanks The reason that i used the qryEmployeeName is because, the qry is bound to a Report for lookup purposes and it was just easier to use it then to make a new query and change all the setting on the Criteria Lookup form and the report. thats all. i thank you for your help but what do i do...

Okay what i did is put all the information in the columns and it is working but it will not let me have a null value in the fields and some of the operators dont have certain levels. so now how do i make it accept having a null value? Thanks for the help BT24

Okay what i did is put all the information in the columns and it is working but it will not let me have a null value in the fields and some of the operators dont have certain levels. so now how do i make it accept having a null value? Thanks for the help BT24

Lets see if i can give you more info. The form looks like this: The Fields are like this EmployeeName (combo box)bound to SELECT DISTINCTROW [qryEmployeeName].[Name] FROM [qryEmployeeName]; then there are two text boxes that are named WaterTreatmentLevel and WaterDistributionLevel...