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]
>
Tidak ada komentar:
Posting Komentar