Re: looping through recordset

Tech-Archive recommends: Speed Up your PC by fixing your registry

Mark

"how" depends on "what", and I don't understand what (data, or data/table
structure) you are working with.

I asked whether you considered using a query to see if you had considered
using a query ... and I don't know if it is appropriate because I don't know
enough about your situation yet.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Mark" <cmd@xxxxxxxxxxxx> wrote in message
news:ekl54q%23wJHA.1240@xxxxxxxxxxxxxxxxxxxxxxx
Jeff,
Not sure I understand the question. Are you suggesting an expression in a
query? Maybe I've used the wrong language -- "recordset", or just didn't
explain very well what I'm trying to do.
Mark

"Jeff Boyce" <nonsense@xxxxxxxxxxxx> wrote in message
news:%230NkML5wJHA.4104@xxxxxxxxxxxxxxxxxxxxxxx
Mark

"looping through a recordset" is a very compute-intensive way to get
things
done... sometimes the only way, but then again ...

Have you looked into using a query to process the recordset as a set?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Mark" <cmd@xxxxxxxxxxxx> wrote in message
news:%234dMm04wJHA.5836@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,

What would be an efficient way within a function to loop through a
recordset
of distinct text values (record 1 = text1, record 2 = text2, etc.) with
the
result displayed as follows:

If only one record:
fncMyFunction = "text1." (that's text1 followed by a period)

If multiple records and rst.recordcount = n:
fncMyFunction = "text1, text2, ... , and text-n." (commas separate each
record except for the last which is preceded with the word "and" and is
followed by a period).

[the function produces a string which can be incorporated elsewhere]

Thanks for any advice.
Mark








.

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)