kashif.special2005
Active Member
- Joined
- Oct 26, 2009
- Messages
- 443
Hi,</SPAN>
In Access</SPAN>
I am calling reference add module on Form_Load event but before going to Load event is giving me an error message and not call the Form_Load even I don’t know why</SPAN>
Private Sub Form_Load()</SPAN>
Call Excel_Add_Reference</SPAN>
Call OutLook_Add_Reference</SPAN>
Call DAO_Add_Reference</SPAN>
Me.To_Mail.Enabled = False</SPAN>
Me.To_Cc.Enabled = False</SPAN>
Me.Subject_Mail.Enabled = False</SPAN>
Me.Mail_Body_Mail.Enabled = False</SPAN>
Me.LstDublicate.Visible = False</SPAN>
Me.cmdQuarter.Enabled = False</SPAN>
Me.cmdRegion.Enabled = False</SPAN>
Me.cmdDomain.Enabled = False</SPAN>
Me.lstallrecordcount.Enabled = False</SPAN>
Me.lstselectedrecordcount.Enabled = False</SPAN>
Me.lstAll.Enabled = False</SPAN>
Me.cmdmoveone.Enabled = False</SPAN>
Me.cmdmoveall.Enabled = False</SPAN>
Me.cmdremoveone.Enabled = False</SPAN>
Me.cmdremoveall.Enabled = False</SPAN>
Me.lstSelected.Enabled = False</SPAN>
Me.txtFolder_Path.Visible = False</SPAN>
Me.cmdQuarter.Value = ""</SPAN>
Me.cmdRegion.Value = ""</SPAN>
Me.cmdDomain.Value = ""</SPAN>
Me.chkEnable_Template = False</SPAN>
Me.Ch_Send_Mail = False</SPAN>
Me.lstallrecordcount.Value = ""</SPAN>
Me.lstselectedrecordcount.Value = ""</SPAN>
End Sub</SPAN>
Error Message</SPAN>
The expression On Load you entered as the event property setting produced the followng error: User-defined type not defined.</SPAN>
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].</SPAN>
* There may have been an error evaluating the function, event, or macro.</SPAN>
Please help me to resolve this problem.</SPAN>
Thanks Kashif</SPAN>
In Access</SPAN>
I am calling reference add module on Form_Load event but before going to Load event is giving me an error message and not call the Form_Load even I don’t know why</SPAN>
Private Sub Form_Load()</SPAN>
Call Excel_Add_Reference</SPAN>
Call OutLook_Add_Reference</SPAN>
Call DAO_Add_Reference</SPAN>
Me.To_Mail.Enabled = False</SPAN>
Me.To_Cc.Enabled = False</SPAN>
Me.Subject_Mail.Enabled = False</SPAN>
Me.Mail_Body_Mail.Enabled = False</SPAN>
Me.LstDublicate.Visible = False</SPAN>
Me.cmdQuarter.Enabled = False</SPAN>
Me.cmdRegion.Enabled = False</SPAN>
Me.cmdDomain.Enabled = False</SPAN>
Me.lstallrecordcount.Enabled = False</SPAN>
Me.lstselectedrecordcount.Enabled = False</SPAN>
Me.lstAll.Enabled = False</SPAN>
Me.cmdmoveone.Enabled = False</SPAN>
Me.cmdmoveall.Enabled = False</SPAN>
Me.cmdremoveone.Enabled = False</SPAN>
Me.cmdremoveall.Enabled = False</SPAN>
Me.lstSelected.Enabled = False</SPAN>
Me.txtFolder_Path.Visible = False</SPAN>
Me.cmdQuarter.Value = ""</SPAN>
Me.cmdRegion.Value = ""</SPAN>
Me.cmdDomain.Value = ""</SPAN>
Me.chkEnable_Template = False</SPAN>
Me.Ch_Send_Mail = False</SPAN>
Me.lstallrecordcount.Value = ""</SPAN>
Me.lstselectedrecordcount.Value = ""</SPAN>
End Sub</SPAN>
Error Message</SPAN>
The expression On Load you entered as the event property setting produced the followng error: User-defined type not defined.</SPAN>
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].</SPAN>
* There may have been an error evaluating the function, event, or macro.</SPAN>
Please help me to resolve this problem.</SPAN>
Thanks Kashif</SPAN>