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!
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!