License required to use this ActiveX control

  • Thread starter Thread starter CSDunn
  • Start date Start date
C

CSDunn

Hello,
I have an MS Access 2003 ADP in which all of the Forms, Reports, and Macros
were imported from an MS Access 2002 ADP. I have spent some time testing the
2003 ADP, and it works pretty much like the old one with one hitch. The
machine on which I am testing the 2003 ADP has MS Office 2003 Professional
installed.

I have a Form/Subforms in one part of the 2003 ADP that is not working
correctly. In the main form, I have a combo box named Combo48 that is
populated with student names from a SQL Server 2000 database View. When a
name is selected, a macro runs with the On_Change event of Combo48. The
macro is called mcrMain.showCorrRptCrd. The macro is designed to evaluate
the grade level of a student (00 trough 05) and show the correct subform
based on the grade value. A portion of the macro looks like this:

Macro Name Condition
Action Item
Expression

mcrMain.showCorrRptCrd [Forms]![frmRCMain]![grade]='00' SetValue
[Forms]![frmRCMain]![frmRCK].[Form].[Visible] Yes
...
SetValue [Forms]![frmRCMain]![label16].[Visible] No
...
SetValue [Forms]![frmRCMain]![frmRC1].[Form].[Visible] No
...
SetValue [Forms]![frmRCMain]![frmRC2].[Form].[Visible] No

The condition of the macro evaluates each grade level this way through grade
level 05, makes the applicable form visible, or turns off label16 and the
other forms that do not apply. The subforms are all 'stacked' in the Detail
section of the main form, and Combo45 is in the Form Header.

After all grades have been evaluated, the very last step of the macro takes
a SetValue action on the [Forms]![frmRCMain]![Permnum].[Visible] Item and
sets the Expression to YES.

The problem is that when I make a selection from Combo48, label16 remains
visible, and the following message appears:
****************************************************************************
*
You don't have the license required to use this ActiveX Control.
You tried to open a from containing an OLE object or an ActiveX control or
you tried to create an ActiveX control.
To obtain the appropriate license, contact the company that provides the
licensed OLE object or ActiveX control.
****************************************************************************
*
When I click the okay button of this message, I get an 'Action Failed'
dialog box that points to mcrMain.showCorrRptCrd, and the SetValue action.
When I click 'Halt' on this box, the Action Failed dialog box goes away,
label16 ("Please make a selection from the drop down list above to view a
report card.") appears below Combo48 in the sub form, but a frmRC(x) does
not appear.

What could be causing this problem, and can I fix the problem?

Thank you for your help!

CSDunn
 
This may be the same bug that just bit me in Access 2003. After
making/deleting several changes to the VBA code for a form, I got a similar
error. If I deleted all the procedures on the form, the error went away, but
as soon as I re-entered the form change event - even though it was just two
lines Private Sub, End Sub, the error reappears. The only answer was to
delete the form and start again!

I assume Access maintains some internal table relating the form and VBA
code, and this has become corrupted. Someone should bug this to MS.

Colin




CSDunn said:
Hello,
I have an MS Access 2003 ADP in which all of the Forms, Reports, and
Macros
were imported from an MS Access 2002 ADP. I have spent some time testing
the
2003 ADP, and it works pretty much like the old one with one hitch. The
machine on which I am testing the 2003 ADP has MS Office 2003 Professional
installed.

I have a Form/Subforms in one part of the 2003 ADP that is not working
correctly. In the main form, I have a combo box named Combo48 that is
populated with student names from a SQL Server 2000 database View. When a
name is selected, a macro runs with the On_Change event of Combo48. The
macro is called mcrMain.showCorrRptCrd. The macro is designed to evaluate
the grade level of a student (00 trough 05) and show the correct subform
based on the grade value. A portion of the macro looks like this:

Macro Name Condition
Action Item
Expression

mcrMain.showCorrRptCrd [Forms]![frmRCMain]![grade]='00' SetValue
[Forms]![frmRCMain]![frmRCK].[Form].[Visible] Yes
...
SetValue [Forms]![frmRCMain]![label16].[Visible] No
...
SetValue [Forms]![frmRCMain]![frmRC1].[Form].[Visible] No
...
SetValue [Forms]![frmRCMain]![frmRC2].[Form].[Visible] No

The condition of the macro evaluates each grade level this way through
grade
level 05, makes the applicable form visible, or turns off label16 and the
other forms that do not apply. The subforms are all 'stacked' in the
Detail
section of the main form, and Combo45 is in the Form Header.

After all grades have been evaluated, the very last step of the macro
takes
a SetValue action on the [Forms]![frmRCMain]![Permnum].[Visible] Item and
sets the Expression to YES.

The problem is that when I make a selection from Combo48, label16 remains
visible, and the following message appears:
****************************************************************************
*
You don't have the license required to use this ActiveX Control.
You tried to open a from containing an OLE object or an ActiveX control or
you tried to create an ActiveX control.
To obtain the appropriate license, contact the company that provides the
licensed OLE object or ActiveX control.
****************************************************************************
*
When I click the okay button of this message, I get an 'Action Failed'
dialog box that points to mcrMain.showCorrRptCrd, and the SetValue action.
When I click 'Halt' on this box, the Action Failed dialog box goes away,
label16 ("Please make a selection from the drop down list above to view a
report card.") appears below Combo48 in the sub form, but a frmRC(x) does
not appear.

What could be causing this problem, and can I fix the problem?

Thank you for your help!

CSDunn
Click to expand...
 
Back
Top