Search results

Greetings, I sure could use some help with VBA that will make it possible to copy the last entered record using a command button on the database's Task Details Form and applying DMAX and DLOOKUP VBA. I have attached a WinZipped copy of my Scheduling database to help expedite a solution. Thank...

Hey mike60smart, You NAILED it. It's working perfectly!! I can't thank you enough for your help and patience! Great work!!!! Thank you again Mike for all your help! Cheers, Bruce

Hi mike60smart, Thanks very much for your help. Unfortunately, what I need the database to update is different. I put together a very brief zipped file explaining what I need to have the database do. Please let me know if I need to clarify more. Thanks again for all your help Mike. Cheers, Big D

Hi mike60smart, I need to have the subform sheet that's embedded in the main form get the cost data from the Task Details form which currently shows $620. If we can get the subform sheet cost (which is currently manually entered in the subform $550 to show $620 instead), then the Total Task...

Can you please try this zipped copy. I used WinZip for this one. Thanks very much! Big D

mike60smart, I guess you can tell from the screenshots and my notes on them that what I really need is to be able to link the cost field in the subform to the calculated cost field in the Task Details form so that the subform field updates with the value in that's calculated in the Task...

Hi mike60smart, Yes, I believe you're absolutely right. Thanks very much for all your help!! Big D

Hi arnelgp, Thanks very much for sending over the database to practice on. Boy am I having a heck of time trying to sort this problem out. I thought about the problem a bit more and thought that it would be easier to make some screenshots of my database and add notes and a more clear...

Thank you again for confirming for me. Unfortunately, I couldn't get it to work. I got the follow errors: Total Task Cost field in the footer came up with #Name? and the Balance field came up with #Type! This is what I put in the Total Task Cost field on the main form...

Thanks very much for your help in solving my forms problem. Can you please tell me where to add the code in the 2nd box: add code to the Activate Event of the main form: Code: Private Sub Form_Activate() Call fncCompute(Me![Tasks subform].Form) End Sub Thanks Again, Big D

Thanks very much for your help. Can you please tell me where I can find the SubformControlName? Is this the title that shows at the top of the subform? The title is Task Details. Also, does [Form] stay as you've written in the expression or should Form be replaced with a form name? Thanks...

Hello, I have a production scheduling database with a main form with a field that totals task cost by using: =[Tasks subform]![SumOfCost] in a field which causes the field to update based on a value that's calculated in a subform for various tasks that are added to the subform. As I add tasks...