Results 1 to 4 of 4
  1. #1
    euphonium01 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    40

    Hiding Part of A Number?

    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

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    You could use a Trim statement or add a textbox overlay onto the textbox field to hide the numbers.
    Example:
    DateAdd("yyyy",3,[CalendarDate]) 'Trim Date used on an update qry to remove old dates.
    HTH

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    if your problem is displaying the value to the right 6 digits only, any query you run you could use

    BarCodeMod: right([Barcode], 6)

  4. #4
    euphonium01 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    40
    Absolutely brilliant, thank you so much, worked first time

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Same Part number, two different vendors
    By MFS in forum Programming
    Replies: 2
    Last Post: 02-19-2013, 10:35 PM
  2. Replies: 2
    Last Post: 04-13-2011, 09:42 AM
  3. Hiding Part Of a Field
    By ACCESSROOKIE1950 in forum Access
    Replies: 2
    Last Post: 05-09-2010, 09:52 AM
  4. Part Number Lookup
    By jacobbiljo in forum Queries
    Replies: 1
    Last Post: 11-12-2009, 09:22 AM
  5. Multiple Part Number Look=up
    By nywi6100 in forum Reports
    Replies: 0
    Last Post: 09-27-2006, 11:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums