Recent content by babydave

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...

aha this works ;) thanks very much for the clarification and for bearing with me hehe.

if they did then theyd be equally good films :) please help me :(

i think that was my original plan but im open to any new ideas, basically i just want one loan ID to be able to hold information about multiple video ID's so someone could take out shrek, bruce almighty and zulu on one loan ID. cheers for replying

this is weird, 1 loan still cant have multiple videos. annoying :confused:

that was why i was confused :) thanks a lot.

if i remove video title number from the loan details table then where would the relationship from video table to loan details go? i have it setup now as you suggested and it makes sense, just confused about that one relationship now.

at the moment i have neither options setup :( if you'd be willing to setup the relationship how you suggested thatd be great

this might work

yep ken i think that would work, as they can only borrow 3 videos at a time and i need the system to be able to say how many they currently have loaned out so i can use a query to restrict them from taking out more than 3.

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

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...

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.