I have a COM-visible object written in C# that accepts a list of string arrays. Could I send a Collection of string arrays from Access 2000 to this object and it work? If not, then what is the best way to send multiple string arrays to my C# object from Access 2000?
-
1Note that Access uses VBA. Which is very close but not quite the same as VB6.Tony Toews– Tony Toews2010-08-17 05:12:45 +00:00Commented Aug 17, 2010 at 5:12
-
Oh ok. I just started programming in Access not too long ago. So this is all still kinda confusing to me. I tested out my COM-visible object code in a separate project and called it from a Main method. It worked with a List of string arrays passed to it, but since I have been trying to call it from Access, I have had no luck.Spidermain50– Spidermain502010-08-17 23:10:13 +00:00Commented Aug 17, 2010 at 23:10
-
Oops, bad day. I thought I was in the text box when I hit enter.Michael Myers– Michael Myers ♦2010-08-18 22:15:20 +00:00Commented Aug 18, 2010 at 22:15
Add a comment
|
2 Answers
You can't marshal generics but using Collection on the VB6 side is a workable solution. Effectively convert your List to a standard collection.
Here's something that elaborates more: http://www.codeproject.com/KB/COM/netclasslistvb6.aspx?display=Print
2 Comments
David-W-Fenton
I'm an experienced Access programmer, but I can't see how the cited URL answers the question. Can you draw it out a bit?
Timwi
The question was phrased incorrectly, referring to VB6 when the asker meant VBA. The asker clarified this by posting a duplicate question. I edit this question accordingly.
I do a lot of com add in work on VBA and vb.net - I find replacing a List (of T) in vb.net with an arraylist works very well in VBA, not all the properties expose exactly the same way in Access, but you can work around it.
