Hackcess2007
Registered User.
- Local time
- Yesterday, 16:26
- Joined
- Mar 8, 2014
- Messages
- 47
Hi all,
I split and implemented my equipment check in check out database probably before i did enough testing. The problem is I am finding problems and the reasons for them. I made a query to track the movement of our equipment in and out of the warehouse BUT, the end user is able to scan (accidentally) the same barcode number in the combo box during the same transaction. It would be great to use a marco or code to have the second instance of the barcode number open a message box and not allow the second entry saying " This was already scanned in" I am not strong with vba but I see the need to learn. Any help is always very much appreciated by you guys gals.
Thank you and have a great day!
I split and implemented my equipment check in check out database probably before i did enough testing. The problem is I am finding problems and the reasons for them. I made a query to track the movement of our equipment in and out of the warehouse BUT, the end user is able to scan (accidentally) the same barcode number in the combo box during the same transaction. It would be great to use a marco or code to have the second instance of the barcode number open a message box and not allow the second entry saying " This was already scanned in" I am not strong with vba but I see the need to learn. Any help is always very much appreciated by you guys gals.
Thank you and have a great day!