Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Unanswered: Please help me with my coursework

    hello guys im making a database on ms access for a DVD rental store.


    I have 2 problems which i cant overcome please help me

    my first problem is creating validation rules for my date/time field which will work on my form. So i want the computer to warn the user to input in dd/mm/yyyy format. How can i do this????

    Secondly, i have a querry which searches overdue DVDs. Although it works with no problems, i want the search to not show the DVDs which are returned that can be seen on the form as a box which i can mark ( a Yes/No field).

    I hope you guys can help me

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Topics to study:

    Input Masks
    Using AND with Criteria
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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