?
Solved

Collection objects editable?

Posted on 2001-06-20
2
Medium Priority
?
177 Views
Last Modified: 2010-05-02
Hi,

Is it possible to edit a UDT after it has been added to a collection? I want to do the following:

colRows.Item(lngCurrRecord).arrFields(Index) = Value

As far as I can tell the only way to do this is to set a variable equal to the udt, remove the item from the collection, change the udt, then re-add it to the collection, which is not very clean or efficient.

Zaphod.
0
Comment
Question by:Z_Beeblebrox
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
rmichels earned 200 total points
ID: 6212969
What I generally do is create an object that wraps the UDT.  Then use methods on the object to access the internal components of the UDT
0
 
LVL 7

Author Comment

by:Z_Beeblebrox
ID: 6214909
Well that works. It's strange that just using a UDT doesn't work. Oh well.

Zaphod.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question