Results 1 to 2 of 2
  1. #1
    Sinatra Fan is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2006
    Location
    Orlando, FL
    Posts
    8

    how do I create custom part numbers?

    I want access to generate a part number for me using information from other fields. For example, I want to create a part number using 1) supplier code (JA), 2) product size (LG), 3) product type (SRT), 4) color (BK) and then an auto number (0008) The end result in this case would be "JA-LG-SRT-BK-0008" Is there an easy way to do this? Thanks for the help

  2. #2
    Join Date
    Sep 2006
    Location
    Manchester, England
    Posts
    13
    I guess you know the first part so you are wanting to generate the incrementing part at the end?

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

Similar Threads

  1. Search any field and part thereof
    By Johan in forum Programming
    Replies: 0
    Last Post: 09-08-2008, 02:18 AM
  2. Search any field and part thereof
    By Johan in forum Forms
    Replies: 0
    Last Post: 09-03-2008, 08:01 AM
  3. Multiple Part Number Look=up
    By nywi6100 in forum Reports
    Replies: 0
    Last Post: 09-27-2006, 11:38 AM
  4. Replies: 2
    Last Post: 12-09-2005, 01:58 PM
  5. Creating a *Good* Custom Message Box
    By Jerimiah33 in forum Forms
    Replies: 1
    Last Post: 11-09-2005, 04:47 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