Recent content by cdoner

You've come to the right place for help. The community here is amazing. I believe I understand what you are requesting. Your expression would need to check the value in [SUP_DATE] and somehow calculate your desired result against DATE(). I'm thinking an IF_THEN statment for this. If that is...

Quick update. I found a more elegant solution than using two subforms. Here are the changes. Eliminated second subform which ran the UNION query to calculate subtotal Placed the SQL for the UNION query into VBA on main form and run it on the Form_Current event (see below) Eliminated refresh...

@Gasman @Pat Hartman @oleronesoftwares Thank you all for your assistance. Here's what I ended up doing to work around my issue: I created a second subform referencing the query used by Gasman that worked for the desired calculation I put that second subform into a page, placed the unbound...

@Pat Hartman I believe I have this part correct. The unbound text field is in the footer of the subform, just trying to get the correct control source or VBA to show the sum of the selected field from the continous form. I really think what is gumming this up is the union query but also...

@Pat Hartman I had tried that and the result is: #Error =([txtComponentPrice]/[txtComponentNET])*[NET] will work and shows the value correctly for the record selected but as soon as I try to =sum() I get the error.

@Gasman I think I see what you have done to make the calculation work: SUBFORM MenuItemDetails record source was changed from "qrySUBFORM MenuItemDetails" to "qrySUBFORM MenuItemCost" "qrySUBFORM MenuItemCost" has a field with the expression which calculates component subtotal AS...

Misery loves company :) But jokes aside, you have solved my issue, thank you. I'm taking a closer look at your changes to understand how I could have approached this differently.

I have tried a query approach as well. In the db File look at "qrySUBFORM MenuItemCost". In that query I have an expression which calculates the subtotal for each MenuItemDetailsComponentID as [ComponentSubTotal] but if I try =sum([ComponentSubTotal]) the result is: #Error

Asking for help please. Using an unbound text box in the footer of a subform I am trying to calculate a sum of values from a recordset in a continous form using a loop. Additionally, the field for which I am trying to sum is also an unbound field that holds an expression. dB file attached...

I was able to use this method to work around a union query not allowing me to execute a calculated field in a continuous form. So glad I found it and a big thank you Mr. B. Quoting Mr. B above:

@theDBguy Yes sir, was able to successfully implement your code to my project. Your code was way more elegant that what I had previously. Super appreciative. I'll be studying your code for some time as I continue to challenge myself to become a better developer.

@thDBguy - The attached dB you have provided is working like a charm on my side. I'm thoroughly impressed and even more grateful for the assistance. Thank you. Let's call this solved with excellent satisfaction. @Gasman - 4209 Posts and thanked 742 (make that 743) times and listed as an...

Gasman - Thank you for chiming in. I gave your code a go and get the same run time error but oddly enough on the code segment here: rstA("FileData").SaveToFile strPath However the link you provided seems to be promising. I'll dive into that more and try to digest it. And just to confirm, you...

isladogs - Thanks again. theDBguy - Correct. The code will successfully produce an email in MS Outlook, it will not attach the files in the attachment field. The code was only changed to account for the field names in the sample dB provided. I receive the same run time error at the same...

isladogs - Very much appreciated.