I have a database where each record contains IN and OUT. I would like to see how left for more than 20 minutes.
How can i check the OUT time in the first record with the IN time and then calculate the minutes?
Taking into considerations there are other days in the DB and i want to do it for...
I checked and I got -966.
Maybe it is checking between 16:06 on the 24th and 00:03 on the 24th as well!
I tried to attach screen shot but i didn't know how.
Thanks for all your help.
Dear,
I am using datediff function to get the number of miunutes between to times: Me.WorkedMinutes = DateDiff("n", [OTIn], [OTOut]) and it works oK EXCEPT when I'm computing the minutes between two times that falls in different days. for exmaple number of minutes or hours worked betwen...
Hi,
I have connected 15 computers to my main computer. Now, I would like to allow users to run applications located on my computer. What is the best and easy way to do this?
Thanks
Hi,
I have connected 15 computers to my main computer. Now, I would like to allow users to run applications located on my computer. What is the best and easy way to do this?
Thank you.
Hi,
Can anyone tell me how I can use VBA to figure out to which group the CurrentUser() belong to or memeber of?
i.e. if current user belongs to Users group then
if current user belongs to Admins....etc
Thank you.
Hi AceMan,
My code is in the After Update even! :)
This never happended to me before...
Private Sub ComboSearchID_AfterUpdate()
Me.EmployeeNumber = Me.ComboSearchID.Column(0)
Me.EmployeeName = Me.ComboSearchID.Column(1)
Me.cmdAddTerminatedEmployee.Enabled = True
End Sub
Hi,
I have a combo box that displays list of names and it works fine. I can type the name and it will showup in the combo box then click on it and I get the data, however, after selecting the name if I press enter, instead of using the mouse, nothing will happens and that name will not be...
Hi,
I've read many posting and I'm able to save Access reports, however, even though I type the path and the file name I'm still prompted for these info! I would like to have the report saved automatically. Any ideas PLEASE?
The following is one of the solutions I used: thread705-1182605...
I have connected all the workstations to the domain and created users on the active directory and users can login.
The next thing I would like to do is create personal drives for everyusers on the domain "windows 2000 server" so that when login from anyway workstation they can access their...
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.