Search results

Another Subtotal Formula in Subform Problem (DateDiff Forumula) I have another sub-form subtotaling issue. I am entering work that is task based, time based or other. The below sub-total formula was working until I came to a record that had no time based work at all. The sub-total control...

Thank you. That worked. Changed the formula to the below and now everything is summing correctly =Sum(DLookUp("[Rate]","tblPrograms","PrgmID=" & [PrgmID])*[Qty]) Thank you very much :)

Hi, I have an invoice form in which there are 3 categories of works - time based, task based and other. For task based, there is a Dlookup formula that looks up the program used and applies a rate to the work. The problem I am having is subtotalling the tasks in the forms footer, so I can see...

Made a slight change to the formula in the subform; below is the corrected final sub-total formula =50*(Sum(DateDiff("n",[StartTime],[EndTime])/60)-1)+50 Thanks again for your help

THANK YOU! Including the datediff formula worked! So below is the final formula =Sum(((DateDiff("n",[StartTime],[EndTime])/60)-1)*50)+50 Thank you so much :)

Thanks but still getting #Error

Good night, I have been struggling to show a subtotal in the footer of an invoicing subform. The subform has the following text boxes [StartTime] [EndTime] The standard rate is $50.00 for the first hour or part thereof; $50.00 per hour thereafter. I have calculated the time elapsed using the...

Figured it out...so simple an error it is embarrassing As I was working with dates, I had the number format set to custom so when I entered this formula it was trying to convert it to a customized date format. I changed it to number with 0 decimal places and it worked.

I am setting up a vacation roster and was using the networkdays.intl formula to calculate the number of days used per employee per month, excluding Saturdays, Sundays and bank holidays. The formula was working until I got to one employee who went over the number of due days for the year, using...

Thanks again...it's a little too complex for my level. Did some more searching and modified my original formula and found something that is easier for me and (so far) is giving the results I was looking for. =INT(MROUND(CELLREF,1/16)/12) & "' " & TEXT(MOD(MROUND(CELLREF,1/16),12),"#-#/##")

Good Morning, Is there a formula to convert a number to feet and inches with fractions. For example I would like to convert 143.625 to 11 ft 11 5/8 in. I was using this formula - =INT(CELLREF/12) & " ft. " & MOD(CELLREF,12) & " in." but can't find a way to include for fractions.

Hi...Just giving you an update. So I made the changes to the code and added a couple lines to minimize the Job Set-Up form (see below in red). The report opens and saves to the specified folder. On closing the report I created a simple dialog box that asks the user if they would like to view...

Ok thanks. Really appreciate your help.

I don't know how to toggle the visibility...sorry. I tried the minimize window and that seems to be working (sort of). No error messages and the file saved in the specified folder. Is there a way to add a hyperlink to the folder in the message box?

Oh...I think I understand. So I should keep the form open but maybe minimize it, let the report run and save to the folder and on closing the report, maximize/restore the form?

The database is 8MB even after the compress and repair. I will email it to you shortly. Thanks.

The db won't upload...it is exceeding the max. file size and I am getting the below message Your submission could not be processed because a security token was missing. If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this...

Yes...definitely the textbox name and not a caption. I thought I was misspelling it and even copied it from the properties box and pasted into the code and still got an error

Hi. The error description is Run-Time Error 2467: The expression you entered refers to an object that is closed or doesn't exist The ContractName text box is a required field and primary key so there is always info in that field

I am trying to run a code that will print a report to pdf and save in the specified folder, however I keep getting an error with the file name. Where am I going wrong? Also, is there a way of adding a hyperlink to the folder in the message box? Private Sub CmdPrintJob_Click() Dim strWhere As...