VBÔÚÏßÇóÖú£¬¼±~~ - VB / ¿Ø¼þ
Õâ¸öFunction±àÒëʱÌáʾcan't find project or library
Ó¦¸ÃÊÇÀà¿âûÓÐÌí¼Ó°É£»ÒªÔõô×ö²ÅÐа¡£¿
Ó¦¸ÃÊÇDataComboÕâ¸öµÄÎÊÌâ
Public Sub FilterDataCombo(ByVal idacbo As DataCombo, ByVal BoundColumn As String, ByVal ListField As String, ByVal iRsdacbo As ADODB.RecordSet)
Dim strTmpData As String
Dim rstmp As ADODB.RecordSet
On Error GoTo err
If iRsdacbo Is Nothing Then Exit Sub
strTmpData = Trim(idacbo.BoundText)
iRsdacbo.Filter = adFilterNone
If strTmpData <> "" Then
iRsdacbo.Filter = BoundColumn & " like " & kk(strTmpData & "%")
End If
Set rstmp = rsCopy(iRsdacbo)
GetDatadacboGotFocus idacbo, rstmp, BoundColumn, ListField, , IIf(Trim(strTmpData) <> "", False, True)
iRsdacbo.Filter = 0
Exit Sub
err:
Call GetMsg(E_OnErrMsg, "[ FilterDataCombo ]ErrNo:" & err.Number & " ErrDesc:" & err.Description)
End Sub
¶¼ÒýÓÃÁË¡£»¹ÊDz»ÐÐ
³ö´íÐÐÖ¸ÏòÄÄÌõÓï¾ä£¿
ÔÚIDEÀïÔËÐÐһϿ´¿´ÊÇ·ñ³ö´í£¬³ö´íÐÐÖ¸ÏòÄÄÀï¡£
¼ÇµÃ×¢µôon error Ö®ÀàµÄÓï¾ä
³ö´íÖ¸ÏòPublic Sub FilterDataCombo(ByVal idacbo As DataCombo, ByVal BoundColumn As String, ByVal ListField As String, ByVal iRsdacbo As ADODB.RecordSet)
°ÑByVal idacbo As DataComboÄõô¾Í¿ÉÒÔÁË
{{-
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÎÒÏë¸ù¾ÝtreeviewÉÏÿ¸ö½ÚµãµÄȨÏÞ£¬Ã»ÓÐȨÏ޵Ľڵ㲻Äܱ»Ñ¡ÖУ¬¶øÇҳɻÒÉ«£¬ÔõôʵÏÖ£¬ÔÚÏߵȡ£¡£¡£
Õâ¸ö£¿¡£¡£¡£
Ã²ËÆÃ»·¨¡£
ÊÔÊÔÄܲ»ÄܸÄijЩnodeµÄÑÕÉ«£¬¼Ç¼ÏÂÉϴεÄnodeclickÀïµÄnode¡£
Ï´εã»÷µÄÈç¹ ......
Êý¾Ý¿âÀïÓÐÒ»¸ö×ֶεÄÄÚÈÝÊǶþ½øÖÆ£¬Ôõô²ÅÄܰÑÕâ¸ö¶þ½øÖƶÁ³öÀ´
ʹÓÃ×Ö½ÚÁ÷¶ÔÏó¿ÉÒÔʵÏÖ
ÀýÈçÏÖÔÚÊý¾Ý¿âÀïÓиö×ֶεÄÄÚÈÝÊÇ0x504B03040A0000000800407F263C3B02465390000000820000000A0000006273CECACCE22E7478 ......
Ôõô°ÑÒÑÖªµÄÊý¾Ý±£´æ³ÉxmlÎļþ£¬ÏÖÔÚÒÑÖªµÄÊý¾ÝÊÇ
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o=& ......
ÎÊÌ⣺
ÏÖÔÚAccessÊý¾Ý¿âÖÐÓÐÁ½ÕűíTableAºÍTableB
TableAÖÐÓмǼÈçÏÂ:
×Ö¶Î1(Name) ×Ö¶Î2(Num)
A 3
A 4
B 6
... ......