Bogus error message halting production

[Stapes]

Hi

A process that has previously been working is suddenly coming up with
this:

The expression After Update you entered as the event property setting
produced the following error: Object or class does not support the set
of events.

It is obviously bullsh*t. I have tried Compacting and Repairing the
database, recompiling it, all to no avail.

What the four and a half has happened?

Stapes

 

[Stefan Hoffmann]

hi,

It is obviously bullsh*t. I have tried Compacting and Repairing the
database, recompiling it, all to no avail.

If the used object is a standard object like Form or any Control, then
it may be corrupted code.

Make a backup of your database. Delete the form. Repair and compact your
database. Import the object from the backup.

If it still fails to work:

Use

Sub SaveAsText(ObjectType As AcObjectType, ObjectName As String,
FileName As String)
Element von Access.Application

To save the form. Delete it. Then use

Sub LoadFromText(ObjectType As AcObjectType, ObjectName As String,
FileName As String)
Element von Access.Application

to import it.


mfG
--> stefan <--

 

[Allen Browne]

If this is on Vista, and you have multiple versions of Access installed,
see:
Errors using multiple versions of Access under Vista
at:
http://allenbrowne.com/bug-17.html

If that's not the case, tell us what version of Access this is, and what
references you have checked (Tools | References in the code window.)

 

[Stapes]

If this is on Vista, and you have multiple versions of Access installed,
see:
    Errors using multiple versions of Access under Vista
at:
   http://allenbrowne.com/bug-17.html

If that's not the case, tell us what version of Access this is, and what
references you have checked (Tools | References in the code window.)

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.











- Show quoted text -

Fortunately, I had already made a copy of the database. My problem was
in a subform displaying in datasheet view. However, I had just added
new fields to the table definition, and put Decsriptions in. When you
do that, the system invites you to propogate that decription through
any forms which might use the form as a Status Bar text. I wonder if
it was that that caused the error. I had also added new controls to
the subform in question to display the new fields.
Other than that, the code had not changed.

Anyway, copying my subform back from an earlier copy had got rid of
the problem.

Thank You

Stapes