Search results

So, I have a function that's meant to emulate += in Access to add a value to another value without having to repeat the first value. It's a simple function: Public Function pe(ByRef varBaseAmt As Variant, varNewAmt As Variant) varBaseAmt = Nz(varBaseAmt, 0) + Nz(varNewAmt, 0) End Function...

So, occasionally we get the "search key not found in any record" error (error 3709). This usually happens when a particular field in a form is updated, and the record is attempted to be saved. The assumption was that there was a corruption in the back end. So we do a Compact and Repair on the...

The built-in Form_Error and Report_Error error handlers are great for trapping system errors in caused by form or report code. But what about in a global module? Is there a way to trap system errors within a global module? (And, just to be clear, I'm not talking about the standard On Error...

Does anyone know of an inexpensive tool that can be used to combine multiple PDFs into a single PDF through VBA without having Adobe Acrobat?

Anyone ever have a problem with primary keys disappearing on their own? Every once in a while I look at one of my main tables, and I see that it has no primary key, and all relationships to the primary key are gone. I'm the only one who touches the tables, so it wouldn't have been someone else...