Search results

Ok let me clarify better Time Finished 3/4/2003 5:52:58 PM - Start Time 3/4/2003 7:52:46 AM = total time 0.416805555556493 This is out of my query. How can I convert that total time to minutes?? Appriciate all the help

Thanks, but now I have another question. If the calculation in my query is bassically a: now()-now()=total time How do I convert the numeric value to minutes??

I have a database that tracks time worked on a project and the weighted average of that project. I need to take extended periods of time and calculate it out past 24 hours. I am usint ([time finished]-[time started]) in my query to get total time worked however I do not know how to add all the...

That sounds like a good Idea. The user asked For a msgbox to pop up on the workers screen when their job was getting close to the completion time. but I have never seen that done.. Maybe I can convince them to run the report at the start of each day. thanks

I have a database based on job submission with completion dates and times. Is it possible to have a message box pop up when a job is neering it's recorded completion time notifying the user that they are running out of time???????

thanks for the help

thanks for the help

I have an expression in a query that I want to give a value of 1 if true. the exp is: ([targeted completion date]<[time job completed])=1 However the only thing it returns is a 0 what am I doing wrong???

Thanks

I have a job tracking database with buttons that autofill the time/date now() into text boxes. The database will reside on the network. Is there a way I can link the database clock to the network so employees cannot reset their computer clocks and log in with a false time??

Thanks WayneRyan

After I convert my macros to VBA how do I change the controls to follow the code? Do I paste the code to the form? and can I delete the macros?

does anyone have a pop that will put both the date and time selected in your text box?

View your Inventory database I would like to take a look, I created one for Fleet management assett tracking and would like to see if there are items you included that I missed or maybee 'I doubt' things I have included that you did not Mark.kelly@pb.com

I have a database that was originally started based on the concept that only one person would work a job assigned to them. Now the USER! told me that the job might be large and has be able to be forwarded to another employee to complete. But I have to retain the same job Number so that time...

How can I lock a button on a form untill a new form is opened?

I am tryint to use a button "when it is clicked" it will enter the Time() into a text field. This is the code I am using but when I click the button nothing happens. any suggestions? Any help greatly appriciated Private Sub time_in_Button_Click() txttime_in.text = time() txttime_in.Enabled...

This is the code I placed in the button. Option Compare Database Private Sub Command8_Click() txttime_in = time() txttime_in.Enabled = False txttime_in.Locked = True End Sub It is supposed to put the time() into the time In text box when clicked. Nothing happens when I click it!!!! Any help...

Thanks for the help!!

Does anyone know how to use a button, so that once it is clicked it places the time() into a text field and cannot be edited??? Any help appriciated!! Thanks