Consulting

Results 1 to 5 of 5

Thread: Determin whats different in text

  1. #1

    Determin whats different in text

    If I had a form Form1 and on that form there were two combo boxes cbo1 and cbo2 and I selected for cbo1 (ProductID) 2 and for cbo2 I selected (ProductID) 3. Large image Is what kind of data I have.


    In the smaller image it would always be two results. The items in the second row "cbo2" that are circled are the ones I want to display in my report. How do I do this?
    Attached Images Attached Images
    Last edited by oxicottin; 06-24-2019 at 11:20 AM.

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,041
    Location
    Sorry, can you explain the difference between number 3 in image 1 and number 3 in image 2?
    As I can't see the difference that you are looking for.
    When you say that you want to display the values in circles in a report, is it just those values?

  3. #3
    I have two combo boxes my your form. Eachcombo box lets you choose a product. After choosing two products, I want todynamically create a query that will show only those columns where the twoproducts have different results and/or hide those columns that have the samevalues for the two selected products BUT I only want to show the results fromto "To" combo box not the "From" combo box as shown withthe green circles.

    What im trying to do is show whatcomponents are needed to switch over to another product, kind of like a partslist but the reason I want to hide those columns that have the same values forthe two selected products is they are already installed so I don't need thosecomponents.

    Here is a query that gets me the results a shown in the small image.

    SELECT tbl_Product.ProductID, tbl_Product.Product, tbl_Components.Steel, tbl_Components.Paper, tbl_Components.CutOffBlades, tbl_Components.FeedWheel, tbl_Components.FinalForm, tbl_Components.LastPass, tbl_Components.Straightner, tbl_Components.FingerStation, tbl_Components.GlueHead, tbl_Components.OilerWheel, tbl_Components.PinprickLowerPlate
    FROM (tbl_Product INNER JOIN tbl_Components ON tbl_Product.ProductID = tbl_Components.ProductID) INNER JOIN tbl_SetUp ON tbl_Product.ProductID = tbl_SetUp.Product
    WHERE (((tbl_Product.ProductID) Between [Forms]![frm_Switchboard].[cboComingFrom] And [Forms]![frm_Switchboard].[cboGoingTo]));



  4. #4
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,041
    Location
    It is quite possible to write some VBA to generate a queryDef for use with a report, I will attach an example of creating a queryDef.
    What I can't work out at the moment is how you arrive at the decision of what records to include.
    Or is it just the one record?
    Attached Files Attached Files

  5. #5
    Quote Originally Posted by OBP View Post
    It is quite possible to write some VBA to generate a queryDef for use with a report, I will attach an example of creating a queryDef.
    What I can't work out at the moment is how you arrive at the decision of what records to include.
    Or is it just the one record?

    Thank you that gave me some ideas....Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •