Hi ... Has anyone tried to use the REApplication object and specifically writing code for the UIOpening and UIClosing events ? The vba documentation (admittedly limitted) suggests that VB code can be written to execute code when the user starts up a Raisers Edge session. I would like to take advantage...

Hi, I'm looking for a way to find contstituents by their bank account. As off version 7.81 the account numbers are encrypted in the DB. Using the standard CustomWhereClause doesn't work because it queries the raw (encrypted) data. Is there a way to encrypt the plain text (account no) and pass...

We're wanting to run a duplicate check on each line of a constituent batch, as the data is being entered, so that at the end of the batch we know that everyone of the records has been checked. Currently, we have in the user procedure to click on each line, then do a "Duplicate Search For xxxxxx"...

Hello, I'd love your thoughts on how to approach the following issue: I have a monthly process that entails refreshing 15-20 queries with a specific date range (i.e. June 20-July 21) and then doing 5-6 exports based off of various of the queries. Currently, the process takes 4-6 hours due to the...

I'm new to RE VBA and appreciate any assistance with the following problem :) When I launch a VBA userform through a macro from the RE shell it does not appear on the Windows taskbar. So if I switch to another application (like Excel) I can't get back to the userform by clicking an icon on the...

I am looking for a calendar (date) control like the one that appears in the date column of the attributes pages in RE. It is not one of the default controls. I tried RE7_SC72.SuperCalendar, but that is not what I want.

I am creating a macro for entering a new individual consitutent. Unfortunately the only reference I have found so far to Forms in the RE VBA esentials guide is on page 98, where it indicates that "VBA provides full-featured forms design support", where I "can design a custom data entry...

You would need the VBA module [edit: as David mentioned] rather than an API license to do this. This code shows one way to track what values were changed TO, but you could extend it further to also track/log initial values. I don't know that actions are good place to store audit trail though, as...

Absolutely. This is a straight forward task. Using the VBA module you would capture the values before the record is opened and then on saving the record you would compare the values to those when the record was opened and record any change. This is common where you want to keep an audit trail of changes...

We've got a VBA macro and would like to log when whenever someone runs it and the context (what record were they in at the time). So basically, I want to capture the Date, Time, UserName, and ConstituentID-UserName of the record they were in at the time. Ideally, I'd like to send this information...