The following sample code loops through the table entries and displays a message box for each table entry that meets the specified criteria. The code can be modified to meet your needs:



Public Sub LoopTables()

   Dim oEntry As CTableEntry

   

   Dim oEntries As CTableEntries

   Set oEntries = New CTableEntries

   oEntries.Init REApplication.SessionContext

   

   For Each oEntry In oEntries

?Find the table entries for the table you need

       If oEntry.TableNumber = tbnumGiftLetters Then

?Insert your code here

           MsgBox oEntry.Fields(tableentry_fld_LONGDESCRIPTION)

       End If

       oEntry.CloseDown

   Next oEntry

   

   oEntries.CloseDown

   Set oEntries = Nothing

   

   Set oEntry = Nothing

   

   

End Sub

Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Microsoft Visual Basic and the tools used to create and debug procedures. Our Customer Support can help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality. If you are interested in learning more about the VBA and API modules, contact your account manager.