MsAccess - Update Parent Form with Sub Form Control References

แชร์
ฝัง
  • เผยแพร่เมื่อ 28 ม.ค. 2025

ความคิดเห็น • 12

  • @bumpersmith
    @bumpersmith ปีที่แล้ว +3

    Thanks for the new video. Nice to see you back. It's been awhile.

  • @darray7472
    @darray7472 ปีที่แล้ว +1

    Good to see you again!
    I love Access, but I use it much less than I used to.
    Power BI is what most analysts want to use here in the US.

  • @ticdlga
    @ticdlga ปีที่แล้ว +1

    You save me again Mr., great video! Thanks a lot, regards!

  • @pythonstatistical4105
    @pythonstatistical4105 9 หลายเดือนก่อน +1

    Thanks for this exactly what I need!

  • @melvynshepherd1910
    @melvynshepherd1910 5 หลายเดือนก่อน

    I am fairly new to access, how would this work when the control on the Parent form is on a different table, such as OrderTotal which is the sum of Subform records Total

  • @RungeCarl
    @RungeCarl ปีที่แล้ว +3

    Always enjoy your videos. Great production but please ue more ZOOM so we can see your syntax

  • @ledahbernardi1070
    @ledahbernardi1070 11 หลายเดือนก่อน +1

    Hi, great explanation, tks. Do you have any video, teaching how to display a button on the last register of the subform? I need a [Save] button, visible, only on the last register, on the subform. Thanks, again, for the great explanation.

    • @codekabinettcomen
      @codekabinettcomen  11 หลายเดือนก่อน +1

      There is no video about that.
      But you can check for the last page of a tab control with code similar to this:
      Me.YourButton.Visible = (Me.YourTabControl.Value = Me.YourTabControl.Pages.Count - 1)
      The YourTabControl_Change event would be a good location to check for this.

    • @ledahbernardi1070
      @ledahbernardi1070 11 หลายเดือนก่อน +1

      @@codekabinettcomen thanks a lot, I´ll try that.

  • @abdulhamidalhaddadi2255
    @abdulhamidalhaddadi2255 ปีที่แล้ว +1

    Thank you sir

  • @SAMYTAHER
    @SAMYTAHER ปีที่แล้ว

    thank you
    We need
    I need code that will compare two different databases (ACCDB split database)
    The purpose is to update the old customer database with new updates without deleting the old database data
    The tasks of the codes are:
    * If a table exists in the new database and does not exist in the old database, a copy will be made
    * It compares the fields for you table in the event that a field is found that does not exist in the old database, it creates the right
    * It compares the properties of the fields for each field and the properties of the fields in the old database are modified
    * Modifies the relationships between tables to be like the relationships in the new database