Yussi Ariefiyono
Check if table is exist vba
Problem:
Check if table is exist
Solution:
Option Compare Database
Public Function TableExists(strTable As String) As Boolean
Dim strName As String
On Error Resume Next
‘If table exists already then strName will be > “”
strName = CurrentDb.TableDefs(strTable).name
TableExists = Not (strName = “”)
End Function
| Print article | This entry was posted by yussi ariefiyono on February 8, 2010 at 9:21 am, and is filed under vba. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |