Re : probleme de nom ambigue dans mon appli
voila le code de la page d'acceuil
si vous trouvez quelquechose
Option Explicit
Private Declare Function FindWindowA Lib "user32" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function GetWindowLongA Lib "user32" (ByVal hwnd As Long, ByVal nIndex As Long) As Long
Private Declare Function SetWindowLongA Lib "user32" (ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function GetWindowLong Lib "user32" Alias _
"GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long) As Long
Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" _
(ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Declare Function DrawMenuBar Lib "user32" (ByVal hwnd As Long) As Long
Public MusicWAV
Private Sub CommandButtonRecherche_Click()
USFSEARCH1.Show
End Sub
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then Cancel = True
End Sub
Private Sub CMBRETARD_Click()
USFRETARDOPCA.Show
End Sub
Private Sub Sortie_Click()
USFSAVE_BD.Show
On Error Resume Next
End Sub
Private Sub BoutNouvelleFiche_Click()
USFCLIENTNEW.Show
End Sub
Private Sub CommandButtonAjoutNouveauCableur_Click()
USFCLIENTINFO.Show
End Sub
Private Sub CommandButtonAccesCode_Click()
On Error Resume Next
'USFPASSWORD.Show
Application.Quit
End Sub
Private Sub UserForm_Initialize()
'USFACCEUIL.
Label4.Caption = " Votre Base de données est enregistrée dans : " & ActiveWorkbook.FullName
Dim hwnd As Long, exLong As Long, zFactor As Integer, Style As Long
Sheets("table_client").Activate
hwnd = FindWindowA(vbNullString, Me.Caption)
exLong = GetWindowLongA(hwnd, -16)
If exLong And &H880000 Then SetWindowLongA hwnd, -16, exLong And &HFF77FFFF
zFactor = 100 * CInt(Application.Width / Me.Width)
Me.Width = Application.Width
Me.Height = Application.Height
Style = GetWindowLong(hwnd, -16) And Not &HC00000
SetWindowLong hwnd, -16, Style
DrawMenuBar hwnd
On Error Resume Next
'Affichage sur le UserForm
'USFACCEUIL.
LblDateHeure.Caption = "Nous sommes le " & Format(Date, "Long Date") '_
'& vbCrLf & vbCrLf & "Il est " & Format(Now, "Long Time")
'USFACCEUIL.
LblDateHeure.Caption = UCase(Left(USFACCEUIL.LblDateHeure.Caption, 1)) _
& Right(USFACCEUIL.LblDateHeure.Caption, Len(USFACCEUIL.LblDateHeure.Caption) - 1)
End Sub