Scott Marcus
marcus at tsstech.com
Mon May 17 14:15:56 CDT 2004
Nancy, My company is heading in the same direction. I'm currently logging time card punches using employee badges (not linked yet to jobs), which is all done via barcode readers. Once the basic's are done and working smoothly(we are almost their) we will be linking to an Oracle backend and developing tracking based on P.O.#'s and Workorder#'s. Haven't run into anything major yet, but your mileage may very. It all depends on planning out the project before jumping in. Most of the code I have done in this application is error trapping employee's double(triple...) swiping their badge. If you have any questions, let me know. Scott Marcus TSS Technologies, Inc. marcus at tsstech.com (513) 772-7000 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris Manning Sent: Monday, May 17, 2004 1:36 PM To: AccessD at databaseadvisors.com Subject: [AccessD] Barcoding in Access My friend Nancy Lytle is having trouble posting to AccessD from her work email so I'm posting this on her behalf. ********************* I am working at a small company that sells very high end audio/visual assemblies and installation and integration with home automation systems. We have sales people who get the clients and jobs and then turn them into specific orders which are then fabricated/assembled and then put in a holding area until they are packed on the truck to go to the site (usually a house being constructed). Items occasionally are returned to the warehouse. We do not keep a real inventory, we order and have on hand only the items the clients have ordered. The only things we "stock" are things like wiring and racks since we have very limited warehouse space. We have an Access database where we keep the information on clients, jobs, orders, purchase orders, contracts, quotes, etc are keep. We are thinking about add the use of barcodes to the database to 1) track employee time on jobs, they do fabrication and installation for multiple jobs in a day and 2) track the A/V equipment that is ordered for a client and used in the fabrication of their order, in other words track from PO to receiving to shelving to fabrication to pick/pack list to return to office (if not used). The concerns seem to be billing the clients properly for the time the assemblers/installers work a job, and keeping tighter control on the "inventory" we do have on hand, so we know if a piece if equipment has come in, if so where it is and if the order was not completely filled - how many remain to be received, etc. I wanted to ask about other people's what their experiences with barcoding as part of an Access solution and their opinions on whether barcoding might be of use in this type of situation or if some other solution might be better. Nancy Lytle nlytle at allaroundtech.com ******************** Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com