[SOLVED] 2016 runtime trust network location

[YouMust]

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\A ccess\Security\Trusted Locations]

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

But I have
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\G roove
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\c ommon

only.

I found a program that will add trusted locations
https://www.accessribbon.de/en/?Trus...sted_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 ?

[theDBguy]

Hi. Just thinking out loud, are you able to create the missing folder/hive in the registry? Just curious...

[YouMust]

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]

Originally Posted by YouMust

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]

that looks perfect, thanks @theDBguy once again!

[theDBguy]

Originally Posted by YouMust

that looks perfect, thanks @theDBguy once again!

You're welcome and good luck!

[YouMust]

I'm having troubles adding this to my form, It says it acts just like hyperlink()
but.
The below doesnt seem to work

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]

ok should of been

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]

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]

Originally Posted by YouMust

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]

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 guess we can't win them all.

[Gasman]

Originally Posted by YouMust

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.

Does this help?

https://smallbusiness.chron.com/fix-...ile-60489.html

[YouMust]

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!

[Gasman]

Originally Posted by YouMust

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!

At your own risk?

http://www.door2windows.com/disable-...rning-message/