Search results

I see now I was wrong, I am usng .text I will change that and give it a try.

Here is my code and a snaphot of my query, I am starting to think it's the redundancy in the query but I am not sure. qryEstimatesListActive is the query the form uses as a record source (pic 1), qryEstimateTotalPrice, is a subquery added to the main query(pic 2) Thanks Private Sub...

I will post the code when I get neck to my workstation but I am not using .text, I am using value. It works when the underlying query is editable, but not when it is read only by adding a sub query to the query with calculated fields even though it is not the field I am searching on. thanks

Does anyone know how to write code for a dynamic search box for data in a form who’s recordset is read only? The one I’ve been using works great when the query is editable but when I add a calculated field I get the dreaded “can’t reference a property unless the control has the focus” Thanks

Is there a way to make this work with a read only record source?

Got it. ThanksPat

Oops sorry the detail is rolled up on the order form so the customer doesn’t see the cost of the accessory. I would like the price on this report to roll up as well for so we can just look at the sale price of the detail. I really only need the accessory to show on the report so during...

Orders-->Details-->Accessories 1 detail can have many or none accessories. They both pull from the same shop detail table for their price because a custom fabricated part can be either a detail or accessory. The accessory adds to the detail price for its sell price. Thanks

Ok here is where it gets complicated. Each of the order detail records AND each of the accessories records will have a sub report that shows the time spent in the shop for labor and material. The order details and accessories just need to list the name and price. The shop times are from a...

Thanks, I am in the process of laying out the report so I will know how I want the data presented. Thank you

Do you “throw” everything possible in your query for a report or use multiple sub-reports? My report has the main report , from orders table, also, order details, and order detail accessories, so far so good but each order detail AND accessories group will have a sub report to show the custom...

Thanks for the info Pat

Thanks, I found that a bit ago and ha e read it. Helps a lot.

Thanks

I am trying to remove a calculated field from a table but when I build a query to run the calculation from a related table the main query's recordset becomes un-editable. how do I accomplish this?

Trying to figure out how to get my main query editable when all of the underlying subforms use queries with calculated fields

I am struggling to understand what makes some of my queries produce un-editable recordsets.

Thanks

Should I get the extended price for a product on an order by creating a calculated field in the query recordset for the form's data, or just do the calculation on the form?

Ahh... you teach me well master :) I get it now. Thanks