Search results

  1. V

    Limiting Rows By Given Number In Continuous Form

    :) I guessed what did you meant .... Yes you're quite right.... I was on a hurry and didn't read the option text... Now i make it as default, if I'll need i can make it from a query Thanks!
  2. V

    Limiting Rows By Given Number In Continuous Form

    Thanks vbaInet for the suggestion 1. Which one to use then from join Property, 1, 2, 3 2. OK I'll Remove the SumAll from the table and will do it from query or Expression Thank You very much for your help!
  3. V

    Building New Database!

    Hello Dear Friends! I'm Building New (Office Assets) Database from the very beginning, and your Help, Suggestions, Opinions and Ideas about this will be highly appreciated... I Created a Tables and please look at it and suggest if something is incorrectly or is not well normalized. Greatest...
  4. V

    Limiting Rows By Given Number In Continuous Form

    Hello vbaInet Here is my new test database. please check it and suggest me if something is not correct (Table normalization, relationship) Thanks Advanced By the way i can create a new thread for this new test database Just for suggestions
  5. V

    Limiting Rows By Given Number In Continuous Form

    Hello VbaInet The Quantity is counting and giving me a Total Sum for example: (Unitprice * Quantity = SumAll Giving a result) I think that it is a normal
  6. V

    Limiting Rows By Given Number In Continuous Form

    This is a new database, I have not the records, I'm building it and testing... No I'm not sure :) I can make it unbound if you suggest it.......
  7. V

    Limiting Rows By Given Number In Continuous Form

    Quantity is not an unbound text-box It is bound text-box based on a table
  8. V

    Limiting Rows By Given Number In Continuous Form

    Yes Quantity is Bound with the field :)
  9. V

    Limiting Rows By Given Number In Continuous Form

    I know that, After Delete Confirm event occurs after the user confirms the deletions and the records are actually deleted or when the deletions are canceled... But my problem is another thing not the deleting the records!
  10. V

    Limiting Rows By Given Number In Continuous Form

    I read it carefully but nothing Important for me there
  11. V

    Limiting Rows By Given Number In Continuous Form

    I never used that event before and why should to use it now?
  12. V

    Limiting Rows By Given Number In Continuous Form

    You Mean On Delete Event
  13. V

    Limiting Rows By Given Number In Continuous Form

    Buttons On Click Event
  14. V

    Limiting Rows By Given Number In Continuous Form

    It deletes the record if i click on it without any problem! it is working perfectly I just needed to add such command to that button in "Else" which would change Quantity to that product
  15. V

    Limiting Rows By Given Number In Continuous Form

    vbaInet What do you mean... On the Sub-Form I have button which is deleting the record, then it tried to add the function which would change quantity like: Me.Quantity = Me.Quantity - 1 something like that
  16. V

    Limiting Rows By Given Number In Continuous Form

    Thanks vbaInet for your help I have one Question near this... On that sub-form i added a command button which is deleting the record, everything is OK, I played with is, but without any goals.. I wanted when the record from the sub-form is deleted, the Quantity must changed automatically (If I...
  17. V

    how delete current record

    Hello Bob I have very strange question about MsgBox Is it possible that the text which is in MSG box ("Do you wish to delete this record?") use from table (If I create a table with warning and with alert messages) I'm asking this question because My Language is Not Supported by VBA and I can't...
  18. V

    Limiting Rows By Given Number In Continuous Form

    1. I replaced Me.Quantity with Nz(Me.Quantity, 0). It's Ok 2. I copied The same code into the After Update event of the main form, but does nothing... Is it Because I'm hiding (Minimizing, Maximizing) the form by a command button, here is my Code: If Me!cmdShow.Caption = "Show >>" Then...
  19. V

    Limiting Rows By Given Number In Continuous Form

    Great Work vbaInet But it need some modifications For example when i'm going to a new record it gives me an error (Error, Because when going to new record the quantity off course is empty, I can put 0 as default value for Quantity and it will stop that error). There are also one thing: When I...
  20. V

    Limiting Rows By Given Number In Continuous Form

    Thanks For the reply vbaInet OK, But It will work generally it will be limited to 5 for all the records, I needed that it to be limited according to the Quantity
Back
Top Bottom