Jumat, 19 Juli 2013

[MS_AccessPros] Re: DB.execute Update Syntax Help

 

Doyce

Whoever builds the sample and template databases for Microsoft needs a kick in the butt for the non-conventional object and field names. Professional developers always cringe when they see them.

Bill

--- In MS_Access_Professionals@yahoogroups.com, "dnwinberry" <winberry.doyce@...> wrote:
>
> <Laughing Out Loud> Good to know there is hope for me yet!
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> >
> > 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@
> > >
> > > 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 (8)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar