TableNo

Method
Retrieves the number of the table with a specified table name.

Category
Tables

 

Syntax
Function TableNo(ByVal TableName As String) As Long

TableName
The name of the table whose number is to be retrieved.

 

Example

' Case TableNo

  tmpVar = CF1.TableNo("Item")

  If VarType(tmpVar) = vbLong Then

  logWr "TableNo OK. Retrieved " & tmpVar

  Else

  logWr "TableNo failed. It didn't return a long"

  End If

 

Comments
This function is only needed by applications that do not support a table number. It is used to convert a name into a number so that it can be used by the OpenTable function.

If TableName does not exist, 0 is returned.

For more information about tables, see the Application Designer’s Guide.



© 2009 Microsoft Corporation. All rights reserved.