Alhakeem1977
Registered User.
- Local time
- Today, 06:20
- Joined
- Jun 24, 2017
- Messages
- 308
In my database I have got a VBA module to generate a barcode, I would like to utilize the barcode to manage the customer s' physical file movement in our organization between departments, but I have an issue that we are the department who maintain this files and who has the barcode readers.
My aim is when the user request a file then he or she should acknowledge it the user will type the Account number but it's very long number, instead of that if I can use another reference with no more than 4 digits I heard about something called (Algorithm) I don't know whether I could use this technique as Allen Browne stated in this site: http://allenbrowne.com/vba-Soundex.html
My source table has two columns:
Account number (6600-123456-600)
Customers Full Name ( John Albert )
The customer may have many files depends on the Account type and may carry the same account number.
Which is the best approach to reference my barcode string to handel this process the Algorithm or something else?
Thanks a lot in advance!
Sent from my HUAWEI NXT-L29 using Tapatalk
My aim is when the user request a file then he or she should acknowledge it the user will type the Account number but it's very long number, instead of that if I can use another reference with no more than 4 digits I heard about something called (Algorithm) I don't know whether I could use this technique as Allen Browne stated in this site: http://allenbrowne.com/vba-Soundex.html
My source table has two columns:
Account number (6600-123456-600)
Customers Full Name ( John Albert )
The customer may have many files depends on the Account type and may carry the same account number.
Which is the best approach to reference my barcode string to handel this process the Algorithm or something else?
Thanks a lot in advance!
Sent from my HUAWEI NXT-L29 using Tapatalk
Last edited: