A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Switchboard won't work on Vista



 
 
Thread Tools Display Modes
  #1  
Old July 8th, 2009, 07:05 PM posted to microsoft.public.access
Smigidy
external usenet poster
 
Posts: 20
Default 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  
Old July 10th, 2009, 12:28 AM posted to microsoft.public.access
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default 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  
Old July 10th, 2009, 05:36 PM posted to microsoft.public.access
Smigidy
external usenet poster
 
Posts: 20
Default 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  
Old July 10th, 2009, 07:38 PM posted to microsoft.public.access
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default 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  
Old July 10th, 2009, 09:03 PM posted to microsoft.public.access
Smigidy
external usenet poster
 
Posts: 20
Default 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  
Old July 10th, 2009, 09:42 PM posted to microsoft.public.access
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.