16353.html
来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 23 行
HTML
23 行
<html>
<head>
<title>Re: 请问在VB6下,如何开启 index 。(急)</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>Re: 请问在VB6下,如何开启 index 。(急)</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:Luo570@ms31.hinet.net">小琳小姐</a> on July 29, 1999 at 11:56:38:<p>
In Reply to: <a href="16321.html">Re: 请问在VB6下,如何开启 index 。(急)</a> posted by 小琳 on July 28, 1999 at 20:52:02:<p>
小琳小姐,您好!<br>首先谢谢您的回应。我的程式如下:<br>在VB6下的程式码是:<p>'以下用来开启 PEOPLE.mdb 之设定<br>Dim pplConn As New ADODB.Connection<br>Dim pplRS As New ADODB.Recordset<p>'以上用来开启 eMbox.mdb 之设定<br>Dim eMConn As New ADODB.Connection<br>Dim eMrseMBox As New ADODB.Recordset<br>Dim eMrsCounter As New ADODB.Recordset<p>Private Sub Form_Load()<br>'以下是 people.mdb 之设定<br>Dim pplConnStr As String '设定资料库开启变数<br>Dim mpplPath As String '设定路径<br>Dim mPW As String '设定密码变数<p>'以下是 eMbox.mdb 之设定<br>Dim eMConnStr As String<br>Dim eMpath As String<p><br> Me.Height = Screen.Height * 0.7<br> Me.Width = Screen.Width * 0.7<br> Me.Move (Screen.Height - Me.Height) \ 2, (Screen.Width - Me.Width) \ 2<br> cmdButton ("Clear")<br> <br> mPW = "zhenguan"<br> <br> eMpath = App.Path + "\mdb\eMbox.mdb"<br> eMConnStr = "Provider=Microsoft.jet.OLEDB.3.51" & _<br> ";data source=" & eMpath<br> eMConn.Open eMConnStr<br> eMrseMBox.CursorLocation = adUseClient<br> '开启 eMbox.mdb<br> eMrseMBox.Open "eMbox", eMConn, adOpenKeyset, adLockPessimistic<br> '开启 counter.mdb<br> eMrsCounter.Open "Counter", eMConn, adOpenKeyset, adLockPessimistic<br> <br> <br> mpplPath = App.Path + "\mdb\people.mdb"<br> pplConnStr = "Provider=Microsoft.jet.OLEDB.3.51" & _<br> "; jet OLEDB:Database Password= " & mPW & _<br> "; Data Source=" & mpplPath<br> <br> pplConn.Open pplConnStr '开启资料库<br> pplRS.CursorLocation = adUseClient<br> pplRS.Open "NameComm", pplConn, adOpenKeyset, adLockPessimistic<br> '开启资料表<br> <br> pplRS.Index = "pplSeq" 问题出在这里<br> <br> Do While Not pplRS.EOF<br> If pplRS.Fields("MOC") = "电邮" Then<br> cboContact.AddItem pplRS.Fields("Cname") + Str(pplRS.Fields("pplseq"))<br> cboeMaddress.AddItem pplRS.Fields("NOC")<br> End If<br> <br> pplRS.MoveNext<br> <br> Loop<br> <br>End Sub<p>如果能够得到您的帮助,那就太感激了!<br>我的e-mail是:forestlsw@hutchcity.com<p><p><p><p>: : 本人在VB5下曾经用下列方式开启index,但在VB6下开启郤显示”不支援<br>: : ”等错误讯息,请问各位高手应如何解决?<br>: : VB5下使用index之情况:<br>: : rs.index="index 名称"<p>: : 谢谢!<p>: :::既然vb6有的话,VB6也应该会有支援才对,可否将程式<br>: 或资料库传给小女子看看(Luo570@ms31.hinet.net)!!!<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 16353-->
</ul><!--end: 16353-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?