[AccessD] Dynamic SQL statement

[Gustav Brock]

Hi Susan

That's what I have written/commented numerous times through the years: Often clumsy SQL is (mis)used where elegant DAO is faster and cleaner and offers a much better error handling.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Susan Harkins
Sendt: 8. december 2015 17:04
Til: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Dynamic SQL statement

Thank you Bob -- I am excited about this change. I appreciate your help. 

Susan H. 

If a control is empty, then it's null. Null is a valid value to assign

Oh my... now that is easier isn't it -- and if a control's empty, does it throw an error? I'm afraid my mind always turns to SQL and maybe that's not a good thing. :)

I have the day off tomorrow -- it's inauguration day here in Kentucky for our newest Governor. I'll try it out on Wednesday. Thank you.

Susan H.