Results 1 to 3 of 3
  1. #1
    ATLANTA is offline Novice
    Windows XP Access 2000
    Join Date
    Apr 2011
    Posts
    1

    Collection function

    Hi,
    I am trying to figure out what a below function would be doing:

    Public Function Clrclct(clct As Collection)
    For i = 1 To clct.Count
    clct.Remove 1


    Next
    End Function

    I can only add that it's later being used while exporting tables from access to excel.
    Will welcome and appreciate any ideas.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    do you have any ideas for what it does?? Actually, it's pretty vague. Without seeing a big picture, providing an answer to something like this really seems strange.
    Last edited by ajetrumpet; 04-17-2011 at 02:05 PM.

  3. #3
    Join Date
    Apr 2011
    Posts
    18
    It takes a collection and loops through it, clearing all items in that collection.

    The name itself Clrclct i guess stands for something like Clear Collection.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. HELP: Data Collection Box empty
    By Belle in forum Import/Export Data
    Replies: 2
    Last Post: 01-09-2011, 11:31 PM
  2. Data collection
    By ROB in forum Access
    Replies: 2
    Last Post: 11-06-2010, 04:18 PM
  3. Button Collection
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-30-2010, 10:21 PM
  4. Help with music collection database
    By compu in forum Forms
    Replies: 2
    Last Post: 07-10-2009, 04:51 PM
  5. Collection of Page Total
    By in forum Reports
    Replies: 1
    Last Post: 12-06-2006, 06:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums