jakebailey
01-03-2010, 08:26 PM
Hi Everyone,
I'm trying to come up with a solution to make our year end inventory go smooth this Friday. In the previous years this inventory can take 2 1/2 days and in the past week I've lost two employees to medical leave which means I will have to rely on other employees who are not familiar with our inventory to step in and help.
Here is what I'm trying to do:
1. Scan a UPC code into a text box
2. Validate the UPC code against a database (Access or Excel)
A. If the UPC Code does not exist then prompt user to add the item to the database
3. Once the UPC code is validated then bring back the Model number, Vendor's name, description, and UOM.
4. Write the information to the excel document along with a time stamp of when it was scanned.
Here are some other factors to keep in mind.
1. This process needs to be quick - the users will scan product as quick as the scanner will let them so it can't be held up by code waiting to execute.
2. I would prefer to do the data validation over the network so multiple users can contribute to the item database.
What I'm looking for most is some guidance on what direction I should head in. I'm not a programmer by trade but I certainly enjoy using VBA to make my life easier at work and typically don't mind working through all the trials until I somehow figure out what to do but unfortunately I don't have the luxury with inventory coming up in 5 days.
I appreciate any and all suggestions/guidance/pointers for this.
Thanks,
Jake
I'm trying to come up with a solution to make our year end inventory go smooth this Friday. In the previous years this inventory can take 2 1/2 days and in the past week I've lost two employees to medical leave which means I will have to rely on other employees who are not familiar with our inventory to step in and help.
Here is what I'm trying to do:
1. Scan a UPC code into a text box
2. Validate the UPC code against a database (Access or Excel)
A. If the UPC Code does not exist then prompt user to add the item to the database
3. Once the UPC code is validated then bring back the Model number, Vendor's name, description, and UOM.
4. Write the information to the excel document along with a time stamp of when it was scanned.
Here are some other factors to keep in mind.
1. This process needs to be quick - the users will scan product as quick as the scanner will let them so it can't be held up by code waiting to execute.
2. I would prefer to do the data validation over the network so multiple users can contribute to the item database.
What I'm looking for most is some guidance on what direction I should head in. I'm not a programmer by trade but I certainly enjoy using VBA to make my life easier at work and typically don't mind working through all the trials until I somehow figure out what to do but unfortunately I don't have the luxury with inventory coming up in 5 days.
I appreciate any and all suggestions/guidance/pointers for this.
Thanks,
Jake