RecordExit event seems non-existant

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

In the Northwind database the Employees form contains code for the
RecordExit event. However this event is not listed in the form properties
and the event is never triggered when moving from one record to another.

I tried setting the event property a number of ways being:
Forms("Employees").OnRecordExit = "[Event Procedure]"
Forms("Employees").OnRecordExit = "mymacro"
Forms("Employees").OnRecordExit = "=myproc"

This syntax works fine to set event properties that ARE included in the form
properties list, however, with the OnRecordExit property I consistently
receive the following error:
Run-time error '2455:' You entered an expression that has an invalid
reference to the property OnRecordExit.

Both the RecordExit event and the OnRecordExit property are described in
Visual Basic Help but they just don't seem to work. Could I be missing a
reference to a needed library?

Any suggestions would be appreciated very much.

(My need for this event is, of course, in another database but I discovered
it in Northwind. If I can get it working here I can apply the syntax to my
own database.)

Rick C
 
Rick said:
In the Northwind database the Employees form contains code for the
RecordExit event. However this event is not listed in the form
properties and the event is never triggered when moving from one
record to another.

I tried setting the event property a number of ways being:
Forms("Employees").OnRecordExit = "[Event Procedure]"
Forms("Employees").OnRecordExit = "mymacro"
Forms("Employees").OnRecordExit = "=myproc"

This syntax works fine to set event properties that ARE included in
the form properties list, however, with the OnRecordExit property I
consistently receive the following error:
Run-time error '2455:' You entered an expression that has an
invalid reference to the property OnRecordExit.

Both the RecordExit event and the OnRecordExit property are described
in Visual Basic Help but they just don't seem to work. Could I be
missing a reference to a needed library?

Any suggestions would be appreciated very much.

(My need for this event is, of course, in another database but I
discovered it in Northwind. If I can get it working here I can apply
the syntax to my own database.)
Click to expand...

The RecordExit event was originally planned, but was never implemented
in the released version of Access. There are KnowledgeBase articles
discussing this, and one containing some rather elaborate code to
simulate such an event:

http://support.microsoft.com/default.aspx?scid=kb;en-us;286477
ACC2002: RecordExit Event Unavailable in Microsoft Access 2002
(286477) - When you view the event properties of a form in Design
view, you do not see an OnRecordExit event property, even though this
event is documented in the Access 2002 Help system.

http://support.microsoft.com/default.aspx?scid=kb;en-us;286591
ACC2002: RecordExit Event in Employees Form Does Not Work
(286591) - The Employees form module in the Northwind sample
database and NorthwindCS sample project contains an event procedure for
the RecordExit event that does not work.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304139
ACC2002: How to Programmatically Implement a RecordExit Event
(304139) - This article shows you how to programmatically implement
a RecordExit event in a form in Access 2002. Microsoft provides
programming examples for illustration only, without warranty either
expressed or implied, including, but not limited to, the...
 
Well that explains it. I seem to have a knack for coming across items like
this.

Thanks,
Rick C


Dirk Goldgar said:
Rick said:
In the Northwind database the Employees form contains code for the
RecordExit event. However this event is not listed in the form
properties and the event is never triggered when moving from one
record to another.

I tried setting the event property a number of ways being:
Forms("Employees").OnRecordExit = "[Event Procedure]"
Forms("Employees").OnRecordExit = "mymacro"
Forms("Employees").OnRecordExit = "=myproc"

This syntax works fine to set event properties that ARE included in
the form properties list, however, with the OnRecordExit property I
consistently receive the following error:
Run-time error '2455:' You entered an expression that has an
invalid reference to the property OnRecordExit.

Both the RecordExit event and the OnRecordExit property are described
in Visual Basic Help but they just don't seem to work. Could I be
missing a reference to a needed library?

Any suggestions would be appreciated very much.

(My need for this event is, of course, in another database but I
discovered it in Northwind. If I can get it working here I can apply
the syntax to my own database.)
Click to expand...

The RecordExit event was originally planned, but was never implemented
in the released version of Access. There are KnowledgeBase articles
discussing this, and one containing some rather elaborate code to
simulate such an event:

http://support.microsoft.com/default.aspx?scid=kb;en-us;286477
ACC2002: RecordExit Event Unavailable in Microsoft Access 2002
(286477) - When you view the event properties of a form in Design
view, you do not see an OnRecordExit event property, even though this
event is documented in the Access 2002 Help system.

http://support.microsoft.com/default.aspx?scid=kb;en-us;286591
ACC2002: RecordExit Event in Employees Form Does Not Work
(286591) - The Employees form module in the Northwind sample
database and NorthwindCS sample project contains an event procedure for
the RecordExit event that does not work.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304139
ACC2002: How to Programmatically Implement a RecordExit Event
(304139) - This article shows you how to programmatically implement
a RecordExit event in a form in Access 2002. Microsoft provides
programming examples for illustration only, without warranty either
expressed or implied, including, but not limited to, the...

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top