Results 1 to 7 of 7
  1. #1
    jmwebster91 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Posts
    13

    Updating text box in form used as query criteria

    Hey there,

    I have an Access Database that formulates a part code from multiple combo boxes within a form.

    Click image for larger version. 

Name:	codemaker.PNG 
Views:	14 
Size:	19.5 KB 
ID:	24951



    Each of these combo boxes is referenced one after another in "txtPartID" where the part code is put together.

    Click image for larger version. 

Name:	txtPartID.PNG 
Views:	14 
Size:	36.3 KB 
ID:	24952

    Click image for larger version. 

Name:	part id formulation.jpg 
Views:	14 
Size:	90.1 KB 
ID:	24953

    I want to use this part code as query criteria, to search for the relevant spares part.

    The query criteria i have come up with is

    [Forms]![frmCodemaker]![txtPartID]

    Click image for larger version. 

Name:	spares query.PNG 
Views:	14 
Size:	13.4 KB 
ID:	24950

    I have tested known data as a code for the query, and it has returned no results.

    I then want the output of this query to show in another text box.
    underneath the txtPartId text box, this will help the quotation system i'm developing.

    Tried to upload the .db as an attachment, but it wasn't playing ball

    Kind Regards

    Joe

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Relational databases work quite well based on 1 fact, 1 field. Many attempts to codify by concatenating various fields seems a work around instead of using an autonumber Primary key. If that code is to be used by user, will they understand it? How exactly will they use it?
    If readers knew what you goal was, then there may be some options.

  3. #3
    jmwebster91 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Posts
    13
    The aim of the database is to be able to create part codes without prior knowledge of the coding system, then also forming spares codes relating to those specific parts. Also moving forward from there there will be calculations based on the data (which i haven't even approached yet).

    The people who will use this know exactly what the scope is, and how they will use it. It's to make their quoting system easier. The database that they are using currently is outdated, but it is company wide, so unchangeable.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    What type of business is this (Industry sector)?
    There are many standardized coding systems for Products and services.
    I have worked with groups using NAICS, UNSPSC, HS Codes, NSN...... and most have a hierarchical structure.
    Can you tell us more about your coding scheme and structure?

  5. #5
    jmwebster91 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Posts
    13
    This is the engineering sector:

    I'm not sure what the actual name of the system is, but the part code is shown in one of the screenshots above. The combo boxes are used to select the next part of the code, which then adds it in the text box at the bottom.

    Kind Regards

    Joe

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You seem to know your business. However, I was just trying to say there are many coding schemes in existence, and most are geared to sales, fulfillment and supply.

    I don't know who your customers are but here are a few links to get a broader view of codification schemes generally:

    http://www.nato.int/structur/AC/135/...marketing1.pdf
    http://cbaonline.org/wp-content/uplo...ProdCodeBP.pdf
    https://en.wikipedia.org/wiki/Electr...nt_Association
    http://www.itds.gov/linkhandler/itds...o_standard.pdf

  7. #7
    jmwebster91 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Posts
    13
    Thank you orange,

    I'll take a look at these and get back to you

    Many thanks,

    Joe

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

Similar Threads

  1. Replies: 2
    Last Post: 07-01-2015, 11:39 AM
  2. Replies: 4
    Last Post: 12-29-2014, 01:53 PM
  3. Replies: 2
    Last Post: 07-09-2014, 12:43 PM
  4. Replies: 2
    Last Post: 06-22-2014, 09:49 PM
  5. Query isnt updating table based on criteria
    By shabbaranks in forum Queries
    Replies: 12
    Last Post: 01-10-2012, 11:51 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