G
Guest
I am trying to create an Inventory Management System using MS Access 2000 and
an ActiveX-Plus plug-in that will allow the use of BarCodes. In my Access
Db, there are only two tables (Computer, Equipment) that will need to store
the barcode for each instance. My problem arises when trying to devise a
scheme for a unique barcode to be randomly created for each instance. I can
randomly create a barcode for each instance of Equipment and Computer, but
they are not unique because using the AutoNumber feature in Access to create
the random number, it does not cross-reference with other table to see if the
“BarCode_Number†value already exists. This would mean that when I scan the
barcode with a reader, I could possibly get an error because the scan could
produce an instance of both Equipment and Computer.
To solve this, I would like to assign a concatenated value into a field of
the instance. For example, in the Computer table, I would like to
concatenate the values from the “PC_Type†field and the randomly generated
number value from the “BarCode_Number†field into the “Barcode†field. For
example, I could get a possible “BarCode†value of â€Laptop10000001â€. This
would also allow me to easily define the BarCode's 'ownership' to the type of
equipment.
Can someone please inform me on how to assign a concatenated value from two
fileds of the same table to a third field of the same table?
Thank you for your help,
Drew
an ActiveX-Plus plug-in that will allow the use of BarCodes. In my Access
Db, there are only two tables (Computer, Equipment) that will need to store
the barcode for each instance. My problem arises when trying to devise a
scheme for a unique barcode to be randomly created for each instance. I can
randomly create a barcode for each instance of Equipment and Computer, but
they are not unique because using the AutoNumber feature in Access to create
the random number, it does not cross-reference with other table to see if the
“BarCode_Number†value already exists. This would mean that when I scan the
barcode with a reader, I could possibly get an error because the scan could
produce an instance of both Equipment and Computer.
To solve this, I would like to assign a concatenated value into a field of
the instance. For example, in the Computer table, I would like to
concatenate the values from the “PC_Type†field and the randomly generated
number value from the “BarCode_Number†field into the “Barcode†field. For
example, I could get a possible “BarCode†value of â€Laptop10000001â€. This
would also allow me to easily define the BarCode's 'ownership' to the type of
equipment.
Can someone please inform me on how to assign a concatenated value from two
fileds of the same table to a third field of the same table?
Thank you for your help,
Drew