Search results

Perfect!! Thank you very much!!

I have a field called TimeRemaining in my access report. It calculates the time left that a work order has to be closed in before the corporate office calls the branch and requests information (this is a bad thing). It is based on another field called RepairType. There are 3 repair types...

I'd like to add another condition to this code. There is a situation where neither the word "MAJOR" nor "MINOR" appear. In that case, in the ElapsedTimeString field, I'd like the words "ACTION NEEDED" to appear in Bold Green letters. Timeframes don't matter. I don't care how old the...

stopher, Once again, you've come through in the clinch. Thanks a lot!!!

Good afternoon, Can someone help me figure out how to remove any reference to "seconds" in this vba code? I just want it to show Days, Hours, and Minutes. Thanks!! Option Compare Database Option Explicit Public Function ElapsedTimeString(dateTimeStart As Date, dateTimeEnd As Date) As...

stopher, this works perfectly. Thank you for all you assistance. Managers are going to be pleased with this report!! Enjoy a prosperous New Year!

Thank you, stopher!!! This worked perfectly!! I'm still acquiring my VBA skills and I learn something new everyday. Showing me this information brings up 2 more questions, if you don't mind helping me. 1) This does make the work orders in question bold, but all work orders fitting each...

Good morning and Happy New Year, I am a novice when it comes to VBA programming, but I feel pretty confident in normal Access functionality. I'm stuck when it comes to conditional formatting. I've developed a program that prints a report of how long a work order has been open. However, I...

I think I'm confusing myself. Not too hard to do, but nonetheless.... The query that pulls the last incident date is just a query based on branch number and ALL incident dates, but has a "Max" in the "Total" criteria field. So, if I ran the query, it would pull the specific branch I wanted...

Thanks, Access_guy49. It does work, but only if there is one date in the query. If there are several safety incidents at a branch over time, I want to be able to pull the most recent one and calculate how long it's been since that time up to the current date. Do you think I could still pull...

Hello, Same song, different dance. I'm trying to calculate the difference between the last safety incident at each of our branches and the current date (want to know how long each branch has gone without an injury). I've written individual queries to pull out each branches max injury date...