2016 runtime trust network location (1 Viewer)

YouMust

Registered User.
Local time
Yesterday, 21:50
Joined
May 4, 2016
Messages
106
Hi there,

I have a number of tablets with access 2016 runtime installed.
they all pull the same front-end from a network location.
However, I get a pop up regarding trusted locations.

I found some registry edits that will allow this, but I dont have those locations?

[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations]

[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location(n)]

But I have
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Groove
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\common

only.

I found a program that will add trusted locations
https://www.accessribbon.de/en/?Trust_Center:Trusted_Locations
but it gives an error in in a foreign language.

How can i add a trusted location when there is no Access folder in the registry ?
 
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:50
Joined
Oct 29, 2018
Messages
21,322
Hi. Just thinking out loud, are you able to create the missing folder/hive in the registry? Just curious...
 

YouMust

Registered User.
Local time
Yesterday, 21:50
Joined
May 4, 2016
Messages
106
Sorry it was my bad, I'd logged in as me and not the user -_-
Thank you for your help though.

I now dont get warnings when opening access as I added the drive and sub directories to the registry.

However, when I open a hyperlink to a .PDF stored on the same drive, i get a new warning message about opening and asking if I would like to open it.

Is it possible to to remove this message also?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:50
Joined
Oct 29, 2018
Messages
21,322
Sorry it was my bad, I'd logged in as me and not the user -_-
Thank you for your help though.

I now dont get warnings when opening access as I added the drive and sub directories to the registry.

However, when I open a hyperlink to a .PDF stored on the same drive, i get a new warning message about opening and asking if I would like to open it.

Is it possible to to remove this message also?
See if this function helps.
 

YouMust

Registered User.
Local time
Yesterday, 21:50
Joined
May 4, 2016
Messages
106
that looks perfect, thanks @theDBguy once again!
 

YouMust

Registered User.
Local time
Yesterday, 21:50
Joined
May 4, 2016
Messages
106
I'm having troubles adding this to my form, It says it acts just like hyperlink()
but.
The below doesnt seem to work

Code:
Private Sub Command32_Click()
Dim ctl As CommandButton
 
    Set ctl = Me!Command32
    With ctl
        .Visible = True
        .GoHyperlinkAddress = Me.Text30
        .GoHyperlink.Follow
    End With
End Sub
 

YouMust

Registered User.
Local time
Yesterday, 21:50
Joined
May 4, 2016
Messages
106
ok should of been
Code:
Private Sub Command32_Click()
Call GoHyperlink(Me.[Text30])
End Sub

though now i get an error:
Error 5: Cannot locate internet server or proxy server.
 

YouMust

Registered User.
Local time
Yesterday, 21:50
Joined
May 4, 2016
Messages
106
ah the issue was with the hyperlink,

If you recall a previous post I made regarding constructing a file a path and i used TRIM() & to trim the path and then concatenate file name.

I needed to trim the file name and not just the path, both had extra space(?) after the chars.

So =Trim([PATH]) & [FILE] using rich text worked fine, but broke Gohyperlink
adding =Trim([PATH]) & Trim([FILE]) fixed the error message.

thanks DBguy for putting me on to that very handy module.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:50
Joined
Oct 29, 2018
Messages
21,322
ah the issue was with the hyperlink,

If you recall a previous post I made regarding constructing a file a path and i used TRIM() & to trim the path and then concatenate file name.

I needed to trim the file name and not just the path, both had extra space(?) after the chars.

So =Trim([PATH]) & [FILE] using rich text worked fine, but broke Gohyperlink
adding =Trim([PATH]) & Trim([FILE]) fixed the error message.

thanks DBguy for putting me on to that very handy module.

Hi. Glad you got it sorted out. Cheers!
 

YouMust

Registered User.
Local time
Yesterday, 21:50
Joined
May 4, 2016
Messages
106
You know, I still get the pop up asking if i would like to open this file...

though it did fix an issue where clicking with touch screen tried to open it twice resulting in two dialog boxes.

I guess i can live with this! I think its as close as I can get.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:50
Joined
Oct 29, 2018
Messages
21,322
I guess we can't win them all.
 

YouMust

Registered User.
Local time
Yesterday, 21:50
Joined
May 4, 2016
Messages
106
unfortunate it doesn't, I can't open the runtime as admin.
secondly there isnt a check box to tick

Thanks for your input though!
 

Users who are viewing this thread

Top Bottom