Results 1 to 3 of 3
  1. #1
    lonlyspartakos is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2015
    Posts
    9

    Tricky one... for me at least

    Here is the thing guys I want to create form with field that I will fill with a number of 16# digits



    the first 6 digits are always referring to a department in Table1

    what I need is another field that remove the first 6 digits with the departments names and keep the rest of the 10digits ??
    is it doable ..?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    have a combo box with dept columns: name/#
    the combo box bound to Dept#, holds the 1st 6 digits
    a text box holds the other 10 digits for user to enter

    in a query , combine the 2 if needed: cboDept & txtNumber

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    In a table you have two text type fields?
    One field (lets call it "All16") will have all 16 characters (letters or numbers)
    The other field (lets call it "Last10") will hold the last 10 characters (letters or numbers).

    In the form, the after update event of the text box control "tbAll16" (tb = text box) would look something like:
    Code:
    Private Sub tbAll16_AfterUpdate()
        Me.tbLast10 = Right(tbAll16, 10)
    End Sub

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

Similar Threads

  1. Tricky question
    By Xipooo in forum Access
    Replies: 5
    Last Post: 03-14-2014, 11:13 AM
  2. subform a little tricky
    By buckwheat in forum Access
    Replies: 5
    Last Post: 09-11-2013, 01:05 PM
  3. Tricky SQL Question
    By ttocsmi in forum Queries
    Replies: 8
    Last Post: 10-01-2012, 10:04 AM
  4. Tricky Analysis??
    By stumped in forum Queries
    Replies: 2
    Last Post: 09-13-2012, 01:59 AM
  5. Tricky calculation to perform
    By leeli67 in forum Access
    Replies: 122
    Last Post: 04-15-2012, 05:06 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