Recent content by nnoor

  1. N

    Problem wherecondition using And

    Thanks Friends it solved it was DoCmd.OpenForm "frmTeamsSelect", acNormal, , "[MatchNo]=" & Me.[MatchNo] & " And [mtID]=1", acFormEdit, acDialog Best Regards
  2. N

    Problem wherecondition using And

    Hello See Code below; Private Sub Winner_DblClick(Cancel As Integer) DoCmd.OpenForm "frmTeamsSelect", acNormal, , ("[MatchNo]=" & Me.[MatchNo] And "[mtID]=1"), acFormEdit, acDialog End Sub I am facing problem in where condition. when I pass single condition one by one it works ok but when i...
  3. N

    Question Quantity and price controlling

    ty Mr. jdraw, It seems I can work on my idea I will need a table for prices and get latest two prices by latest entered price using highest value of pk(autonumber) and HV-1 of related product. But disabling 2nd price when its stock ends is still unsolved. Logging each inventory transaction...
  4. N

    Question Quantity and price controlling

    Thank you for your answer. method you have suggested is better than mine idea. But then I have to some design changes accordingly. can u refer me to some link of price controlling design?
  5. N

    Question Quantity and price controlling

    Hello All, I was intermediate skilled in ms access 10 years ago. But in-between time all my work with access was limited to design some simple dbs. So u can say I am a little out of touch now and could be considered beginner. I was planning to design app for small general store. (limited to 3...
See more
Back
Top Bottom