Hello Richard. Thank you for your very instructive lessons. I have a problem which I would very much appreciate if you could help with. In the date time seminar database, when I press the button "remind me in 3 minutes" I get the following error: Run-time error '3075' Syntax error in date in query expression '#06/05/21 7:36:19 pm' Likewise in another query I get the similar error message : Syntax error in date in query expression 'Closed=FALSE AND ReminderDateTime<="06/05/21 7:37:20 mm'
Also, when I press the debug button, the following formula is highlighted in yellow : X = Nz(DCount("*", "ReminderT", "Closed=FALSE AND ReminderDateTime<=#" & Now() & "#"), 0) Thank you very much in advance.
I can see a few errors. If you copied and pasted this directly, you're missing a # after '#06/05/21 7:36:19 pm'
What is mm?
Despina KarayanniOP
@Reply 5 years ago
Dear Richard and Adam,
The mm is the Greek abbreviation for pm (ACCESS presents this specific pm using the Greek language abbreviation to my computer).
I got suspicious form your question about this mm, so I went to the settings and changed hour configuration on a 24basis (military). Now everything works fine. Thanks a lot for the hint and the help.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
