Recent content by mark6109

Thanks but I have tried this code before without success. I believe it is due to the link you provided was referencing Access 2000, in the first paragraph. I am using Access 2010. Mark

I am trying to create a public function in VBA so I may use the Excel Networkdays function in Access, I am a rookie in VBA. I have already mapped to the Excel Object Library in VBA by going to references. I can see the function but do not know how to link to it to be able to use it in a query...

I put the "" return result because the circuit board might still be in the repair process and would not require a result if it has not completed troubleshooting testing. Also, The repair code would never have a combination of U and a N in the same field, it could only be either or. Thanks for...

----------------------------------------------------------- Thanks Plog, I have never tried this in VB but it seems a lot easier to write. Sequential Order: FAILURES 1. Check for failure records in fields [Rep_Code] + [Repair Comments] 1. [Rep_Code]="*u*" 2. [Rep_Code]="*r*" And...

Hi Plog, Thanks for your feedback. That is correct, anything with an "N" repair code should pass. And>>>Any code that does NOT contain a U, N or R anywhere in the Repair Code = PASS <--This is correct. I think the problem is here. [REPAIR_COMMENTS]=IsNull([REPAIR_COMMENTS]) Is there a better...

Here is a challenging one for you guys, thank you in advance. The end goal of the below expression is to determine if a unit has passed or failed a repair process....Here is the original request from my colleague and below is what I have so far: • Where there is a U anywhere in the Repair Code...