Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    11

    Unanswered: ms access problem

    Guys need help. How can I do this in Ms access
    My prof has assigned this project to us and im really not into access. i know a bit of it
    but im not good at it.
    Here's the prob.
    I have two textbox namely year of birth and number
    Now what I need to do is to count the number of user who enters the same birth year
    for example the user inputs 2004, 001 will automatically be displayed on the number textbox
    If on the next record the user will also input 2004, 002 will automatically be displayed
    on the number textbox. Now if on the next record the user will enter a different year example:
    the user enters 2005, 001 will automatically be displayed on the number textbox.
    How can i do this?Thanks and hope you can help me.

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Look at "DemoYearBirthA2000.mdb".
    Look at Table1, open Form1 and try.
    Attached Files Attached Files

  3. #3
    Join Date
    May 2006
    Posts
    11

    i cant add

    Quote Originally Posted by MStef-ZG
    Look at "DemoYearBirthA2000.mdb".
    Look at Table1, open Form1 and try.
    sir i cant add a new record..why?...
    i need to add a record..how can i do it with that sample mdb you have send me?

  4. #4
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Open Form1, go to the NEW REC, enter YearBirth (2000, or any), ENTER.

Posting Permissions

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