View Single Post
  #2 (permalink)  
Old October 10th, 2008, 12:58 AM
Old Pedant Old Pedant is offline
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Bad DB design. You should *NEVER* use a delimited list as the value for a field in a relational database. You should instead create another table and create a many-to-one relationship from that new table to your existing one.

If you stored the values as separate records in this related table, then you could fairly easily create the comma delimited list (e.g., in VBA) for use when communicating with Outlook.

If you think you *must* use the delimited list, then creating an array therefrom is pretty easy:
     catArray = Split( categoriesWithCommas, "," )
and if you have an array, you can go the other way via
     categoriesWithCommas = Join( catArray, "," )
but as to how you manipulate that array into a list box and back out again, can't help you.
Reply With Quote