Recent content by hjg

these solutions don't account for a period longer than 24 hours The solutions given above (I've tried each of them in a simple query with a start and end date/time in general format) either: - do not account for periods longer than 24 hours - account for a period longer than 24 hours but do...

I'm still having some issues, actually. I've attached the db, if anyone is interested in giving suggestions (no real data involved). My worries are: I can't seem to build a PivotTable for PFGrandTbl because I don't have a Count column for my field totals. So I'm not sure what to add to the...

DJKarl, I've put the formula into a query. I've got two fields (really long stupid names): "Total_orders_written_join_qry" and "Total_patient_to_floor_join_query". These are formatted as a general date/time format (01/01/2001 9:00 A.M.). In my new query I'd like to calculate the elapsed...

Bob, I owe you a bunch of beers. Thanks! Geoff :)

Why with the 'unlock to edit' button does the code only work on some of the form's fields? I now only have a single form (I've gotten rid of the sub-form). When I click on the 'unlock to edit' button it unlocks the original main form's fields (about 9 fields). But, it does not affect the...

Hmm, yes it works. It gives the correct number of hours. Can't seem to get decimal places. Also, not sure if this solves the data entry awkwardness of inputting "05/01/07 05:30". I found a way to join date and hour text boxes, Control Source: =[DocumentDate]+[DocumentTime]. This was also...

I put this on the form. I used your expression as the control source for the text box "Elapsed Time." Where does the code go? Thank you for your suggestions.

When I put in the formula you suggest, I get a result that is a date. For instance if the start time is 8/13/2007 9:10:00 AM and the end time is 8/15/2007 5:19:00 AM, the result I get is 2/12/1900. I tried formatting the elapsed time in "general" and "short time" in the table. Perhaps I'm not...

I have a module which calculates the difference in days and hours between two date/times. That is, I know someone arrives somewhere at a certain date and time and leaves at a certain date and time. I calculate the difference in days and hours. The problem is that this means I have to enter...

Yes, I got the edits and utilized them. They were very helpful. I was just not successful using the code for the 'Edit' button. I did try, however. This is what I did: I went in to On Click and put in this code, changing the cmdEdit to cmdEdit2. I called the button cmdEdit2. In the...

I think I found part of the problem. The container name of the subform is different from the subform name. So the container name is the one I want to use. That is ED_TmElpsd_Tbl. Still, the macro is halted, as "the object doesn't contain the Automation object 'Me.' If I take out Me! it says...

I'm writing a macro to allow edits on a sub-form called TmElpsd_sbfrm. The main form is called EDFrm. I locked editing on the TmElpsd_sbfrm. The macro is a SetValue function. I'm not sure what to put on the Item line. I looked at this page and thought it indicated...

Some other questions... 1) I'm still having trouble making the "Unlock to Edit" button work in the sub-form. 2) Is there a more elegant way to enter the date/time than the 'general' format? I had to do it that way in order to capture wait times of over 24 hours. 3) How do you get a...

thank you so very much Bob, Thank you thank you. I haven't actuallly had a chance to see the changes, as I'm at home and do not have Access on my laptop. Nonetheless, I would like to thank you for what I can imagine are extraordinarily helpful changes. More importantly, as you mention, I...

My db Here is the db, cleaned up and zipped. All data included is made up and fictitious. The form is "EDForm." It is supposed to include the subform "ED_TmElpsd_Tbl subform" It doesn't appear as if the form is loading correctly (clearly, I made an error). You can, I suppose, look at the...