A
Abbey Normal
Hi - I am trying to access the results of a function that checks to see if an
object exists: I downloaded it from
http://www.mvps.org/access/modules/mdl0014.htm
It works great of course, but I'm not sure how to retrieve the results from
within my module. I tried something like this:
Call ObjectExists("Table", "TrayLabels")
If ObjectExists = True Then
DoCmd.DeleteObject acTable, strImportTableName
End If
but it didn't seem to like it.
The code for the function ObjectExists is:
Function ObjectExists(strObjectType As String, strObjectName As String) As
Boolean
(etc.) and if I debug this, I can see that the correct results for
ObjectExists, but I don't know how to access that from my module.
Can anyone tell me what I'm missing? Thank you.
object exists: I downloaded it from
http://www.mvps.org/access/modules/mdl0014.htm
It works great of course, but I'm not sure how to retrieve the results from
within my module. I tried something like this:
Call ObjectExists("Table", "TrayLabels")
If ObjectExists = True Then
DoCmd.DeleteObject acTable, strImportTableName
End If
but it didn't seem to like it.
The code for the function ObjectExists is:
Function ObjectExists(strObjectType As String, strObjectName As String) As
Boolean
(etc.) and if I debug this, I can see that the correct results for
ObjectExists, but I don't know how to access that from my module.
Can anyone tell me what I'm missing? Thank you.