Recent content by jetersauce

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

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

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.

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...

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?

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...

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...

Thanks, that works great! :D

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...

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?

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...

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!

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...

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...

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?