[AccessD] Hyperlink Problem

[Ryan W]

Rocky,

Using FireFox (my default browser) developer console debugger, the first
response back from your URL is a 404 and then a series of back and forth
redirects me to an 'Arens Group' login page.

I would guess that's why it's throwing your Error 6 message, although when
I use Office 365's version of Access I get the same result as a copy
paste... (an initial 404 then a redirect to 'Arens Group')



On Wed, Dec 27, 2023 at 8:31 PM Ryan W <wrwehler at gmail.com> wrote:

> So the followhyperlink still doesn't like http(s)://www.notion.com ?
>
> My only other thoughts:
> 1) Add notion.com or notion.so to your trusted internet zones?
> 2) Use a link shortener to try and bypass whatever silliness is going on?
>
>
>
>
> On Wed, Dec 27, 2023 at 8:27 PM Rocky Smolin <rockysmolin2 at gmail.com>
> wrote:
>
>> Ryan:
>>
>> You're right. If I change the .so to .com, it redirects.  Works perfectly
>> when I paste it into a browser - just like the .so. But still 404 in the
>> FollowHyperlink statement. :o(
>>
>> Tks
>>
>> Rocky
>>
>>
>> On Wed, Dec 27, 2023 at 4:59 PM Ryan W <wrwehler at gmail.com> wrote:
>>
>> > If that works, notion.com does successfully redirect to notion.so,
>> adding
>> > a
>> > file/folder path also goes along with it.
>> >
>> >
>> >
>> > On Wed, Dec 27, 2023 at 6:57 PM Ryan W <wrwehler at gmail.com> wrote:
>> >
>> > > Maybe it doesn't like the .so TLD?
>> > >
>> > > try changing it to .com just to see if you get any further with it?
>> > >
>> > >
>> > > On Wed, Dec 27, 2023 at 6:52 PM Rocky Smolin <rockysmolin2 at gmail.com>
>> > > wrote:
>> > >
>> > >> Dear List:
>> > >>
>> > >> My client is using an online product called Notion and has links to
>> his
>> > >> Notion Folders on his Notion site which he wants to embed in the app
>> I
>> > >> wrote for him.
>> > >>
>> > >> When I copy one of the links and paste it into the browser it works.
>> It
>> > >> did
>> > >> not work initially but he gave me permissions to the folders and so
>> then
>> > >> it
>> > >> worked.
>> > >>
>> > >> Sample link looks like this:
>> > >>
>> > >> https://www.notion.so/1-Make-Folder-ec50ff0941a243f0ba97aac5ffc37e26
>> > >>
>> > >> When I click the Test Link button I get err.number = 6 - Invalid Link
>> > >>
>> > >> He gets the same thing at his desk-works in the browser but not from
>> the
>> > >> CBF.
>> > >>
>> > >> Here's the code:
>> > >>
>> > >> Private Sub cmdTestLink_Click()
>> > >>
>> > >> On Error GoTo LinkError:
>> > >>
>> > >>     Application.FollowHyperlink
>> Address:=Me.fldMaintenanceStepNotionLink
>> > >>     Exit Sub
>> > >>
>> > >> LinkError:
>> > >>     If Err.Number = 490 Or Err.Number = 6 Then
>> > >>         MsgBox "Invalid Link", vbExclamation
>> > >>         Exit Sub
>> > >>     Else
>> > >>         MsgBox "Run Time Error: " & Err.Number & "-" &
>> Err.Description &
>> > >> "." & vbCrLf & vbCrLf _
>> > >>             & "Report to Beach Access Software.", vbExclamation
>> > >>     End If
>> > >>
>> > >> End Sub
>> > >>
>> > >> If I test an address like Google or Wiki or Hooters, it works as long
>> > as I
>> > >> have the HTTP prefix.
>> > >>
>> > >> Any ideas why this is failing? Something to do with permissions.
>> maybe?
>> > >>
>> > >> MTIA
>> > >>
>> > >> Rocky
>> > >> --
>> > >> AccessD mailing list
>> > >> AccessD at databaseadvisors.com
>> > >> https://databaseadvisors.com/mailman/listinfo/accessd
>> > >> Website: http://www.databaseadvisors.com
>> > >>
>> > >
>> > --
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > https://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>