Search results

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?

I have a form that has a combo box that selects CustomerIDs and displays the correct record in the subform. The row source for this combo box is a table named cbCustomerIDs that the only field is a list of all the CustomerIDs. What I need is for the combo box to automatically select the...

Sorry, I have another question about this. If the query linked to the report does not return any results the following error occurs. Run-time error 2427 You entered an expression that has no value At this point several other errors occur and you have to close the database and reopen it to...

Thanks that worked, I put the ResultStatus in that section and made it not visible. Every record would have a result status and they will all be the same per report. Thanks, I was at a loss on how to do this.

Thanks for the reply :D Sorry, but I'm not very well versed in VB. I opened the code builder on the section the signature is in, but I am getting an error message: Run-time error '2465' Microsoft Access can't find the field 'ResultStatus' referred to in your expression. This is what I put...

I need to know if you can put a conditional statement on a bound object frame. If a result has been approved it needs to display the signature of the person that reviewed it. If it has only been validated it needs to display the text "Results Not Final" I have a working statement on a...