Results 1 to 6 of 6
  1. #1
    yongku lee is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020
    Posts
    3

    Divide barcode values

    Divide barcode values

    Click image for larger version. 

Name:	2.jpg 
Views:	16 
Size:	231.5 KB 
ID:	42269
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    vWord = txtAutoIn
    txtYr = left(vWord,4)
    vWord = mid(vWord,6)

    i = instr(vWord,",")
    txtInName = left(vWord,i-1)
    vWord = mid(vWord,i+1)

    txtInTel = vWord

  3. #3
    yongku lee is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020
    Posts
    3
    Thank you.
    The number of words in 1 is not fixed.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    use the split function (only in VBA)

    inyear=split(auto_in,",")(0)
    inname=split(auto_in,",")(1)
    in-tel=split(auto_in,",")(2)

    don't understand 5

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    for 5 maybe just set DefaultValue property to Now().

    If the number of elements in string varies, do you always want the first 3?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    yongku lee is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020
    Posts
    3
    Thank you.

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

Similar Threads

  1. Replies: 5
    Last Post: 05-16-2019, 09:01 PM
  2. Replies: 7
    Last Post: 08-18-2016, 07:41 AM
  3. Is this barcode a working barcode?
    By panoss in forum Access
    Replies: 2
    Last Post: 11-06-2014, 10:10 AM
  4. Getting report values into a PDF417 barcode
    By eskybel in forum Reports
    Replies: 4
    Last Post: 08-06-2012, 10:26 AM
  5. divide by zero
    By rbee in forum Access
    Replies: 11
    Last Post: 07-19-2012, 12:55 PM

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