Recent content by Sonnydl

Thank you @CJ_London and @Josef P. ! Your solutions were exactly what I needed, but I got in my own way. I ignored the fact that the word "Submitted" could also be proceeded by the word "MASTER", so the expression I used in my particular case was: Expression is [txtDocStatus] Like "*Submit*" I...

"Without success" means that the control isn't conditionally formatting when the unbound control contains the word "Submitted." There are just two CONDITIONAL FORMATTING rules applied to this unbound control. The first is the "Value =" and the fixed text. It works as expected. The question I...

This didn't work for me. So you can refer to a control on a form in the Conditional Formatting interface by just bracketing the name of the control? I think I've seen what you suggested as a way to refer to data in a control (a bound control) but not for an unbound control.

Hello. I'm wondering if I can use conditional formatting on a form when I'm looking for only partial text in a single unbound textbox. I can do this with VBA but was wondering if it can be done via Conditional Formatting, in case I want to do it that way in the future or in other instances...

I'm just left scratching my head. So typos in my simplified faux code aside (again, it was for demo purposes, but the flow was accurate), I did what you suggested and added the Me.Modal = False code into my OnLoad event for the ADD PRODUCT form. The result I got was: If I did try to add a new...

Hello, I'll try to make this clear, but I'm not sure if I'll be able to. Maybe I've got too much background, but I don't know how else to get an answer without giving the context. I hope it helps. I'm using Category, Product and Type as my data buckets, but that's for simplicity of explanation...

Thank you for your help. I got it to work by doing the following: I moved the subroutines into their own module (out of the report's processes) and converted them into functions. I removed the function variables from the all-inclusive string and put them in the suggested concatenated form. I do...

Yep. When I tried it without making it a function I got a Run-time error 2425: The expression you entered has a function..." So I changed it to a function and... still no joy. Same 2425 Error. The call code is: Eval ("RequestReimbEmail(" & Me.txtSubjectID & "," & True & ")") The function...

Sorry, I get the same "cannot find" for the MarkReadyToProcess options. My assumption was that the issue is with how I'm using Eval, not the actual subs that are being called, as they work if I don't use the Eval() method. If the issue was the actual subs, wouldn't they fail when called...

Hello, I've got a workaround for my problem, but I'm trying to learn about what it is that I'm missing. Here's what I ended up with, and it works just fine: Private Sub CheckAndProceed(bytRequest As Byte) ...Stuff happens to get the the select statement... Select Case bytPreCheck Case 1...

That's an explanation I can (somewhat) understand. And even if I don't fully get the why of the conflict, there's a logic to it that I can accept. Thank you!

SOLVED-ISH: Okay, so I went back to the source database BE, and created a simple new table (three field: ID; SubjectID_FK; Test) that I linked to to tblSubjects.SubjectID, created a very simple three-table query with tblTest--tblSubjects--tblSubjTravelerProfiles, and was also unable to edit the...

So in my quest to drive myself to the brink (I can't seem to let this go, just yet...), I moved some relationships around to make sure they were correct. These are the primary database relationships: I removed the tblSubjectAddresses from my query and just added tblSubjects. The resulting...

So those two JOINS are different because they come from a different linked backend Dbase--one that shares tables across multiple projects (things like countries, regions, time zones, currencies, etc. that are the same for all the projects). I removed each of those joins (and the data in the...

So I could be mistaken about my interpretation of "directional relationships," but everything is an INNER JOIN, there are no LEFT or RIGHT JOINS in the SQL. I don't believe there are any genuine arrows in the diagram. A genuine arrow looks like this: