If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Switchboard won't work on Vista
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. |
#2
|
|||
|
|||
Switchboard won't work on Vista
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" wrote: 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. |
#3
|
|||
|
|||
Switchboard won't work on Vista
I took out the maro and module for ease of use, and the switchboard still
gives me the same error. "Clifford Bass" wrote: 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" wrote: 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. |
#4
|
|||
|
|||
Switchboard won't work on Vista
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" wrote: I took out the maro and module for ease of use, and the switchboard still gives me the same error. |
#5
|
|||
|
|||
Switchboard won't work on Vista
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" wrote: 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" wrote: I took out the maro and module for ease of use, and the switchboard still gives me the same error. |
#6
|
|||
|
|||
Switchboard won't work on Vista
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 "Smigidy" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|