Search results

Thanks Pat, the article was very enlightening. The code suggested, however, is above my beginner level. Could you or anyone suggest something for the above data (Hrs_Worked = ([Time_Out] - [Time_In]) * 24)? Seems like I just need something to round the number up to two decimals. Thanks again.

Can anyone comment on why I might be getting "15.9999999999418"? I don't always get this type of return. I might enter different hours of the day (which still total to 16 hours) and get the normal 16 returned. I'd appreciate any comments or suggestions.

I just tried the steps Mike Gurman recommends and it works great. However, I have command buttons on the form that open reports and now when I click on them, the reports are not displayed. The reports are displayed behind the form and minimized. In addition, I'm not able to shift focus to the...

Thanks, that worked for me. I have to laugh at how often I overlook the obvious. Thanks again. Stephen

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...

Yes, both fields are memos. In answer to your second question, "Text" data type is the type that is restriced to 255 characters. "Memo" has the following definition in Access help: "Up to 65,535 characters. (If the Memo field is manipulated through DAO and only text and numbers [not binary...

I believe they were both memo, but I need to double check. I'll look and get back to you. Stephen

OK, Changing Time_In and Time_Out to general date format helped. It took a while to get it, but I finally got it working right, somewhat. Problem now is that I get a screwy return for Hrs_Worked. Employee worked from 8 am to Midnight. 16 hours, right? Well I’m getting 15.9999999999418 back...

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...

I’m new at this also, but what I have works for me. I used two fields on the table. One called “Response” (where you enter comments) and one called “History” (where a running history of comments is stored and displayed). The following code is on the “After Update” event on the “Response”...

Thanks, the article was very good. It wasn't what I was looking for at the time (the characters DBL gave me worked fine for what I wanted to do), but after reading the article and trying out the code, I see excellent uses for it. Thanks, again. Stephen

Thanks, will do.

Thank you Jack. I think I'm OK. This posting is a follow up to the “Error on =Date() function” posting by trstorer. I just wanted to make sure I wasn't missing something. Thanks

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...

On your table, you can set the field's default value to "=NOW()", then set the format to whatever date time format you prefer (long date, short date, etc...). HTH, Stephen

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...