With a
.RecordSource = "select proj_id, proj_name, proj_start, proj_end, proj_aut, proj_note, proj_active, case when now() BETWEEN COALESCE(proj_start, now()) AND COALESCE(proj_end, now()) then 'active' end from projects"
.Refresh
End With
[ADODC] Unknown error [ADO]
0 svar · 226 visningar · startad av Jesper T