Hi, I have created a working database but have been asked to include a Stock List into the existing database, that's not a problem but:
I created a little 'dummy' run database to test out before adding the Tables etc to the existing database but, I came across a problem.
The items we ship into the UK have Bar Codes that represent various items' Serial Numbers, I can scan the numbers no problem, except they are too long for the Field we use, for instance:
A scanned number comes up 114283603, but we only use the 6 digits from the right (283603) in the Serial Number field. My question is, how to scan the 9 digits in but only have the right hand 6 visible? It wouldn't be a problem if the entry dropped the leftmost 3 digits altogether after scanning so that only the right hand 6 show?
I do have a problem getting my head round Code, so if this can be done in a Macro or a small amount of Code ....fantastic!!
thanks in advance for any help