Search results

Hi @June7, yes the purpose is to set the DefaultValue only to new records and not modify current records and this seem to be the behaviour when opening the form for an existing record and editing the record. Can you expand on the meaning of ‘the value should show when edit is started…’...

The table has only 1 record which values may change once a year I have a different form to update that record. This is purely to have a default value every time a new record is added in payslip table

I have tried this but is not returning the negative value on the form when is opened

Hi @Gasman, Apologies I modified the DB to the minimum. I have a Maximise purely to make it fit to the screen of my device, I am aware changing device the formatting is all wrong. With the code =DCount("[IDDuty]","[tblSwaps]","[DutyDateNew] = #" & Format([DutyDate].[Value],"mm/dd/yyyy") & "#")...

@Gasman I have attached a a version of the DB, with some data for the example From the frmMain you can open a current duty or create a new one In simple the IcoSwap is to highlight if any new duty created is a consequence of a swapped duty, the table swaps contain information of any date the...

When I corrected the code to =IIf([SwapCheck]>0,DCount("[IDDuty]","tblSwaps","[DutyDateNew] = #" & Format([DutyDate].[Value],"mm/dd/yyyy") & "#"),0) the below comes up

:eek: I corrected the code =IIf([SwapCheck]>0,DCount("[IDDuty]","[tblSwaps]","[DutyDateNew] = #" & Format([DutyDate].[Value],"mm/dd/yyyy") & "#"),0) and getting the error #Type!

Thanks @theDBguy @Pat Hartman @Gasman @LarryE Thanks for the explanation and it makes sense to use on Current The code for adding a record is: Private Sub CmdAdd_Click() DoCmd.OpenForm "frmDuties", acNormal, "", "", acAdd Forms!frmDuties!CmdEdit.Visible = False...

Thanks this seems to work. However I have now an error when I am adding a new record. The SwapCheck text box has the below code within the Control Source =DCount("[IDDuty]","[tblSwaps]","[DutyDateNew] = #" & Format([DutyDate].[Value],"mm/dd/yyyy") & "#") When the form is open as a new record...

Yes ad when the form is opened if the SwapCheck has a value greater than 0 then is when the icon becomes visible, there won’t be any changes in the opened form that may change the criteria

They are two different icons and two different events The icon notes works fine, I need to add the IconSwap to the Form Load with the criteria SwapCheck being greater than 0. Hope this makes sense

I have a form with a text box SwapCheck if the value of this text box is grater than 0 I need an image IcoSwap to be visibile, I am trying to place the code in the control source of IcoSwap put struggling with the code to be placed. I have another icon which becomes visibile with the below...

Thanks @arnelgp @theDBguy @MajP for the various solutions, moving on with the project and I am sure I will be back asking more advise!!!

Yes I do have the subform linked with autonumber and that works perfectly. What I need is to avoid the user to type the date OrderDate field in the subform, the user types the time (or I might move the Room field order) once this is filled in via an After update I woul like to the OrderDate to...

As part of a wider project I am trying to figure out how to copy the value from a field from a primary table into a field into a secondary table within a relationship one-to-many. Basically on entering the date in the primary table as soon as one or more records are added in the secondary table...

That i really weird as still not working, could it be some setting on my access?

Thanks for this, much appreciated!!

Hi, looking at the screenshot it is exactly what I am looking for, however I downloaded your example and when opening the TaxesDataSheet I get the below result

The From and To criteria works perfectly, but I believe the DSum is not returning the correct results, below is the manual calculation I checked and displayed in Field1 Any thoughts?

Thanks for the help with this. I still not sure of the formula to be places in the field control source to have the sum of tax starting by From to PayslipDate