creating multiple records

[Guest]

Currently we have an inventory system that allows us to scan all new incoming
material to inventory by scanning a barcode repeatedly to create multiple new
records. I know this is not an ideal table design. Any suggestions on how to
have a single record with a running count would be great. But in the short
term I would like to be able to scan an item and enter “5†(number of new
inventory) and have 5 new records created.
Table
Field1 Field2
item (barcode) Delivery Date

Datasheet currently
Field1
Field1 (Repeatedly to create new records and count)

Would like to
Field1 Number of new Items
1234 5

 

[Al Campagna]

Robert,
There may be other suggestions on this, but...
Using the system you have already, couldn't you just scan to
a "temp" table, and when all scanning is complete, run an Totals
append query to your "real" inventory table?
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

we are starting to get large qty of items 200+ it is no longer reasonabe to
scan a barcode 200-500 times. lately we have been scanning into an excell
spreadsheet and coping to 200 records but it's one more step in the process.

 

[John W. Vinson]

we are starting to get large qty of items 200+ it is no longer reasonabe to
scan a barcode 200-500 times. lately we have been scanning into an excell
spreadsheet and coping to 200 records but it's one more step in the process.

You can use an auxiliary table, Num, with one field N; fill it (once
only, using Excell fill-down say) with numbers from 0 through 10000 or
so.

You can then have a textbox txtHowMany on your form, and run an Append
query using a criterion of

< [Forms]![yourform]![txtHowMany]

on N to create that many duplicates. This query can either have a
single record that you've entered, or even just get the values
directly from the form.

John W. Vinson [MVP]