Create Several Records w/Similar Data

[lisa.king]

I am new to vba, access, sql

From a form, how can you create several records with the same data

except serial number at the same time? I would like to add in a
starting serial number and ending serial number, then have
access create the records from the starting number through ending
number. Below is a sample of a record.

datein product mfg model serial# name dateout
1/1/07 car ford focus 50001 sedan 1/15/07

Any help would be appreciated

 

[Jeff Boyce]

Access is a relational database. There's rarely a need to store redundant
data (e.g., car, ford, focus, sedan).

Instead, have one table that holds your "things" (car, ford, focus, sedan)
with an ID to uniquely identify the row.

Then put only the ID in your table that associates a serial# with a product.

Or have I misunderstood your description?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[lisa.king]

That will work. Then how would you get it to increase the serial# by 10
or 50 at a time?
Thank you.

 

[Jeff Boyce]

That brings up a second question. It is also rare to need to add a series
of records in advance (?your series of serial numbers).

Can you describe a bit more what you hope having a series of serial numbers
will help you accomplish (less about the "how", more about the "what")?

Regards

Jeff Boyce
Microsoft Office/Access MVP