Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Tutorials _ ACCVBA Custom Events

Posted by: argeedblu Aug 29 2004, 12:10 PM

Title: ACCVBA Custom Events
Symptom: You want your code to trigger events so that your application can reuse basic code but perform different custom actions depending on the application’s requirements
Subject: Defining and using your own events
Applies to: Access 97 and later Tested in: Access 2000, XP, and 2003
Skill level: Intermediate to Advanced
Author: Glenn Lloyd Date: August 29, 2004
Keywords: Events, Event Handlers, Forms, Form Controls, WithEvents, Error Handling
vbScript to VBA conversion
Overview: This tutorial discusses how to create a base class that will trigger events, a custom class that will respond when events are triggered, and a standard module that will demonstrate how to use the classes

Attachment now has A97 and A2k versions

Edited by: argeedblu on 08.29.04.
The code in this demo uses RaiseEvent which, I have just learned is not available in Access 97 VBA. The sample code, therefore, applies only to Access 2000 and later versions. - Glenn Oct 3/04

Edited by: argeedblu on Sun Oct 3 23:34:31 EDT 2004. ( 107.89K ): 2264