In your VB IDE, make sure you have a reference set to "Microsoft ActiveX Data Objects 2.X Object Library". Then go to the object browser (F2). In the classes list on the left had side of the screen click on DataTypeEnum. It will list them for you.
Hope this helps
HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman
Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.
Come to think of it, if you try using the .Append method (as detailed in the code example), when you get to the data type, intellisense will give you the full list to pick from.
HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman
Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.