Programatically Link to SharePoint List Table (1 Viewer)

crocket

New member
Local time
Yesterday, 21:51
Joined
Jul 27, 2020
Messages
1
Hello,

It's been over 9 years since I've programmed with Access, so I'm glad to see that this forum is still around and going strong.

Can someone point me in the right direction to help me get started with this? What I'd like to do is create a generic Access form that allows the user to paste the URL of their SharePoint list in a text box.

Example: MySharePointSite.com/sites/projects/MyProject/MySharepointList.aspx

The code then links to the table that houses the data for the SharePoint list. Once the table connections has been made, the user will select the fields for the data they want to export to a file. They will not be creating/modifying tables or adding/editing data.

First of all, is this even possible? I've had to manually link to the SharePoint list.

Thanks!
 

Isaac

Lifelong Learner
Local time
Yesterday, 19:51
Joined
Mar 14, 2017
Messages
4,460
I've used code like this recently to link to a sharepoint list:

Code:
dim strSPSite as String, strSPListName as string

strSPListName = "IsaacTestList"
strSPSite = "https://something.something.something.com/sites/sitename"
DoCmd.TransferSharePointList 1, strSPSite, strSPListName, , "Sharepoint"
 

Users who are viewing this thread

Top Bottom