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
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