Recent content by asol

  1. A

    Recordset adds new record into sub form but on save nothing added to table

    The problem was that I have linked the subform query to OrderID and forgot to add it so additional field fixed it. So it was adding new field but without OrderID thats why it did not show up in the subform as it was filtered out. 'Add Wastage value to flooring area section Private Sub...
  2. A

    Recordset adds new record into sub form but on save nothing added to table

    Mate I know what I am doing, and I also know that you dont add records to forms, if you do not have any solution for my problem than thanks for trying. There is no point of acting smart if you do not know the solution for the problem and start with demagogy.
  3. A

    Recordset adds new record into sub form but on save nothing added to table

    I need to add record to subform, and the value of that record depends on existing records in subform as well as values in parent form.
  4. A

    Recordset adds new record into sub form but on save nothing added to table

    Hi I am adding new record into subform via recordsetclone method. The problem is that record is added but on save it does not appear in the table. If add this record manual using subform everything works. When record added manually update of the record works fine. here is my code. 'Add Wastage...
  5. A

    Make field value static

    Have fixed the problem here is how. Thank for trying anyway. Option Compare Database Public rsqryPrice As Integer Option Explicit Private Sub ProductID_AfterUpdate() Dim qflPrice As Variant Dim db As DAO.Database Dim rs As DAO.Recordset Dim sqlQry As String Dim instID As...
  6. A

    Make field value static

    Lets say I modify my code this way Private Sub ExtrasID_Change() Dim extrID As Integer Static floorPrice As Integer Static sumPrice As Integer extrID = Me.ExtrasID.Value floorPrice = Me.flPrice.Value Select Case extrID Case Is = 1...
  7. A

    Make field value static

    I do understand it can be simplified but it is not the issue, I have declared floorPrice as static so that the its value doesn't change when I add 5, 10 or 15. The problems come out when I assign new value by making change to ExtrasID for some reason Me.flPrice.Value starts to accumulate values...
  8. A

    Make field value static

    Hello I am trying to add various values based on Select Case to the value of field. The problem I face is that each time when I get different Case in select statement, the value of the field rather changing adds the value on top. :banghead: Private Sub ProductID_AfterUpdate() Dim qflPrice...
See more
Back
Top Bottom