Top Value

[Guest]

How do I manually tell a query from a form to generate the next (any number)
of records.

 

[John Vinson]

How do I manually tell a query from a form to generate the next (any number)
of records.

You'll have to give us more background and context than that for
anyone to even hazard a guess at what you want.

New records for what? What input does the user provide? Where should
the data for the new records come from?

What are you trying to accomplish in the real world with this? It is
rather rare that it's a good idea to just create a bunch of
(identical??) records without distinctive content; there may be a
better approach.

John W. Vinson[MVP]

 

[Guest]

I am creating a form to mail letters. The form updates a table with the date
the letters are being mailed. The table has a large number of records in it
and I only want to mail a few hundred at a time. How do I control the amount
of records updated with the mail date? I hope that is clear enough for you.

 

[John Vinson]

I am creating a form to mail letters. The form updates a table with the date
the letters are being mailed. The table has a large number of records in it
and I only want to mail a few hundred at a time. How do I control the amount
of records updated with the mail date? I hope that is clear enough for you.

The easiest way is to use an Update query selecting a subset of the
records, using a criterion on some field or fields within each record.
For instance, if you have a sequential ID, you could use a range of
ID's with a criterion like

ID BETWEEN 1001 AND 1100

But there's no simple way to tell Access to update 100 arbitrary
records and stop there.

John W. Vinson[MVP]