Sequential Serial Number records

[Koolaid]

I appreciate the help in advance. I am not a seasoned MS Access person so this may be easier than I think to create...Here we go. In my table, which I have a form created for it, I put in a lot of information that is the same for many records. The only differing information would be the serial numbers per record. The pain in the butt thing is that I have to currently type each record using one serial number per record in the form. What if I wanted to allow for putting serial numbers 0001 through 0010 in one shot (or one record, since all the other fields are the same anyway) which then creates the ten records vice one? I don't want to have to keep doing one record per serial number is my point without needing to. If there are sequential serial numbers that I have...which happens often, I would like to type in the form once and just have that serial box be allowed for 0001 - 0010 or two boxes one for the beginning serial and the next box for the ending serial. I hope this wasn't too confusing lol Help me if you can please. Thank you! Koolaid

[RuralGuy]

I think this link should be helpful: http://www.baldyweb.com/CustomAutonumber.htm

[ranman256]

use this code in the button click once you fill in the start and end textboxes.

Public Sub btnMakeSerials_click()
Dim iStart As Long, iEnd As Long, i As Long
Dim sSql As String

iStart = txtBoxStart
iEnd = txtBoxEnd

DoCmd.SetWarnings = False
For i = iStart To iEnd
   sSql = "INSERT INTO tTargetTbl ( SerialNo) values (i) "
   DoCmd.RunSQL sSql
Next
docmd.opentable "tTargetTbl"
msgbox "done"
End Sub

[Koolaid]

Thank you guys I will check this stuff out. Hopefully I can figure it out lol Koolaid