19127.html

来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 23 行

HTML
23
字号
<html>  <head>    <title>Re: 请问如何侦测资料库中的某个Table是否存在??</title>  </head>  <body bgcolor="#FFFFFF" vlink="#808080">    <center>      <h1>Re: 请问如何侦测资料库中的某个Table是否存在??</h1>    </center><hr size=7 width=75%><hr size=7 width=75%><p>Posted by SUNG on September 19, 1999 at 12:00:30:<p>In Reply to: <a href="19111.html">Re: 请问如何侦测资料库中的某个Table是否存在??</a> posted by 小琳 on September 18, 1999 at 20:03:59:<p>: : 用VB程式还是用SQL语法??<p>: :::SQL语法应该没有这种功能!!!<p>以下给你参考!<br>DB是用MSDBJET打开的资料库!TBNAME是要检查的TABLE NAME!<br>Public Function ISTABLE(DB As Database, TBNAME As String) As Boolean<br>Dim TB As DAO.TableDef<br>ISTABLE = False<br>For Each TB In DB.TableDefs<br>    If TB.Attributes = 0 And Trim(TB.Name) = Trim(TBNAME) Then<br>        ISTABLE = True<br>        Exit For<br>    End If<br>Next<br>Set TB = Nothing<br>End Function<br><br><br><hr size=7 width=75%><p><a name="followups">Follow Ups:</a><br><ul><!--insert: 19127--></ul><!--end: 19127--><br><hr size=7 width=75%><p></body></html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?