Prev: Recording database usage
Next: Case Statement Problem
From: Brian Griffey on 14 May 2010 16:28
I have been trying to read a mutivalue field in an Access 2007 without any
luck. I have followed the example at
http://msdn.microsoft.com/en-us/library/bb258183.aspx but have not been able
to get that to work. Has anyone sucessfully accomplished this task?
From: Arvin Meyer [MVP] on 14 May 2010 18:14
Using multi-valued fields in a relational database is against normalization
rules and should not be done. Microsoft included the ability to do so so
that Access could function with SharePoint. If you are not using SharePoint,
and have no plans to do so, rebuild your data table with a single value per
field.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Brian Griffey" <BrianGriffey(a)discussions.microsoft.com> wrote in message
news:07000165-08B4-4190-8C49-A91B3DFCBFB5(a)microsoft.com...
>I have been trying to read a mutivalue field in an Access 2007 without any
> luck. I have followed the example at
> http://msdn.microsoft.com/en-us/library/bb258183.aspx but have not been
> able
> to get that to work. Has anyone sucessfully accomplished this task?


From: Douglas J. Steele on 14 May 2010 19:52
In addition to what Arvin said, are you trying to do this with the new accdb
file format, or using the older mdb file format?

The new features of Access 2007 are only available in the accdb file format.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Brian Griffey" <BrianGriffey(a)discussions.microsoft.com> wrote in message
news:07000165-08B4-4190-8C49-A91B3DFCBFB5(a)microsoft.com...
>I have been trying to read a mutivalue field in an Access 2007 without any
> luck. I have followed the example at
> http://msdn.microsoft.com/en-us/library/bb258183.aspx but have not been
> able
> to get that to work. Has anyone sucessfully accomplished this task?


From: Jan v Putten on 15 May 2010 03:19
Try this,

where 'functies' is the name of the multi-valued field and 'postboek' the
table-name

Dim rs As New ADODB.Recordset
Dim sql, s
sql = "SELECT Postboek.functies.value, ID From Postboek "
rs.Open sql, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
MsgBox (rs.RecordCount)
Do While Not rs.EOF
s = s & "Functies: " & rs.Fields("postboek.functies.value") & " ID=" &
rs.Fields("ID") & vbCrLf
rs.MoveNext
Loop
MsgBox s

Good luck ,

Jan van Putten

"Brian Griffey" <BrianGriffey(a)discussions.microsoft.com> schreef in bericht
news:07000165-08B4-4190-8C49-A91B3DFCBFB5(a)microsoft.com...
>I have been trying to read a mutivalue field in an Access 2007 without any
> luck. I have followed the example at
> http://msdn.microsoft.com/en-us/library/bb258183.aspx but have not been
> able
> to get that to work. Has anyone sucessfully accomplished this task?

 | 
Pages: 1
Prev: Recording database usage
Next: Case Statement Problem