Chris Melville questions

• Oracle SQL: Re-use subquery for CASE WHEN without having to repeat subquery
• Passing a user prompt as a date (or even a string) in Oracle SQL
• Why is an ADO connection still creating an "ldb" lock file even when read-only?
• Form object in container frame on worksheet inactive unless Design Mode manually toggled
• VBA: ListBox Change event firing twice

Chris Melville answers