Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    16

    Unanswered: Count record help

    I need to put a limit on the amount of items that can be purchased by each individual customer. i.e. it can't be anymore than 5 items purchased.

    All help much appreciated.
    Thanks in advance.

  2. #2
    Join Date
    Jan 2005
    Posts
    362

    Informations

    Give us more informations, you make a program in access at what language?
    Can you use a counter that counts the items before the insertion in database!?
    dimis

  3. #3
    Join Date
    Mar 2005
    Posts
    16
    I use Microsoft Access 2000, and am just doing it in the Access program itself, although any VB would be OK.
    I've already got all of the information in the database already as well. Ideally, I would like a subform to be imported into my main form with a count of the amount of orders on it.

  4. #4
    Join Date
    Sep 2003
    Location
    Birmingham, UK
    Posts
    121
    More info would be useful but you may want to try the 'RecordSetClone.RecordCount' function

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •