Search results

  1. B

    trying to display library books that are currently on loan

    i have a library system. Id like to make a query that displays all the books that are out on loan, i have a date returned column so if this is null then id like all the books with a null value to be displayed? just cant get it to work? also is there any way to send out a mail merge letter if a...
  2. B

    Table Relationships

    This is a simple video library database, 1 member can have many loans, 1 video can have many loans and 1 loan can have many videos, so with that in mind woud anyone be able to make my relationships right? because at the moment you cant take out more than one video on each loan? thanks in advance
  3. B

    passwording a command button

    ive had a play around with user permissions in access and cant get it to work so i was wondering if it was possible to make a user enter a password when entering a command button? as my command buttons open forms for data entry etc. it is a library system and there is the manager and assistant...
  4. B

    need some basic help please

    Hi im desperate for some help with access and would be grateful if anyone can help. I have a table with member information such as ID, postcodde, phone number and date of birth, what i want is for the age to be calculated automatically, how would i do that? thanks.
Back
Top Bottom