Search results

I've got a two fields called [Type] and [Date Submitted]. I use: Private Sub Type_Change() Date_Submitted = Now() End Sub to create to populate [Date Submitted]. However, I don't want [Date Submitted] changed every time I change [Type]. I would like to create my record, select a type...

OK, “DateDiff”ing has always given me fits, but I’ve always managed to figure out how to get what I need by trial and error. Until now. For the first time I need to figure out the difference between Time_In and Time_Out when Time_Out is past midnight. I’ve tried all sorts of things, nothing...

DBL: I double-checked my DBs and I’ve always used “=NOW()” for date/time stamping. The fields in which the table field was set to default to =now() continue to show the date the record was created. The only time =NOW() consistently showed the present time was when a form field was unbound or...

I'd like to create an edit history. I have a db that has a field for "Response". I've created a "History" field to feed the "Response" text to. This field will accumulatively display past "Response" texts along with a date/time stamp for each "Response" entry. The script I've written will...