Re: How works MaxRecords attribut ?

From: Val Mazur (group51a_at_hotmail.com)
Date: 02/26/05


Date: Fri, 25 Feb 2005 21:08:46 -0500

Hi,

It works similar to how TOP N clause works in a SQL statements. Basically it
set a limit on a number of the records returned to the recordset from the
query. For example if your query returns 100 rows, but MaxRecords property
of the recordset is set to 10, then recordset will get only first 10
records, not all 100 of them

-- 
Val Mazur
Microsoft MVP
http://xport.mvps.org
"Olivier" <olive@nospam.fr> wrote in message 
news:cvk5uc$fkn$1@apollon.grec.isp.9tel.net...
> Hi,
>
> How works the MaxRecords attribut for a RecordSet ?
>
> Thanks,
>
>
> 


Relevant Pages

  • Re: Help with Microsoft help on linking Access to Outlook
    ... Tools - references - tick Microsoft Outlook object library. ... in the criteria cell in the graphical query builder. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... and have the query point to the combo box to get its value. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ...
    (microsoft.public.access.formscoding)