Error - "Object or class does not support the set of events"

[Oleg]

hey group
the below error suddenly appeared today.
Been using database for a few years, but lately started going back and forth between access 2007 and the older one.
(getting previous version doesn't help)



"The expression "On Load" you entered as the event property setting produced
the following error: Object or class does not support the set of events.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]. *There may have been an error
evaluating the function, event, or macro."

 

[RuralGuy]

I would start by *importing* everything into a fresh new db and see if the problem follows.
http://www.btabdevelopment.com/ts/impnew

 

[Ahmad Ruchiyat]

I tried what Ruralguy did, and it works.

hey group
the below error suddenly appeared today.
Been using database for a few years, but lately started going back and forth between access 2007 and the older one.
(getting previous version doesn't help)



"The expression "On Load" you entered as the event property setting produced
the following error: Object or class does not support the set of events.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]. *There may have been an error
evaluating the function, event, or macro."

 

[Ahmad Ruchiyat]

@Ruralguy: I tried what u adviced, and it works. but I do not see the relationship in my new database, how to find it ? please inform me, thanks

 

[RuralGuy]

What version of Access are you using?

 

[Ahmad Ruchiyat]

What version of Access are you using?

Now I am using MS Access 2010

 

[RuralGuy]

So when you go to Database Tools>Relationships nothing shows up in the window? Is your db split and you are looking at the FrontEnd? The relationships are in the BackEnd.

 

[Pat Hartman]

Do the import again and this time press the options button . Select relationships and import just those.

 

[RuralGuy]

Hi Pat. Thanks for pitching in. Glad to see you posting regular again.

 

[Ahmad Ruchiyat]

So when you go to Database Tools>Relationships nothing shows up in the window? Is your db split and you are looking at the FrontEnd? The relationships are in the BackEnd.

Yup I do not see nothing show up, my db is not splited, I do not understand on db split concept, I used to run my single db access file (*.accdb), inform me briefly, thanks

 

[RuralGuy]

Did you try what Pat Hartman suggested?

 

[Ahmad Ruchiyat]

Did you try what Pat Hartman suggested?

I'll try soon, because of large amount of objects (tables, forms, etc...) in my backup db I have to import from back up not in once import command (select all). u r last suggestion was it splited or not ? in MS Access 2010 I do not see this command in ribbon. Ok thanks for u r suggestion in contacting Pat Hartman.

 

[mac.vba]

Please look into:

http://www.access-programmers.co.uk/forums/showthread.php?p=1282863#post1282863