Search results

converting hours to seconds Hi Dennisk, Thank you for the formula. I am under great pressure to finish the query and report so your help is invaluable. Thank you again. Ligaya

negative numbers Hello Dennisk, Thank you so much for the speedy reply. I am still finding my feet with ACCESS. Could you please tell me howto convert the hours/minutes into seconds? I would greatly appreciate every help you can give. Many thanks, Ligaya

negative numbers The time entered for the total break time taken is automatically entered by a phone system where in when you press the "break button", it counts the time you are away from your desk. The countdown stops when the "break button" is released. The figures are then downloaded...

I have to columns, one showing the total minutes a worker is entitled for breaks and another column for the total breaks actually taken. I ran a query to calculate the extra breaks taken. Some workers took more than the planned break time and should have shown negative numbers, but my query did...

Hello, I have a a main form with 3 subforms in it plus a list box. All 3 subforms are synchronised with each other and I would like the list box to be as well. How do I do this please? I am desperate for an answer. Thank you. Ligaya

Through trial and error, I managed to find the solution, Thanks

How to write macro to stop a form from closing and exiting ACCESS. I have a message box that asks "do you want to save and exit now?. There are yes, no and cancel boxes and when any of the boxes is clicked, the form closes and exits ACCESS. I would like the form to close only when yes is clicked.

I shall try that one. Thank you Oldsoftboss!

Hello Neil, I am very new at ACCESS and am workking on trying to view related records on a form. I have 2 combo boxes which when I click on combo box 1, I'd like combo box 2 to show the related records. I am interested in using a macro instead of code which you have discovered in 2002. Would...