Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Updating Sharpoint choice field using MS Access and VBA Connection string


  • Please log in to reply
1 reply to this topic

#1 iamdaniely

iamdaniely

  • Members
  • 4 posts
  • OFFLINE
  •  
  • Local time:10:32 PM

Posted 15 May 2015 - 11:15 AM

I'm trying to updated SharPoint list which has a multi value field (Checkbox Choice field). I connect the Sharepoint with MS Access using connection string. 

 

        j = "insert into table([Multi value Column Name].value) values ('A') where ID = 1"
        
        cmd.ActiveConnection = conn
        cmd.CommandText = j
        cmd.Execute
 
What should be the format to update text value "A".. I've tried ;#A;#. It's not working. The SharePoint has values as A,B,C etc.
 


BC AdBot (Login to Remove)

 


#2 iamdaniely

iamdaniely
  • Topic Starter

  • Members
  • 4 posts
  • OFFLINE
  •  
  • Local time:10:32 PM

Posted 21 May 2015 - 03:31 PM

 

I'm trying to updated SharPoint list which has a multi value field (Checkbox Choice field). I connect the Sharepoint with MS Access using connection string. 

 

        j = "insert into table([Multi value Column Name].value) values ('A') where ID = 1"
        
        cmd.ActiveConnection = conn
        cmd.CommandText = j
        cmd.Execute
 
What should be the format to update text value "A".. I've tried ;#A;#. It's not working. The SharePoint has values as A,B,C etc.
 

 

Waiting for some response 






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users