By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

using split function in access

atksamy
P: 91
i am trying to get the values of a column in to an array

Expand|Select|Wrap|Line Numbers
  1. vari_able = Split(rs.Fields(astrFields(intIx)).Value, ",")
astrFields(intIx)). points to the field name.

but i am not getting all the values of the field i am gettin only one value
vari_able is declared as variant
Nov 5 '08 #1
Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,636
Are the values in the specific Column Delimited by a ','?
Nov 5 '08 #2

atksamy
P: 91
no they are not i guess i made a mistake on that
Nov 5 '08 #3

NeoPa
Expert Mod 15k+
P: 31,489
What is the context of this code (the whole procedure it's in).

It looks like some of mine but done wrong. The elements appear in the wrong places in the code you've posted.
Nov 6 '08 #4

NeoPa
Expert Mod 15k+
P: 31,489
Ignore that last post - it's nonsense :(

The code is fine if you have data in a single field that should contain commas (,).

What you need to do is find out the actual contents of rs.Fields(astrFields(intIx)) at runtime.
Nov 6 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.