Search results

Thank you very much. That was the answer. It was indeed bound to the LogType. When I removed it, everything is working as intended now. Thanks again!!!

I tried using a similar method to your to filter records in a time log. There are 4 separate areas of the log which people use to log different activities. So I use the filter so they only see and enter data in the area they are concerned with. The problem I am having is that Access keeps...

Thank you all for your suggestions. It is working now as intended. There must have been something messed up in the database structure. It should have worked as some of you described but it did not. Strange! I am now updating the elapsed time in the table from the form and without the extra text...

Here is the actual VB code Some of it is commented out because I was troubleshooting Option Compare Database Private Sub Form_Open(Cancel As Integer) 'Forms!frmLogsTab!txtTimeSpent.Format = "mmm yyyy" Me.txtCalcBox.Value = Me.txtStopTime.Value - Me.txtStartTime.Value...

Here is a pic of the way the form looks.

What you suggested is what I originally had in the code. I got the same error. That is why I started using the unbound text boxes to test the code. For some reason, there is something about the txtTimeSpent bound textbox that will not allow me to update that value with a formula.

Hello, I have a table that I am convert over for Excel which my group uses to track their work progress. I have created three particular fields in this table and linked a form to this table where they actually input the information. They input a start time and a stop time. I have three unbound...