I am working on an application that allows that brings ups a form to select a winner form a SQL Server table. When I click on the menu option for this form I get the following error messages-- "ActiveX component can't create object" and "Run-time error '91': Oject variable or with block variable not set". This works absolutely fine in from my machine in VB, but I get these messages when I create an install the application on to the users PC.
I've been reveiwing my code and everything looks fine.
Can someone please help.