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 + -
显示快捷键?