Search results
-
R
Not able to set date field to Null value
Me.DA_Start = Null The custom message is throwed and then: Runtime error 2147352567 (80020009) on the " Me.DA_Start = Null " line -
R
Not able to set date field to Null value
It doesn't ... I did the change and nothing comes out of it -
R
Not able to set date field to Null value
Nothing ... And I really need that default value, anyway. But I give it a try... -
R
Not able to set date field to Null value
Yes. Default value set in field properties to #01-01-2000# Format set in field properties to dd-mm-yyyy input mask set on form Onload event for all date fields: Me.DA_Start.InputMask = "00-00-0000;0;*" Code above set on form OnError event OnEnter field event: Me.Form.Refresh set... -
R
Not able to set date field to Null value
Doesn't work... I tried Me.DA_Start = Null Me.Da_Start = "" Me.Da_Start.Value = Me.Da_Start.DefaultValue (it has the default set to #01-01-2000# Me.Da_Start.Value = #01-01-2000# It seemns that i cannot set anything trough VBA. Only from keyboard... :banghead: Whole story now The form... -
R
Not able to set date field to Null value
I have a form that runs a search query. I have an error trap set on a date field. If (DataErr = 2113) Then Select Case Screen.ActiveControl.Name Case "DA_Start" MsgBox "invalid date", vbExclamation Me.DA_Start. = Null End Select Response = acDataErrContinue End If End Sub This will pop up...