Switchboard won't work on Vista

[Smigidy]

I changed from XP to Vista and my switchboard gives me an error. My
switchboard has a macro that runs a module.

It says:

The expression On Open 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 ben an error evaluating the function, event, or macro.

 

[Clifford Bass]

Hi,

What do you mean by "runs a module"? That it runs a subroutine or
function or something else? If a subroutine or function, why not just run
that directly? Or is that one things of several things that the macro does?
If a subroutine or function, is the error happening within the subroutine or
function? Or is the macro unable to even call the routine? If none of that
helps get you pointed in a useful direction, post the specifics instead of
generalities.

Clifford Bass

 

[Smigidy]

I took out the maro and module for ease of use, and the switchboard still
gives me the same error.

Hi,

What do you mean by "runs a module"? That it runs a subroutine or
function or something else? If a subroutine or function, why not just run
that directly? Or is that one things of several things that the macro does?
If a subroutine or function, is the error happening within the subroutine or
function? Or is the macro unable to even call the routine? If none of that
helps get you pointed in a useful direction, post the specifics instead of
generalities.

Clifford Bass

I changed from XP to Vista and my switchboard gives me an error. My
switchboard has a macro that runs a module.

It says:

The expression On Open 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 ben an error evaluating the function, event, or macro.

 

[Clifford Bass]

Hi,

So, when is it that the error is happening? When you open the
Switchboard? When you click on any of the items on the menu? Also, just to
be sure we are not talking about something different--is this the Switchboard
that Access automatically generates with the Switchboard wizard? And, what
version of Access?

Clifford Bass

 

[Smigidy]

This happens when I click on the Switchboard form. In Access 2003 I only get
the error message. In Access 2007 I get a blank Switchboard showing only the
title, and then I get the error message. I created the switchboard from
Tools, Switchboard Manager.

Thanks

 

[Clifford Bass]

Hi,

It may be that something is missing from your installation of Vista
that was there in XP. Try this: Go to the VBA Editor (<Alt>-,F11>). Make
sure that code is not running; go to Run menu and choose Reset. Then go to
the Tools menu and then the References item. Look at all of those that are
checked. Do any start with the word "MISSING:"? If so, make a note of them
and then uncheck them. Then scroll down in the list and see if you can find
newer versions. If so, check them. If not, they may not be needed. Click
OK. Then go to the Debug menu and choose Compile database. Does it compile?
If so, quit out of Access and go back in. Does it now work? If it gives
you errors when you try to compile, what is the error and what is the
contents of the line where it gives the error?

Clifford Bass