Recent content by David R

contrs is used lower in the code (.to field of the email). As noted elsewhere, I eventually seem to have pushed the error off of this plane of existence, without actually changing anything in the quoted code.

Yup, the same breakpoint suffices (sorry, I'm probably spending too much time on the form variables because that is what ate my head yesterday). But for whatever reason (quantum mechanics?) everything now runs smoothly. A seemingly unrelated error was in my .htmlbody build, but that showed a...

Thanks Doc; long time no see! Here's the thing. If I resolve the variables during a breakpoint, I get valid SQL:SELECT ProjectNumber, BidPackage, CaseAddress, CaseID FROM tableCases WHERE ((ProjectNumber = "IH2019") AND (BidPackage = 1) AND (CaseStatus < 50 AND CaseStatus <> 25))I get as far...

Yes, I did check it against Immediate via breakpoints. The SQL agrees exactly with the stored query version, except of course that the variables have been given values. CaseID is alphanumeric, in this test case '999-999'. There are no nulls to worry about because it is testing against the open...

I've done this dozens of times, I don't know why this database is flipping out on me. (Apologies for the convoluted code, it started out giving the "too few parameters" error when runSQL referenced the form that was running the code, so I had to break the loop. Dim addrs As String...

My gods outnumber your god and could take him in a fair fight.

I reiterate because I already answered your question in the OP, spike. I'd already done everything you suggested, hence the testiness. I'm not a new user here. Nonetheless, the seventeenth iteration of error handling trapped it and now all works as designed.Private Sub comboStatus_AfterUpdate()...

Correct. Other users (including myself, with full server access) can write to LockedDownServer just fine, which is why I never noticed it during testing. I can simulate it now by changing the LockedDownServer directory to one I don't have access to on a third, unrelated server. To reiterate: If...

Typo (hadn't cleared out all of my latest attempt). That line has been fixed.

Some of my users do not have access to all of our servers. In trying to automate I've hit one user whose system hangs up when Access tries to write to a server folder she does not have write (or even read) permissions for (Error 52, Bad file name or number). See the "Me.CitationType > 500" line...

Yeah well, my religion is excluded from the poll, so I have to get my jollies somewhere... :D

So there's some bill, or maybe a law, that you don't know the name or number of, that will do a blatantly unconstitutional thing? Nice try, thanks for the laugh Blade. You might be thinking of SB 1140 from 2012, that would have shielded churches from having to perform gay marriage or lose their...

Bumping. This is still/again a problem, and I can see no reason why. If Me.NewRecord = True And IsNull(Me.CaseNumber) Then MsgBox "Enter the Service Order and Increment first, please.", vbExclamation Me.frameCitationType.Undo Cancel = True Me.CaseNumber.SetFocus...

Aren't I reversing the value change, though? Me.frameCitationType.Undo Cancel = True It's impossible to 'change' the value of the frame from within the BeforeUpdate event. My other option would be to fire it from AfterUpdate instead, but that sounds like a recipe for getting...

This frame controls an option group. If they are in an existing citation and want to start one for another type, this offers to write a new record in when they try to switch. Problem is, if it DOES write the new record, it seems to be saving the old record, and thus both will end up 56, for...