I am unable to change my regional settings here to test this, so I hope I don't come across as too bossy. This shouldn't be TOO bad, theoretically. It looks like Allen Browne is suggesting that we replace our date field with his custom function.
1. Create a new code module in the Modules tab of the database window.
2. Name the module something DIFFERENT from the function name, like "modDateFixer".
3. Paste Allen's function code into the module.
4. Change the SQL portion of the DisplayDailyMeetings subroutine to this:
' Get the appointments for the active date
strSQL = "SELECT tblAppointments.*, tblHour.HourID " & _
"FROM tblAppointments INNER JOIN tblHour " & _
"ON tblAppointments.ApptStartTime = tblHour.Hours " & _
"WHERE tblAppointments.ApptDate = " & SQLDate(dtePubMyDate) & " " & _
"ORDER BY ApptStartTime;"
That's all I think needs to be done. (I've done this on my end, and it still seems to work the same, which is good.)
If it doesn't work, E-Mailing Allen would probably be the safest bet, if I'm off-track here. But I feel pretty confident about this. Please let me know either way, though. If I can incorporate this into an update, and be certain that it works overseas, it'd be very useful!