So Should It look like this?
Option Compare Database
Private Sub totaltime_BeforeUpdate(Cancel As Integer)
DoCmd.SetWarnings False
Dim StringVerb As Long
StringVerb = "15"
DoCmd.RunSQL "INSERT INTO TOTALS( HoursAndMinutes) " & " SELECT " & =HoursAndMinutes([Time Out]-[Time In])...
hahaa... yea i did that. next question, i got the module for calculating total time but i need to put that number in a table, i have nto been able to figure that out fot the life of me, any ideas? the control source for said total is: =HoursAndMinutes([Time Out]-[Time In]) HoursandMinutes is the...
I'm using access 2000 (sp3) if that makes a dif. the only things that are available on the event tab are:
onclick
on dblclick
on mouse move
on mouse up
on mouse down
Sorry for the troubles.
I want to be able to display system time (00:00:00) on a Form, how would i go about doing that, also i want to be able to get total weekly values (we are dealign with a time sheet) per person in the database. I can do daily but i have eyt to figure out weekly... Any and all ideas are greatly...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.