[AccessD] Dynamic SQL statement

[Bob Walsh]

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

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, December 07, 2015 2:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Dynamic SQL statement

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.

On Mon, Dec 7, 2015 at 5:11 PM, Bob Walsh <BWalsh at acumentra.org> wrote:

> How about...
>
>         Set rs1 = CurrentDb.OpenRecordset("Exam", dbOpenDynaset,
> dbAppendOnly)
>         rs1.AddNew
>         rs1!IndividualIDFK = ctl.Column(2, varItem)
>         rs1!ExamDescriptionIDFK = strExamType
>         rs1!ExamDate = strExamDate
>         rs1!Results = strObservation
>         rs1!NextExamDue = strFollowupDate
>         rs1.Update
>         rs1.Bookmark = rs1.LastModified
>
>         rs1.Close
>         Set rs1 = Nothing
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
IMPORTANT NOTE: The information contained in this message may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately and delete this message from your computer. Acumentra Health.