Recent content by geeksatlarge

Thanks to boblarson and DCrake my final solution was to was to use Date() as the Default Value for the "Date" text box, and Time() as the Default Value for the "StartTime" text box. Then use the following code in the Form's "Before Update" event (Thanks to: Brendan Reynolds, BerkshireGuy and...

Whenever I see this error in my text box, it usually means that the "Control Source" for that text box is not set to the correct column header in the underlying table. You might want to try checking that.

Thanks boblarson for your help. :) My boss was having me enter similar information into a different Excel spreadsheet with additional headers. The fields I am using for this example are a cutdown version of that spreadsheet so I can solve for the most problematic cells (namely the date/time...

Yes, I did as you suggested and got "######..." in the textr box and table. So, I changed to the following: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Text6 = Time End Sub That gave me the value 5:50:09 PM in the text box and in the table :). That puts me "almost there". What was...

Thanks boblarson, I used '=DateDiff("s",Time(),[Start])' and got negative integers in the text box (Text6) that is associated with the field "Duration". You cleared a major source of frustration for me; really appreciated it. I used 'Time()' just to test with. I swapped their positions and...

There was a typo in my prior post. It should read: This time I tried '=DateDiff("n",Time(),[TimeStamps].[Text4])' as the value for the Control Source for The "Duration" field. Text4 being the "Start" field. This didn't work either, but the text box displayed '#Name?' in form view.

Thanks David, This time I tried '=DateDiff("n",Time(),[TimeStamps].[Text4])' as the value for the Control Source for The "Duration" field. Text4 being the "Duration" field. This didn't work either, but the text box displayed '#Name?' in form view.

I've created a table, in Access 2007, with the fields "ContactDate", FirstName, LastName, Start, End, and Duration. Date/Time is the Data Type for the fields "ContactDate", "Start", "End" and "Duration". I created a form that has Record Source set to the Table name and Recordset Type set to...