RE:Utilización del control calendar
Al hacer click en el calendario
Private Sub BtnGP03FECH_Click()
Dim DateNew As Variant
On Error GoTo errorBtnGP03FECH
Me![GP03FECH].SetFocus
DateNew = GetDate(Me![GP03FECH])
If Me![GP03FECH] <> DateNew Or IsNull(Me![GP03FECH]) Then
TempCambioCargos = True
Me![GP03FECH] = DateNew
End If
Me![GP03FECH].SetFocus
errorBtnGP03FECH:
Exit Sub
End Sub
Definite estas dos funciones
Function GetDate(Optional varDate As Variant) As Variant
Dim PasoValor As Boolean
PasoValor = False
If IsMissing(varDate) Then
varDate = Date
Else
If Not IsDate(varDate) Then
varDate = Date
Else
PasoValor = True
End If
End If
DoCmd.OpenForm FormName:="SUBFORM CALENDARIO", WindowMode:=acDialog, OpenArgs:=varDate
If IsLoaded("SUBFORM CALENDARIO") Then
GetDate = Forms("SUBFORM CALENDARIO").Calendar.Value
DoCmd.Close acForm, "SUBFORM CALENDARIO"
Else
If PasoValor Then
GetDate = varDate
Else
GetDate = Null
End If
End If
End Function
Function IsLoaded(ByVal strformName As String) As Integer
Const conObjStateClosed = 0
Const conDesignView = 0
IsLoaded = False
If SysCmd(acSysCmdGetObjectState, acForm, strformName) <> conObjStateClosed Then
If Forms(strformName).CurrentView <> conDesignView Then
IsLoaded = True
End If
End If
End Function