M
milhous
Guest
Hello.
There's a project at work that I'm trying to implement, but need some guidance as to what the proper environment should be to create the solution. Thus the title of either using VB 6.0 and a separate Acesss 2000 database or using VBA with Access 2000.
We need a means to track about a 100 or so laboratory supplies in our stockroom. Basically, as an item is taken out of the inventory for use, the inventory will be updated. We will use a barcode wand reader which when a barcode is scanned for a corresponding item, it will place that value in the field, send a carriage return, and the app would then have to find that part number and deduct 1 less item from that stock. The barcoding is not the concern as it is straightforward and self-explanatory. So it seems pretty simple.
Eventually, I'd like to put some icing on the cake, and be able to use some sort of plug-in to send an e-mail to our purchasing manager that states what needs to be reordered.
Well let me know what you guys think. Once I know what development is the correct one to use, I'll need to consult some texts on implementing it. I do have basic VB skills so I won't be completely in the dark. Thanks.
There's a project at work that I'm trying to implement, but need some guidance as to what the proper environment should be to create the solution. Thus the title of either using VB 6.0 and a separate Acesss 2000 database or using VBA with Access 2000.
We need a means to track about a 100 or so laboratory supplies in our stockroom. Basically, as an item is taken out of the inventory for use, the inventory will be updated. We will use a barcode wand reader which when a barcode is scanned for a corresponding item, it will place that value in the field, send a carriage return, and the app would then have to find that part number and deduct 1 less item from that stock. The barcoding is not the concern as it is straightforward and self-explanatory. So it seems pretty simple.
Eventually, I'd like to put some icing on the cake, and be able to use some sort of plug-in to send an e-mail to our purchasing manager that states what needs to be reordered.
Well let me know what you guys think. Once I know what development is the correct one to use, I'll need to consult some texts on implementing it. I do have basic VB skills so I won't be completely in the dark. Thanks.
