Top Value

  • Thread starter Thread starter Guest
  • Start date Start date
How do I manually tell a query from a form to generate the next (any number)
of records.
Click to expand...

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]
 
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.
 
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.
Click to expand...

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]
 
Back
Top