asked on

Providing access to a onenote page in access 2016

I am using microsoft 365 Enterprise E3 and i have an existing database that I would like to add the ability to link records to one note pages

I tried creating a hyperlink field in a table and added it to an existing form.

Then I opened one note and selected the page I want to link.

Then I right clicked the page and selected "Copy Link to Page"

Then I pasted the link into the field on the form, but when I click on the hyperlink I get an error message "Unable to open form" (see attached file)

Searched the web for solutions with no luck

PatHartman

If you paste the link into Word does it work?

I don't ever use the Hyperlink data type since it isn't supported in SQL Server or other RDBMS'. I use a regular text field. I set the form propery to DisplayAsHyperlink - Always so the link looks like a hyperlink. Then in either the click event (if you can't update the field on this form) or in the double-click event (if you can), I use the Application.FollowYperlink method to open the link. As long as the target is correctly registered with windows, the hyperlink works. If the app isn't registered, you need to use some other method that specificly opens the app and passes in the link to follow.

I also don't use OneNote (even though I have it) so I can't test this for you.

rogerdjr

ASKER

Thanks for the suggestion - works with a normal webpage link but can't access the onenote link

https://eaglepromanagement-my.sharepoint.com/personal/roger_eaglepromanagement_com/_layouts/OneNote.aspx?id=%2Fpersonal%2Froger_eaglepromanagement_com%2FDocuments%2FNotebooks%2F06-13-2017%20EPM%20Active%20Projects%20Notebook&wd=target%2817013%20MRWPCA%20Pump%20Station%2013.one%7C642C26E9-360F-4973-920A-0C61E45B3E97%2F2017-06-09%20Site%20Meeting%20%28Electrical%20Coordination%5C%29%20%2817013%7CB47B5DE7-2FCC-474B-B463-F9F14AE13C80%2F%29
onenote:https://eaglepromanagement-my.sharepoint.com/personal/roger_eaglepromanagement_com/Documents/Notebooks/06-13-2017%20EPM%20Active%20Projects%20Notebook/17013%20MRWPCA%20Pump%20Station%2013.one#2017-06-09%20Site%20Meeting%20(Electrical%20Coordination)%20(17013%20CP297)§ion-id={642C26E9-360F-4973-920A-0C61E45B3E97}&page-id={B47B5DE7-2FCC-474B-B463-F9F14AE13C80}&end

When I paste the link into a word document - it appears like 2017-06-09 Site Meeting (Electrical Coordination) (17013 CP297) (Web view) and works

link also works when i paste into my browser
I'm baffled

ASKER CERTIFIED SOLUTION

rogerdjr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rogerdjr

ASKER

Found answer with online search

PatHartman

Thanks for sharing the answer.