1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| Public Sub ApprouveEmplacement()
On Error GoTo err:
Const KEY As String = "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location99\"
Dim Emplacement As String
Emplacement = ExtractFolder(CurrentDb.Name) & "\"
WriteIntoReg KEY, "AllowSubFolders", 1, "REG_DWORD" '0 = n'approuve pas les sous-dossiers 1 = approuve
WriteIntoReg KEY, "Date", Now, "REG_SZ"
WriteIntoReg KEY, "Description", "NomAchoisir", "REG_SZ"
WriteIntoReg KEY, "Path", Emplacement, "REG_SZ"
MsgBox "Emplacement approuvé"
Exit Sub
err:
MsgBox "Emplacement non approuvé"
End Sub
Private Function WriteIntoReg(ByVal KEY As String, ByVal Value As String, ByVal Data, ByVal DataType As String) As Boolean
Dim WshShell As Object
On Error GoTo WriteIntoReg_Error
Set WshShell = CreateObject("WScript.Shell")
WshShell.RegWrite KEY & Value, Data, DataType
WriteIntoReg = True
On Error GoTo 0
WriteIntoReg_Exit:
Set WshShell = Nothing
Exit Function
WriteIntoReg_Error:
WriteIntoReg = False
Resume WriteIntoReg_Exit
End Function |
Partager