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

    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...
  3. 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...
  4. F

    New Records on Dialog Box

    Hello, I created a form with vendors which has a button and opens up another form in "dialog ratesheet" format with that vendor's contacts. The button worked well in that it filters the form with the appropiate VendorID but when I need to enter a new contact, I have to manually enter the...
  5. F

    Cannot get a DLookUp to work

    The objective is to populate the "OrderDetails" form / table with data from the "Services" & "Items" table. I am able get data from the "Items" table with the below event: Private Sub ItemID_AfterUpdate() Me![Brand] = DLookup("Brand", "Items", "[ItemID] = " & Nz(Me.ItemID, 0)) End Sub I can...
  6. F

    DLookUp on Update Query

    Dear all, Trying to use a DLookUp formula in an update query to clean up a code There are 2 tables with the following: MainTable which Contains the fields: MainDirtyCode and MainCleanedCode CodeCleanUp which Contains the fields: DirtyCode and CleanedCode Update Query to modify...
  7. F

    Why subform defaults to start new record??

    Hello all, I have a problem with a subform (Inside another form) Automatically when loading it defaults to creating a new record causing me issues since it starts in a mandatory field... is there a way to stop this? Take a look at the print-screen thanks!
  8. F

    Help with DLookUp Macro

    Hello all I have been trying to run a macro that will update a date. The premise is that I have a Form for the table [ACTIONS] and within these actions, there are different notes --> [ACTIONNOTES] An action will have multiple notes. On [ACTIONS] there is [LastUpdate] date and on...
  9. F

    Removing Grand Total column from pivot table

    Hello All, It is silly but I cannot find the way to remove the Grand Total Column in an MS Access Pivot! Any help is welcome! thanks!
  10. F

    Query to assign values to a cost item based on dates from a contract

    Hello all, I have been working my head to create a query that will populate a contract number to a specific cost item based on: Contract Validity, type of cost and Location. Given that the contracts might be for several types of costs, there has to be a separate table that assigns the type of...
Top Bottom