Loading

Error correction

1 post / 0 new
Offline
Joined: 08/06/2010
Error correction

Hai:

When i runned this pgm i have an error user defined type not defined
can anybody correct this error

Private Sub CommandButton8_Click()
Dim Cnn As ADODB.Connection
Dim strConnect As String
Set Cnn = New ADODB.Connection

strConnect = "database=C:\Documents and Settings\Mdb\estmstr.mdb;Provider=Microsoft.Jet.OLEDB.4.0"
With Cnn
.CursorLocation = adUseClient
.Open strConnect
End With

Set Rst = New ADODB.recordset
Rst.ActiveConnection = Cnn

End Sub

Add new comment

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.