|
-
Aug 11th, 2005, 07:05 AM
#4
Thread Starter
New Member
Re: Class Module
hmmm, sort of get it. This is what I have done: but, would I then have to set the variable (BlnTableName) = equal TestForTable somewhere?
Option Compare Database
Public BlnTableName As Boolean
Public Function TestForTable(ByVal strTablename As String) As Boolean
On Error Resume Next
Dim strName As String
TestForTable = False
strName = DBEngine(0)(0).TableDefs(strTablename).Name
If Err.Number = 0 Then
TestForTable = True
Else
Err.Clear
End If
End Function
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|