Tab control giving "On click" error for 1 user

[tg112001]

Hello,

I developed a .mdb file with a switchboard that has a tab control. The tab
control has 5 pages (or tabs). I have one particular user who is having a
problem with this control. When this user clicks on page 2, or 3, etc., he
gets an "On click" error - which suggests that he might be missing a
reference. So I checked his references and the only discrepancy is that he
has the "Microsoft Access 12.0 Object Library" while I have the 11.0 Object
Library. Could this really be the issue? I have 10-15 other users who use
the .mdb and none of them have this problem. Any suggestions??

Thanks for your review.

Tom G
- Data Analyst

 

[Rick Brandt]

Hello,

I developed a .mdb file with a switchboard that has a tab control.
The tab control has 5 pages (or tabs). I have one particular user
who is having a problem with this control. When this user clicks on
page 2, or 3, etc., he gets an "On click" error - which suggests that
he might be missing a reference. So I checked his references and the
only discrepancy is that he has the "Microsoft Access 12.0 Object
Library" while I have the 11.0 Object Library. Could this really be
the issue? I have 10-15 other users who use the .mdb and none of
them have this problem. Any suggestions??

Thanks for your review.

What are you doing in the Click event? By the way that does not fire when
the user changes pages if that is what you wanted it for.

The Access object library is based in the version of Access you are using to
run the file so that shouldn't have anything to do with it. The fact that
he gets an error could be lots of things besides a reference problem.

 

[tg112001]

Hi Rick,

The user just confirmed with me that the problem is actually with the command
buttons, and not the tabs as he initially pointed out. So the command
buttons are located in subforms (of the tab control). One subform per page.
The command buttons open up a related pivotchart, and the VBA is pretty
straight forward:

DoCmd.OpenForm "pivotchartform1", acFormPivotChart
DoCmd.Maximize

All of the command buttons have this kind of syntax, and what's strange is
that they work on the first page (or tab), but when he clicks on a new page,
the "On Click" error pops up when he clicks another command button. This
issue is only isolated to 1 (out of ~15 users).

Thanks again for anything you can suggest!

tg

Hello,

[quoted text clipped - 9 lines]

Thanks for your review.

What are you doing in the Click event? By the way that does not fire when
the user changes pages if that is what you wanted it for.

The Access object library is based in the version of Access you are using to
run the file so that shouldn't have anything to do with it. The fact that
he gets an error could be lots of things besides a reference problem.

 

[Rick Brandt]

Hi Rick,

The user just confirmed with me that the problem is actually with the
command buttons, and not the tabs as he initially pointed out. So
the command buttons are located in subforms (of the tab control).
One subform per page. The command buttons open up a related
pivotchart, and the VBA is pretty straight forward:

DoCmd.OpenForm "pivotchartform1", acFormPivotChart
DoCmd.Maximize

All of the command buttons have this kind of syntax, and what's
strange is that they work on the first page (or tab), but when he
clicks on a new page, the "On Click" error pops up when he clicks
another command button. This issue is only isolated to 1 (out of ~15
users).

Thanks again for anything you can suggest!

Is there nothing more to the error message besides "On Click Error"?

 

[tg112001 via AccessMonster.com]

Here's the full error dialog:

------------------------
HEADER
------------------------
The expression On Click 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 the macro, the name of a user-
defined function, or [Event Procedure].
* There may have been an error evaluating the function, event or macro.

----------------------
BODY
----------------------

Visual Basic for Applications (VBA) encountered a problem while attempting to
access a property or method. The problem may be one of the following:

- A reference is missing
- For help restoring missing references, see the Microsoft Knowledge Base
article 283806.
- An expression is mispelled
***END OF SCREENSHOT

Hi Rick,

[quoted text clipped - 14 lines]

Thanks again for anything you can suggest!

Is there nothing more to the error message besides "On Click Error"?

 

[Rick Brandt]

Here's the full error dialog:

------------------------
HEADER
------------------------
The expression On Click 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 the macro, the name of
a user- defined function, or [Event Procedure].
* There may have been an error evaluating the function, event or
macro.

----------------------
BODY
----------------------

Visual Basic for Applications (VBA) encountered a problem while
attempting to access a property or method. The problem may be one of
the following:

- A reference is missing
- For help restoring missing references, see the Microsoft Knowledge
Base article 283806.
- An expression is mispelled
***END OF SCREENSHOT

Is this app being run in the runtime environment? That error message is the
classic one you get when an error occurs in the runtime where you do not have an
error handler. The content of the message and the suggestions it makes are
almost never helpful.

I suggest putting a proper error handler on that event and then having the user
try it again. You might get an error message that actually tells you something
useful.