Recent content by jetersauce

  1. J

    Subform controled by combo box will not requery

    Is there anything else I should look at? The form is still not working properly.
  2. J

    Subform controled by combo box will not requery

    I checked and they both are named AFL_CustomerPrice_subform Why would it work after adding a record but not before?
  3. J

    Subform controled by combo box will not requery

    Where would I check to see the name of the control that houses the subform (sorry I'm self taught)? Yes they are underscores and not spaces.
  4. J

    Subform controled by combo box will not requery

    I'm having a problem with a subform that will not requery. The subform is a datasheet that pulls price records based on a combo box in the main form. The query for the subform is as follows SELECT AFL_CustomerPrices.Matrix, AFL_CustomerPrices.Test, AFL_CustomerPrices.Method...
  5. J

    Concatenate field into additional query rows

    Since it is a proprietary database, I cannot edit any existing tables. I can however add new ones. Is there a way I could add a table that could allow the data to be displayed correctly in the query?
  6. J

    Concatenate field into additional query rows

    I have a frustrating problem that I could really use some help on (I'm not sure if the solution would be in the query or report) :confused: Our company have labels that we print on samples for testing. We have to have a separate label for every dilution in a test. What I need is a way so...
  7. J

    Create duplicate labels?

    I am working with a LIMS database that prints labels for samples that will be tested in the lab. The lab has chosen to denote different prep methods by imputing the values into one field separated by commas (this has been set by the lab and cannot be changed). The problem is the report that...
  8. J

    Count values outside of upper/lower limits

    Thanks, that works great! :D
  9. J

    Count values outside of upper/lower limits

    The purpose of this query is to have a general query that can calculate the % compliance of different tests. I'm trying to get to the point where I can calculate the expression: Compliance: ([TotalParams]-[NumberOutOfSpec])/[TotalParams]*100 To calculate the [TotalParams] field I'm using the...
  10. J

    Count values outside of upper/lower limits

    My query that contains the fields Result LowerLimit UpperLimit I need a way to calculate the total number of Result values that fall outside of the upper and lower limits. What would be the best way to do this?
  11. J

    Crosstab column headings cause query to not have results

    I tried to set column headings on a crosstab query so that I can display them on a report (since the column headings change depending on the OrderID). When I added the code in bold, it caused the query to not display any results in those columns PIVOT Results.SampleNumber In ("Case 1","Case...
  12. J

    Concatenate field and remove duplicates

    The comma was a typo. It looks like I got that error because I named the module with the same name as the function ("ConcatRelated") :o Changing the query in the function to SELECT DISTINCT eliminated all the duplicates :D Thanks for the help!
  13. J

    Concatenate field and remove duplicates

    Yes this is one of the ones I tried, but I could not get it to work. In the query I put =ConcatRelated("OrderID", "Orders", ) But I keep getting the error "Undefined function 'ConcatRelated' in expression." The code I pasted into my module is Public Function ConcatRelated(strField As...
  14. J

    Concatenate field and remove duplicates

    I have a report that needs to take all of the values from a field concatenate them into a line and remove the duplicates. I have tried some VBA concat modules but haven't been successful in finding a solution. I need this: OrderID 1030 1031 1049 1053 1053 1054 1054 1054 1059 1059 1060 1060...
  15. J

    Combo box selection based on a different form

    I'm sorry, I have read the 2 guides you posted and I'm still at a loss (I don't have much experience programming with VB) :confused: Could you give me an example of what the code would look like?
Back
Top Bottom