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@comcast.net>
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