B
benJamin
Hello all!
I have a number of machines at work which all have different date/time
locale settings and I can't remember how to get them all to show
Australian dates, like two of the terminals do. What's worse, when
converting the dates to US system for use in Jet queries, the
conversion malfunctions on all logins except the one used to create the
database originally.
I am probably just missing something simple, as I had originally just
inserted the date 'as is' into the query and it had no problems until
testing on a machine which still has US dates. This problem does not
affect all of my forms, as some in the US date system don't affect the
actual data. The query looks like this (actual object names changed):
Me.RecordSource = "SELECT * FROM tableName WHERE Date=#" &
Format(formDate.value, "mm/dd/yyy") & "# AND otherField='" &
formOtherField.value & "'"
where the 'formDate.value' could be any one of a number of possible
data types.
Thanking you all in advance (I've probably found your assistance useful
in the past as well),
benJamin
I have a number of machines at work which all have different date/time
locale settings and I can't remember how to get them all to show
Australian dates, like two of the terminals do. What's worse, when
converting the dates to US system for use in Jet queries, the
conversion malfunctions on all logins except the one used to create the
database originally.
I am probably just missing something simple, as I had originally just
inserted the date 'as is' into the query and it had no problems until
testing on a machine which still has US dates. This problem does not
affect all of my forms, as some in the US date system don't affect the
actual data. The query looks like this (actual object names changed):
Me.RecordSource = "SELECT * FROM tableName WHERE Date=#" &
Format(formDate.value, "mm/dd/yyy") & "# AND otherField='" &
formOtherField.value & "'"
where the 'formDate.value' could be any one of a number of possible
data types.
Thanking you all in advance (I've probably found your assistance useful
in the past as well),
benJamin