Search results

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!

could you help me write the code for this function? thanks!

How would you write the same as below in VBA but setting the value on a table? DLookUp("Max([NoteDate])","ACTIONNOTES","[ActionID]=[ActionIDb]")

Thanks both of them work. However found another problem but with the SetValue function - it only works to update records (or Set the Value) of another related form - if I am in a form with more than 1 subform it will not work. Do you know a way to have SetValue set the value for a Table...

Yes! ok, I think I have it.... it's MAX... https://www.access-programmers.co.uk/forums/showthread.php?t=47938 I used it this way and seems to be working: DLookUp("Max([NoteDate])","ACTIONNOTES","[ActionID]=[ActionIDb]") Thanks

Hello, thanks for your response. Unfortunately it does not work. As you don't use macros that much... any other work around?

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...

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!

Hello everyone Reviving this thread, this has been an issue for me as well. Moving all items as explained above does not work as it kills the purpose of having a Pivot Table. Let us know if any other way to remove the Grand Total Column. See picture of my example... having a Grand Total...

Hello Arnel, I tried actually a simpler way. I added extra fields to the "Contract Assignment" like VendorID and the dates, then I used a combination of queries: 1) fill out the new fields in the "Contract Assignment" 2) with this information complete a query that will match the ContractNumber...

Hello, The module created, does it need any specific name? I have tried it and it does not work.

Dear all, I have found a way utilizing Arnel's query and creating a 2nd one that updates the Assignment ID on the Cost Items table, this way the cost items are linked to the Contract Assignment table. Dear Arnel, I need 2 last tweaks to your query (Shown at the bottom): 1) Match the VendorID...

Dear Pat, Thanks, I have considered this, as a matter of fact take a look the image for the relationship and how I planned to relate the tables. The issue lies that I upload the database for the Cost Items and most of them do not have a contract yet hence those items will normally be omitted...

Dear all, thank you for the quick responses Seems to be working, will contact you if any issues. Best regards

Hi I am getting a syntax error with the following: UPDATE ([COST ITEMS] INNER JOIN [CONTRACT ASSIGNMENT] ON ([COST ITEMS].LOCATION = [CONTRACT ASSIGNMENT].LOCATION) AND ([COST ITEMS].COSTTYPE = [CONTRACT ASSIGNMENT].CONTRACTTYPE)) INNER JOIN [Contract List] ON [CONTRACT...

That's excellent, thank you again. Now one last thing, sometimes for the current contracts, the "ValidTo" date will be BLANK... is there a way to default blank ones to today's date on the query (Not on the table) so that it also updates them properly. Thanks!

Dear arnelgp, Well, I thought it was working ok but there is no reference to the validity that is on the [Contract List]. I would need this query to also reference to the "ValidFrom" and "ValidTo" dates on the [Contract List] in order to properly update it. Thanks again!

Dear arnelgp, That works marvellous! thank you for your help! I will try it and let you know if any issues. thanks,

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...