Hi there,
The problem I have is that somewhere in my database its is getting confused between UK and American date formats. I use a lot of autofill dialog data entry forms using - Date(). Basically I have one table that holds all the information on a dialog form that pops up by clicking on a record in a subform. I’ve checked the date formats in the table and the query that the subform form run to and they are all set to Medium Date in the format or properties. I use the code below to display the dialog data entry form which runs direct from the table:
Code for display dialog form:
Private Sub CustCode_Click()
If Not Me.NewRecord Then
DoCmd.OpenForm "frm_dialog_IndividualContact", _
, _
, _
"[CustCode]='" & Me.[CustCode] & _
"' And [DelSeqCode]='" & Me.[DelSeqCode] & _
"' And [ContactDate]=#" & Me.[ContactDate] & _
"# And [ContactTime]=#" & Me.[ContactTime] & "#", _
, _
acDialog
Else
DoCmd.OpenForm "frm_dialog_IndividualContact", _
, _
, _
, _
acFormAdd, _
acDialog
End If
End Sub
Basically when a contact is stored on a date prior to the 13th of the month (with the exception of the same value for both – 01/01/2009, 02/02/2009….) if I click on the record it brings up a completely blank dialog form (not even showing fields). All other dates work fine and bring up the correct record.
Please help, as I have tried everything I can think of on this and I can’t get it to work.
I am working in Access 2003. Let me know if you require anymore information. Thank you in advance for your help.
Thanks Jodie
The problem I have is that somewhere in my database its is getting confused between UK and American date formats. I use a lot of autofill dialog data entry forms using - Date(). Basically I have one table that holds all the information on a dialog form that pops up by clicking on a record in a subform. I’ve checked the date formats in the table and the query that the subform form run to and they are all set to Medium Date in the format or properties. I use the code below to display the dialog data entry form which runs direct from the table:
Code for display dialog form:
Private Sub CustCode_Click()
If Not Me.NewRecord Then
DoCmd.OpenForm "frm_dialog_IndividualContact", _
, _
, _
"[CustCode]='" & Me.[CustCode] & _
"' And [DelSeqCode]='" & Me.[DelSeqCode] & _
"' And [ContactDate]=#" & Me.[ContactDate] & _
"# And [ContactTime]=#" & Me.[ContactTime] & "#", _
, _
acDialog
Else
DoCmd.OpenForm "frm_dialog_IndividualContact", _
, _
, _
, _
acFormAdd, _
acDialog
End If
End Sub
Basically when a contact is stored on a date prior to the 13th of the month (with the exception of the same value for both – 01/01/2009, 02/02/2009….) if I click on the record it brings up a completely blank dialog form (not even showing fields). All other dates work fine and bring up the correct record.
Please help, as I have tried everything I can think of on this and I can’t get it to work.
I am working in Access 2003. Let me know if you require anymore information. Thank you in advance for your help.
Thanks Jodie