Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #11024
| From | Ulrich Möller <knobbi38@arcor.de> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: help with array code |
| Date | 2015-08-21 11:39 +0200 |
| Organization | A noiseless patient Spider |
| Message-ID | <mr6rha$4ii$1@dont-email.me> (permalink) |
| References | <d5b1f243-9498-41cb-bb56-7874e18b3043@googlegroups.com> <mr53bg$flr$1@dont-email.me> |
Am 20.08.2015 um 19:40 schrieb Ulrich Möller: > Am 20.08.2015 um 17:43 schrieb bobh: >> Hi All, >> >> I'm not getting it I searched around put I didn't find anything >> specific to my need so >> >> I have a multi-value field which I am trying to determine in what >> position "1" is >> I thought this would doo it but it does not work I get a subscript >> out of range error; >> >> Dim MyArray, strPosCnt >> MyArray = Array(MyRec!Priority) >> Do Until MyRec.EOF >> For i = 0 To UBound(MyArray) >> If MyArray(i) = "1" Then >> strPosCnt = i >> Exit For >> End If >> Next i >> >> with the Priority field containing values >> Priority field >> 2,1,3,4 >> 1,4,3,2 >> 9,6,1 >> 1 >> 3,7,4,1 >> >> I would want strPosCnt to be >> 2 >> 1 >> 3 >> 1 >> 4 >> >> any help with the code is greatly appreciated. >> bobh > MVFs are represented as a recordset instead of an array. > To get the "inner" recordset with the mvf values: > > set rstMVF = MyRec!Priority.Value > do until rstMVF.EOF > ' something todo > loop > > You can handle the MVF-Recordset in the same manner as usual recordsets. > > Ulrich > > Hi Bobh, forget my posting. I was thinking of a real MVF-Field but you asked about a field with combined values. That's a completely different topic. Ulrich
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
help with array code bobh <vulcaned@yahoo.com> - 2015-08-20 08:43 -0700
Re: help with array code Ulrich Möller <knobbi38@arcor.de> - 2015-08-20 19:40 +0200
Re: help with array code Ulrich Möller <knobbi38@arcor.de> - 2015-08-21 11:39 +0200
Re: help with array code Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-08-20 10:53 -0700
Re: help with array code bobh <vulcaned@yahoo.com> - 2015-08-21 06:16 -0700
Re: help with array code Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-08-21 10:37 -0700
Re: help with array code "Phil" <phil@stantonfamily.co.uk> - 2015-08-22 00:32 +0100
Re: help with array code "Phil" <phil@stantonfamily.co.uk> - 2015-08-22 10:08 +0100
Re: help with array code bobh <vulcaned@yahoo.com> - 2015-08-24 07:53 -0700
Re: help with array code Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-08-24 09:38 -0700
csiph-web