There are a lot of controls that The Raiser’s Edge uses and that you can use in your code to give it a similar look and feel. This article is an introduction to using one of these controls - the SuperEdit70Ex. Like most of the API this is not documented. Indeed this really is not documented. There is no extra documentation other than by looking at the object browser.

 To add the SuperEdit70Ex to a form it must firstly be added to your toolbox. Right click on the toolbox and select Additional Controls (in VBA) or Controls (in VB6). Look down the list for the SuperEdit70Ex and select it as shown below (in the VBA environment):

Note that these components will only work in the VB6 or VBA environment. They are not supported by .NET (but then .NET has many more replacement components that work much better).

Once you have added the SuperEdit70Ex component you can add it to your form. This component is used in RE for looking up records (constituents, funds, etc) but also for showing the calculator (for number fields), showing the calendar (for date fields) and other purposes. The property that determines which type the control is the style. This can be one of: ellipse, binoculars (default value), calculator, calendar, dropdown, magnifying glass, and a lot more that are not used as widely in RE. You can also have a secondary button style (property secondary style) but the show secondary button property needs to be set. A few examples are shown below:

Unfortunately just because the icon is there does not mean that it does anything. Pressing the button (whichever button it is) will raise the ButtonClick event. From within this event you can show the record look up screen using standard API functionality.

To show the calendar however requires some more work.

If you want to supply a value on startup then you can capture the InitCalendarProps event. This allows you to set the year, month and day values. To update the calendar text box after a user has selected a date then you have to capture the CalendarCloseUp event. The example below shows how this is done.

Private Sub dtNLPostDate_CalendarCloseUp(ByVal UserCanceled As Boolean, ByVal YearValue As Long, ByVal MonthValue As Long, ByVal DayValue As Long)   If Not UserCanceled Then
     dtNLPostDate.Text = DayValue & "/" & MonthValue & "/" & YearValue
   End If
End SubPrivate Sub dtNLPostDate_InitCalendarProps(UseTodaysDate As Boolean, YearValue As Long, MonthValue As Long, DayValue As Long)
  Dim asDate() As String
  If dtNLPostDate.Text <> "" Then     asDate = Split(dtNLPostDate.Text, "/")

Watch this space for more information on the controls. If you have used any of the controls then feel free to add a comment or drop me a line if you want to write an article on any of them (or anything else for that matter)

Previously I have integrated Quick Address from QAS with The Raiser’s Edge. I implemented their pro API in order to validate the address on saving the constituent/relationship/participant and on demand using the VBA macro button. I created a plugin to update addresses en masse using their batch API. I implemented their pro API to create a “silent” validation during import. The one thing that I didn’t do at the time was to validate addresses in a constituent batch. At the time this was not a requirement.

Read the rest of this entry »

When you write code using the RE7VBA tool that compiles the VBA code into a DLL to be deployed, the environment is very similar to the built in VBA environment. There is the same development environment and access to the same code. So you would think that switching between the two would not be a problem.

Read the rest of this entry »