Create Several Records w/Similar Data

  • Thread starter Thread starter lisa.king
  • Start date Start date
L

lisa.king

I am new to vba, access, sql
From a form, how can you create several records with the same data
Click to expand...
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
 
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
 
That will work. Then how would you get it to increase the serial# by 10
or 50 at a time?
Thank you.
 
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
 
Back
Top