Kamis, 18 Juli 2013

RE: [MS_AccessPros] DB.execute Update Syntax Help

 

Please don't look at the table and field names I used while coding 12 years ago ;-)

Duane Hookom MVP
MS Access

----------------------------------------
> From: winberry.doyce@roadsysinc.com
>
> Thanks Duane. I usually do that but I'm trying to sharpen my skills writing code. And that is a good explanation. I wish I had known more about naming things 12 years ago when I created this table. Thanks again for your help and good advice.
>
> Doyce
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>>
>> Doyce,
>>
>> I would recommend creating an update query and then viewing the SQL so you can copy and paste it into your code.
>>
>> Your table name is basically the expression TearDown minus Primary. If you need to use symbols and/or spaces in table/field names, you will need to use []s.
>>
>> I typically use 0 and -1 in place of false and true.
>>
>> Duane Hookom MVP
>> MS Access

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar