Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Kiwi CatTools > Kiwi CatTools 3.11 Administrator Guide > API > CatTools API Classes > Groups > Sample code to list Groups found in your database

Sample code to list Groups found in your database

Table of contents
No headers
Created by Caroline Juszczak, last modified by Caroline Juszczak on Jun 28, 2016

Views: 21 Votes: 0 Revisions: 1

Sample VB code showing you how to list the Groups found in your database using the CatTools API.


Dim DB As CatToolsAPI.Database

Dim Groups As CatToolsAPI.Groups

Dim Group As CatToolsAPI.Group


Set DB = New CatToolsAPI.Database



If DB.Connected Then

Set Groups = DB.Groups

If Not Groups Is Nothing Then

Debug.Print Groups.Count & " groups in the database"

For Each Group In Groups

Debug.Print "->" & Group.Name




Msgbox "Error:" & DB.ErrDescription

End If


Msgbox "Connection failed: " & DB.ErrDescription

End If




Set Group = Nothing

Set Groups = Nothing

Set DB = Nothing

Last modified
07:23, 28 Jun 2016