How to create a Global variable that is a file path to a Sharepoint Folder

Question

I have an Access database in a SharePoint folder. I need for any users that can open the database to be able to read and write to other folders in Sharepoint.

I need to be able to use Export Specifications to write to the Sharepoint Folder

I need to be able to read in files from Sharepoint folder

I have tried to assign the hyperlink value to a Global variable

I have tried using FollowHyperlink to assign a value to a Global variable

Answer 1

To create a global variable that holds a file path to a SharePoint folder in Microsoft Access, you can follow these steps:

1. Define the Global Variable: At the top of your module, declare a global variable. For example:

      Global SharePointPath As String
   

2. Assign the SharePoint Folder Path: You can set this variable to the path of your SharePoint folder. You can do this in a procedure or function:

      Sub SetSharePointPath()
          SharePointPath = "https://yoursharepointsite.com/path/to/folder"
      End Sub
   

3. Using the Global Variable: Now, you can use SharePointPath in your export specifications or when reading files from the SharePoint folder.
4. Export Specifications: When you want to write to the SharePoint folder, you can reference SharePointPath in your export specifications.
5. Reading Files: Similarly, when reading files, you can use the global variable to reference the SharePoint folder path.

Make sure that users have the necessary permissions to read and write to the SharePoint folder.

---

References:

• Set Global Variables for a Form
• SetVariable Macro Action (Access custom web app)

Answer 2

Hi @Gregg Taylor (WH),

Since your issue is about VBA, and our forum focus on SharePoint C#. I will recommend you to raise a new ticket in Microsoft Community Hub. There is a section dedicated to discussing VBA. You might get some more professional advice there. Thanks for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.