Search results

  1. F

    Dsum assistance

    Hello, Looking for a Macro that looks up and sums the TTM (12 trailing months) of OPEX from a different table. In the table Initiatives I need a macro that will look up and add the 12 trailing months of OPEX from the OPEX table based on the date that it is entered. Also, if a future date is...
  2. F

    Update Totals on Related Tables

    Thanks KG Yes, I believe I will have to settle with 2 different forms: 1) that will be regular with single records and with the Total for its initiatives 2) I will still keep a Datasheet Form as I show above but this one will not display this total I will try option 1 above and let you know...
  3. F

    Update Totals on Related Tables

    Good day CJ, The Doc Man, Apologize if I haven't been clear enough, when I wrote "Edit All fields" the Total field shouldn't be one... let me rephrase it "all fields with the exception of the Total which should be calculated from each of the Initiatives" And I do not need to have the total...
  4. F

    Update Totals on Related Tables

    User will need to be able to edit all fields in that form. Is there a way add an unbound box to a regular Datasheet Form that looks up and updates the total? thanks
  5. F

    Update Totals on Related Tables

    Thanks CJ but this is not working - user also needs to edit the data in this "form" With the Select Query solution, we are only able to see the data.
  6. F

    Error when opening Dialog Box form from Link

    that fixed it! thank you!!
  7. F

    Update Totals on Related Tables

    Dear CJ, The Total drop-down will work for the all the actions Total, what we need is the Total of all the Initiatives to show in each action I tried also the =sum([InitiativeTotal]) as control source but it is giving me an error thanks again for your help
  8. F

    Update Totals on Related Tables

    ok, thanks CJ_London! Following your recommendation, if I am to add the same total in a form, how would the formula be?
  9. F

    Update Totals on Related Tables

    Please see an example below, we need the sum of all InitiativeTotal to show on the ActionTotal ActionID 1 will have the sum of InitiativeIDs 454, 616 & 1264 thanks
  10. F

    Update Totals on Related Tables

    I would like to have this sum on the ActionTotal from the ActionsTable Could you help me showing how the code will be for this? Thanks
  11. F

    Error when opening Dialog Box form from Link

    I have the following related tables with corresponding fields Actions have multiple Initiatives: one to many relationship(1 to *) ActionsTable ActionTitle ActionID(1) ActionTotal InitiativesTable InitiativeDetail InitiativeID ActionID(*) InitiativeTotal I also created a forms for both of...
  12. F

    Update Totals on Related Tables

    Thanks Pat, CJ_London, As mentioned my intention is for the next step is for these numbers to be joined to the ActionsTable under the field InitiativeTotal matched by the ActionID... I understand it is not good practice to store these calculations there but it is needed for visibility... Could...
  13. F

    Update Totals on Related Tables

    ok, I edited as per below SELECT Actions.ActionID, Sum(Initiatives.InitiativeTotal) AS TTLInitiatives FROM Actions LEFT JOIN Initiatives ON Actions.ActionID=Initiatives.ActionID GROUP BY Actions.ActionID; Query just turns into DataSheet with the recap amounts (see attached) What would be...
  14. F

    Update Totals on Related Tables

    Thanks but somehow it did not work. I tried it this way: SELECT Actions.ActionID, Sum(Initiatives.InitiativeTotal) AS Initiatives FROM Actions LEFT JOIN Initiatives ON Actions.ActionID=Initiatives.ActionID GROUP BY Actions.ActionID For visualization purposes it is ideal that the sum of the...
  15. F

    Update Totals on Related Tables

    I have the following related tables with corresponding fields Actions have multiple Initiatives: one to many relationship(1 to *) ActionsTable ActionTitle ActionID(1) ActionTotal InitiativesTable InitiativeDetail InitiativeID ActionID(*) InitiativeTotal Every time an initiative is added or...
  16. F

    New Records on Dialog Box

    Thank you so much theDBguy! That should be all!
  17. F

    New Records on Dialog Box

    Excellent... one last thing (hopefully!) The default value in the VendorContacts Form is also defaulting to number (for more complex text ones it will be a problem) How do you change this one to a text value? Me.VendorID.DefaultValue = Me.OpenArgs
  18. F

    New Records on Dialog Box

    It is giving me an error asking to type in the VendorID
  19. F

    New Records on Dialog Box

    I tried it as follows and the default VendorID appears but it is not filtering it correctly... see attachment DoCmd.OpenForm "VendorContacts", acFormDS, , Me.VendorID.DefaultValue = """" & Me.OpenArgs & """", acFormEdit, acWindowNormal, Me.VendorID
  20. F

    New Records on Dialog Box

    could you do the same VBA code but for a VendorID that is text (not number format) thanks!
Top Bottom