<div>
In line with ampapa's suggestion above, I've found that code readability, especially 6 months after I last looked at it, is greatly improved by DIMming everything with the type library it comes from, i.e., <br />
Public cn As ADODB.Connection<br />
...<br />
Set cn = New ADODB.Connection<br />
<br />
etc.<br />
<br />
For what it's worth...
</div>


In line with ampapa's suggestion above, I've found that code readability, especially 6 months after I last looked at it, is greatly improved by DIMming everything with the type library it comes from, i.e.,
Public cn As ADODB.Connection
...
Set cn = New ADODB.Connection

etc.

For what it's worth...

<div>
Wow thanks ampapa you are right :)<br />

</div>


<div>
<div class="content wysiwyg-content">
Sorry I am just a beginner to vb and I am using vb 6 Enterprise edition.<br />
When I do,<br />
<br />
&nbsp;Public cn As Connection<br />
&nbsp;Private Sub cmdLogin_Click()<br />
&nbsp;Set cn = New Connection<br />
<br />
&nbsp;So as soon as I type the word &quot;New&quot; in the above statement a list is appearing having word &quot;Collection&quot; but its not &nbsp;having &quot;Connection&quot;. But iam having a project done by my friend and when I checked the same it showed &quot;Connection&quot; in that pop up list. So what is the problem? Thanks.<br />

</div>
</div>


Sorry I am just a beginner to vb and I am using vb 6 Enterprise edition.
When I do,

 Public cn As Connection
 Private Sub cmdLogin_Click()
 Set cn = New Connection

 So as soon as I type the word "New" in the above statement a list is appearing having word "Collection" but its not  having "Connection". But iam having a project done by my friend and when I checked the same it showed "Connection" in that pop up list. So what is the problem? Thanks.


Problem in Set cn = New Connection

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.