Hendra -
You're welcome. I don't mean to discourage you from learning another language, but if I were to suggest one, I'd say C#. I started to learn it last October and got through the first 3 chapters of the boook before I was bombarded with more Access projects.
Not that I'm complaining, but when I do find time to go back to learning I'll have to start all over.
Bill
--- In MS_Access_Professionals@yahoogroups.com, Agestha Hendra <agesthahendra@...> wrote:
>
> Wow...i just wondering why certain people don't trust Access...
> I was thinking to looking for more powerfull (read : faster) desktop tools than access, many friends adviced me to learn VB...
> but now,,,i think it's not important,,,,thanx for the explanation..
> Best Regards
> Hendra
>
>
> ________________________________
> Dari: Bill Mosca <wrmosca@...>
> Kepada: MS_Access_Professionals@yahoogroups.com
> Dikirim: Rabu, 28 Maret 2012 21:13
> Judul: Re: Bls: Bls: [MS_AccessPros] Condition to use recordset methods
>
>
> Â
> Hendra
>
> I would agree with you completely. Having compiled queries, bound forms and VBA compiler with the ability to tap the engine directly and the like make Access a much more RAD environment for database applications.
>
> You can do everything in VB but you lose the intertwined features of Access.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, Agestha Hendra <agesthahendra@> wrote:
> >
> > Thanx Bil...
> >
> > So can we say that Access with Queries method is better than Visual Basic (not VBA)...?
> > As far as i know Access and VB has the same DB Engine, JET...but VB doesn't have query feature...
> > In VB all data processing has to be written in module, it's the same way in Access with VBA...
> > but because Access has better way, thoose data processing are better to be done in queries...
> >
> > Best Regards
> > Hendra
> >
> >
> >
> > ________________________________
> > Dari: Bill Mosca <wrmosca@>
> > Kepada: MS_Access_Professionals@yahoogroups.com
> > Dikirim: Rabu, 28 Maret 2012 4:26
> > Judul: Re: Bls: [MS_AccessPros] Condition to use recordset methods
> >
> >
> > ÂÂ
> > Hendra
> >
> > Queries are always faster than looping, but sometimes there is a need to loop. My standard is do it in a query if possible. Loop as a last resort.
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com
> > Microsoft Office Access MVP
> > https://mvp.support.microsoft.com/profile/Bill.Mosca
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Agestha Hendra <agesthahendra@> wrote:
> > >
> > > Thanx Crystal...
> > >
> > > Aah,,,yup,,,i forget about looping ... query can't do that, but what about others data processing
> > > except looping, is query always faster than recordset method..?
> > >
> > > Regards
> > > Hendra
> > > (Have a nice day to.. :)
> > >
> > >
> > >
> > > ________________________________
> > > Dari: Crystal <strive4peace2008@>
> > > Kepada: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
> > > Dikirim: Rabu, 28 Maret 2012 2:58
> > > Judul: Re: [MS_AccessPros] Condition to use recordset methods
> > >
> > >
> > > ÂÂÂ
> > > Hi Hendra,
> > >
> > > sometimes you must loop through a recordset and do calculations one record at a time. For instance, if you want to combine information from more than one record. This would generally be for displaying information, not storing it
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > >  *
> > >   (: have an awesome day :)
> > >  *
> > >
> > > ________________________________
> > > From: "agesthahendra@" <agesthahendra@>
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Sent: Tuesday, March 27, 2012 1:54 PM
> > > Subject: [MS_AccessPros] Condition to use recordset methods
> > >
> > > Hi All...
> > >
> > > There are several ways in Access to manipulate or just retrieving data,...every article that i've read explain that Query is faster
> > > than Recordset method in VBA...but is there a condition that we better to use recordset method in VBA instead of query..?
> > >
> > > Regards
> > > Hendra
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar