Video library database

[Waldot]

We are trying to implement a video library at work for a series of
training videos. Our employees will contact us by email requesting a
videotape which we will ship out by Fedex for a period of 30 days. We
already have properly linked tables with all employees, offices, etc.,
so that part of the job is done.

What I need help with is the check-out check-in functionality.
Ideally, I would like to be able to track the number of copies of tape
in stock and to put people on a waiting list for tapes that are out of
stock.

I'm sure that plenty of people have done this in the past. I even saw
a reference to an old Access 97 template, but I can't seem to find it.
Any ideas or examples would be greatly appreciated.

[Pieter Linden]

wt********@hotmail.com (Waldot) wrote in message news:<87**************************@posting.google. com>...

We are trying to implement a video library at work for a series of
training videos. Our employees will contact us by email requesting a
videotape which we will ship out by Fedex for a period of 30 days. We
already have properly linked tables with all employees, offices, etc.,
so that part of the job is done.

What I need help with is the check-out check-in functionality.
Ideally, I would like to be able to track the number of copies of tape
in stock and to put people on a waiting list for tapes that are out of
stock.

I'm sure that plenty of people have done this in the past. I even saw
a reference to an old Access 97 template, but I can't seem to find it.
Any ideas or examples would be greatly appreciated.

There's an example in Access 2000 Power Programming, by Scott Barker
(SAMS publishes it, I think.) Check in/out... I would create loan
records for each time a person borrows a tape.

(BorrowerID, TapeID, ShipDate, ReturnDate)
TapeID - each tape has a unique identifier. Autonumber is fine - it
just has to refer to ONE copy of a tape. You should probably read
Albert Kallal's notes on reservation systems, because that's what this
sounds like.

[Sigurd Bruteig]

"Pieter Linden" <pi********@hotmail.com> skrev i melding
news:bf**************************@posting.google.c om...

wt********@hotmail.com (Waldot) wrote in message

news:<87**************************@posting.google. com>...

We are trying to implement a video library at work for a series of
training videos. Our employees will contact us by email requesting a
videotape which we will ship out by Fedex for a period of 30 days. We
already have properly linked tables with all employees, offices, etc.,
so that part of the job is done.

What I need help with is the check-out check-in functionality.
Ideally, I would like to be able to track the number of copies of tape
in stock and to put people on a waiting list for tapes that are out of
stock.

I'm sure that plenty of people have done this in the past. I even saw
a reference to an old Access 97 template, but I can't seem to find it.
Any ideas or examples would be greatly appreciated.

There's an example in Access 2000 Power Programming, by Scott Barker
(SAMS publishes it, I think.) Check in/out... I would create loan
records for each time a person borrows a tape.

Download from
http://www.samspublishing.com/isapi/product_id~{81830F60-AE2C-4C78-93C8-4F64DB967084}/selectDescTypeId~{5F7BB313-BBC4-4A9E-A577-562A760FE491}/st~39FD6D3C-D978-4664-A506-94F86D5E0028/session_id~{54CE68BD-1813-48FB-8F14-65995CCF49E9}//content/images/0672321025/downloads/code.zip

Sigurd

[Waldot]

Much obliged for your help.