var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ActiveX component can't create objects ??
When I ran a procedure , an error message appeared saying:
"ActiveX component can't create objects".
The offending statement is as follow:
Set CDB = CurrentDB()
(CDB was declared as database type)
Does anybody know what is the cause of this weird error message ??
check references and add DAO 3.6 or 3.5 whichever is availble to you
Is that the reason ?
But I have already chosen DAO 3.51 in the References dialog box.
That error message appeared despite of that.
Thank you very much in advance.
I had the same error when I tried to assign a value or change properties of an array of list boxes on the main form from a pop up form.
Solution was to declare an array variable on the pop form and assign it with values of list boxes of the main form:
main form: frmMain
arrLists = Array(List1, List2) ' list box controls on the main form
pop up form:
arrLists = Array(Forms!frmMain.List1, Forms!frmMain.List2)
This allowed me to assign values to the main form's list boxes and manipulate their properties from a pop up form:
arrLists(1).Visible = True
arrLists(1).RowSource = " ... "
Last edited by The Byte; 02-14-04 at 02:18.
I won't byte... hard!
Does anybody have any idea ??