Loading

bug report

1 post / 0 new
Offline
Joined: 08/06/2010
bug report

Hai:
I have vba coding like this,

Set conn = New ADODB.Connection
conn.provider = "Microsoft.jet.OLEDB.4.0"
conn.Open "c:acc/estmstr.mdb"
Dim acc As ADODB.Recordset
Set acc = New ADODB.Recordset
estmstr.Open "estmstr", conn, est_code, est_ext, est_name
acc.MoveFirst
Do Until acc.EOF
Msg box(estmstr.fields("ID"))
acc.MoveNext
Loop
acc.Close
Set acc.activeConnection = Nothing
conn.Close
Set conn = Nothing
End sub

but it shows the error user defined type not defined, how to i define that error
Dim conn new.adodb connection is correct ? or send some source for this

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.