Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error appeared in VBA 2003 when form opened
Majp: The [Event Procedure] IS IN 'onClick' property of cmdSearch and it is already the 'way' to tell it to run the procedure. The error message is just too vague and point me to nowhere to find the source of the problem at all. No idea to what 'User-defined type not definited' is...- NorthK
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Error appeared in VBA 2003 when form opened
Thanks MajP, I found Event procedure in the OnLoad property of the Form, which is wrong. Now the error is gone but I have similar error as below when I clicked the Search button on the form. The following are the declaration on the form and code for the Search button. I checked the button...- NorthK
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Error appeared in VBA 2003 when form opened
I am experimenting to create a 3-tier vba app. User can use it to search employee data and display on it. But when I click to open the form, a dialogue box appears with the following error: The expression On Load you entered as the event property setting produced the following error...- NorthK
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
