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