By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,221 Members | 1,206 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,221 IT Pros & Developers. It's quick & easy.

Video library database

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
Nov 12 '05 #2

P: n/a

"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
Nov 12 '05 #3

P: n/a
Much obliged for your help.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.