Hyperlink Address pointing to SharePoint URL (1 Viewer)

Hello,

I have an Access Form (Access 2016) with a drop down box and a button. The After Update event of the dropdown box has the following code to populate the hyperlink address in the button:

me.cmdbutton.hyperlinkaddress = "http address pointing to our sharepoint site"

When i choose an item from the drop down box, the http address gets pulled in from a Dlookup statement. I have verified that the dlookup statement is returning the correct URL. I have copied and pasted this URL into my browser and it takes me to a sharepoint login page (As is customary) where I click on my email address and it takes me to the URL (in Sharepoint).

However, when I click on the button, I get the following Access error:
Unable to open <Sharepoint URL>. Cannot download the informatino you requested.

This is what I did to troubleshoot the issue:
1. replaced my sharepoint URL with a static URL "http://www.yahoo.com" and this works.
2. also, i as i stated already, I am able to access the Sharepoint URL directly from my browser but not from access.

Does anyone know how to fix this issue? I have googled a lot, searched this forum but don't have any luck yet.

Does you Sharepoint URL have have the http:// prefix. I recall that there's something in Access that doesn't accept bare URLs .

Yes, SharePoint URL has a http:// prefix. thank you, and sorry for my delayed response. I was admitted to the Hospital briefly...all ok now

I am running into the same problem. Has anyone come up with an answer?

Shooting from the hip here, I cannot test it at this moment, but I seem to remember having to place a “file:\\” before the actual URL. I will check tomorrow once I get to work if this doesn’t fix your problem.

I don't use Sharepoint, but found this via Google