UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Link A Specific View To Sharepoint, SharePoint 2013    
 
   
snsd
post Jun 22 2020, 11:17 AM
Post#1



Posts: 498
Joined: 23-November 04
From: Markham, Ontario, Canada


Hi,

I'm a total hacker when it comes to Access. smile.gif

I know how to use the SP GUI to link a SP list to Access. However, I would like to link a specific view of that list in SP and that cannot be done via the GUI. It can only be done via VBA.

I found this on the Microsoft support site: https://docs.microsoft.com/en-us/office/vba...rsharepointlist

I figured out how to get the actual GUID (which I anonymized below) and did the necessary substitutions of characters. Here's my attempt at creating the linked table:

DoCmd.TransferSharePointList(acLinkSharePointList, "https://MySharePointListURL", "{B0A842F8-DF0D-4387-9CEF-1F1229ADB1E7}View={79B65ddF-607F-4063-8EB8-E03F8B201F6B}Source=https%253A%252F%253Fspcollab%252Efg%252Erbc%252Ecom%252Fteam%252FH30%255FACE2%252FCE%252FLists%252F2FA%252FMS%2520Access%252Easpx", , SharePointTableName, True)

When I try to compile the code, I get an "Expected: = " error message though I suspect there might be other problems.

Any assistance would be incredibly appreciated!

Thanks,

Dave
Go to the top of the page
 
theDBguy
post Jun 22 2020, 12:48 PM
Post#2


UA Moderator
Posts: 78,487
Joined: 19-June 07
From: SunnySandyEggo


Hi Dave. Maybe you could try it this way.

CODE
DoCmd.TransferSharePointList acLinkSharePointList, "https://MySharePointListURL", "{B0A842F8-DF0D-4387-9CEF-1F1229ADB1E7}","{79B65ddF-607F-4063-8EB8-E03F8B201F6B}, "SharePointTableName", True)

Hope that helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
snsd
post Jun 22 2020, 04:27 PM
Post#3



Posts: 498
Joined: 23-November 04
From: Markham, Ontario, Canada


Thanks for the prompt response! Sincerely appreciated. Syntax is good now but I'm struggling to connect with the SharePoint list. I don't think it has anything to do with Access. I'll fiddle a bit more and see how I make out.
Go to the top of the page
 
theDBguy
post Jun 22 2020, 04:50 PM
Post#4


UA Moderator
Posts: 78,487
Joined: 19-June 07
From: SunnySandyEggo


Okay. Good luck. Please let us know how it goes.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
snsd
post Jun 24 2020, 01:44 PM
Post#5



Posts: 498
Joined: 23-November 04
From: Markham, Ontario, Canada


Still struggling with this. iconfused.gif
CODE
DoCmd.TransferSharePointList acLinkSharePointList, "https://spcollab.fg.xxx.com/team/H30_ACE2/CE/", "{B0A842F8-DF0D-4387-9CEF-1F1229ADB1E7}", "{79B656EF-607F-4063-8EB8-E03F8B201F6B}, 2FA, True)"
Getting a Run-time error '3919'. (See attached.)

I think part of the issue is the table name "2FA". If I start with a blank Access database, create a form with a button that executes the above do command, I get the error message. I suspect it's because the table "2FA" doesn't exist in my Access DB yet. If I link the overall SharePoint list first (which shows only 100 records), and then run the DoCmd, I don't get an error message but still only 100 records.

Just not sure what's going on. Any further help appreciated.


Attached File(s)
Attached File  access_error.png ( 7.39K )Number of downloads: 0
 
Go to the top of the page
 
theDBguy
post Jun 24 2020, 02:20 PM
Post#6


UA Moderator
Posts: 78,487
Joined: 19-June 07
From: SunnySandyEggo


Hi. Only way I can see going further in helping you is if we could see what's actually happening. Are you available for a web conference?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    12th July 2020 - 09:32 PM