After a thorough investigation, I have now decided on the software and related hardware necessary to implement barcoding into our database. The actual barcode will be read by numerous pen scanners within the factory and be directly linked to the backend database on the server by keyboard wedge. A time-in and a time-out will also be linked to the scanned barcodes. The input form itself within the database is very simple, one field (RunID)and 2 buttons (Start and End). I would however have to write a Time Stamp Procedure to capture these times. At this point I do not have the actual software (only demo), nor the scanner pens so I can't really test the results. My question is has anyone written a Time Stamp Procedure to cover this type of data input or is it as simple as applying the current date and time
to the RunID field.
to the RunID field.