Search results

Hi. I'll give some more detail. The form frmClients includes the subform frmJobDetails which is linked to the frmClients by the ClientID. In frmJobDetails I list the job name and a brief description of the type of project Each client has a task sheet. The subform frmTaskSheetDtls has the...

Thank you but I don't understand exactly where I would enter this command. Is there a particular event for the cboJobName I should enter this under?

Hello, I have a client task sheet form with a combo box cboJobName that lists all the jobs for that specific client. I have the List Items Edit Form property set to frmClients (which includes the subform frmJobs). How can I open the frmClients to the Client whose task sheet I am working in...

Thank you all for your help. For the first formula I took out the IIF part and that worked. For the second one, I split the formula into two separate calculated controls and then totalled those two. No #type! or #Error messages. Thanks again :D I might have another query later on ;)

Hi, Adding Nz didn't work and both fields are in the form only, not in the tables. I tried setting the Default Values in the form properties to 0 but that didn't work

Hello, I have two slightly annoying issues. I have a DLookup formula on my data sheet subform that is working, however, in the next blank record, that field has an #Error message which is a little irritating to see. But when I key in data the #Error goes away. Below is the formula...

Thank you. The first formula - =((DateDiff(“n”,[StartTime],[EndTime])+7.5)\15)/4 - works best for me. Thank you so much for your help! :)

Thank you

Yes...I'm confusing myself now!

I just received an email from the owner of the database who advised they gave me wrong information which I, unfortunately, passed on to this forum. Please accept my sincerest apologies. The original formula =DateDiff("n",[StartTime],[EndTime])/60 is returning figures like 8.17 or 6.80. They...

Hi, So these are some of the variations of the formulas I have tried...I think I am typing it incorrectly because every formula except 1 is returning the #Name? =DateDiffMinutes("n",[StartTime],[EndTime]/60)/4 = #Name? =DateDiffMinutes([StartTime],[EndTime]/60)/4 = #Name...

I am having trouble understanding the suggestions. If with my original formula, an individual worked 7.55 hours, the person keying the information needs to see that they worked 7 hours 35 minutes, rounded to 7 hours 30 minutes (7.30). So it will always be total hours and minutes worked...

Good evening, Using the DateDiff formula I have been calculating the total time worked. I need to round this formula to the nearest quarter of an hour. How can I amend my formula =DateDiff("n",[StartTime],[EndTime])/60 to achieve this? Thanks in advance for your response.

Thanks for your reply. The problem I'm having is that there are 3 subform subtotals on the main form...one totaling time based work, one totaling task based work and one totaling other work. When I enter time based work in one record, and task or other work in the next record, the subtotal for...

Hi Further to this earlier post, I have encountered a slight problem. Due to the number of fields in my subform, datasheet view was too wide and difficult to navigate and simply did not look good. I changed the subform from datasheet to single form and once I did this, the sub-total on the...

Will do that from now on! On another note, please let me know if I am posting the formulas correctly - do I wrap code, or quotes around the formulas before posting?

Thank you! That last formula worked. I had just finished typing out a long response to your previous post with examples and everything and then accidentally clicked refresh page and lost everything I type :( Thanks again...you've helped me out a lot!

What's happening is that the formula is adding 50 to every line in the record that is NOT time based. So the record that had no time based work, but 4 task based work, is returning a result of 200.00 in the time sub-total I need to find a way of saying if the time controls are blank, to return...

Ok...I'm getting somewhere. The formula is being accepted but the total is incorrect. So I will keep working with the NZ function to see if I can get the end correct end result. Thank you for your help.

I'm not getting the formula to work, I'm getting invalid dot or operator message. I've gone over the formula a few times now and can't find the problem