creating multiple records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert - 26 Feb 2007 16:10 GMT

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

Reply to this Message

Al Campagna - 26 Feb 2007 17:03 GMT

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?

Signature

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."

> 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
[quoted text clipped - 13 lines]
> Field1 Number of new Items
> 1234 5

Reply to this Message

Robert - 26 Feb 2007 17:26 GMT

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.

> Robert,
> There may be other suggestions on this, but...
[quoted text clipped - 18 lines]
> > Field1 Number of new Items
> > 1234 5

Reply to this Message

John W. Vinson - 26 Feb 2007 20:10 GMT

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

Reply to this Message