Free small library application now available for download

[Fred Boer]

Now Available!



Are you looking for an Access based application for managing your small
library or personal collection of books? Wishing you could find a cost-free
solution? If so, you might want to try "My Library" - an Access based
library management system now available for download. This program offers
library management and circulation modules, as well as an online catalogue.
Best of all. it's free! A link to download the application ".zip" file
(600k) and some screen shots are available here:



http://www3.sympatico.ca/lornarourke/fred.html



I am offering this application free of charge as a way of demonstrating my
gratitude to all of the kind and helpful experts who have aided me as I have
learned to enjoy working with Microsoft Access. I hope you find it useful!



Cheers,

Fred Boer





More information..



Features:



Circulation module: Check-Out; Check-In, Book Circulation history, Patron
Circulation history. Overdue report. Can be used with barcode scanner (Wedge
type, Code 3of9).



Library management module: Enter/edit patrons; Enter/edit book records;
allows for multiple authors and multiple subject headings per book.
Hyperlinks on the data edit form take you to public access points at the
Library of Congress and the National Library of Canada to search for
cataloguing information. Generate spine labels and barcode labels. Scan book
codes to generate book lists.



Online catalogue: Search for library materials using
Author/Title/Subject/Keyword or "Search by Form" search methods. Online
catalogue is linked to circulation system to show current availability of
book. Software is designed with network use in mind: put a copy of the
online catalogue on all workstations!



Customizable: Set your own loan period. Use your own image files as the
splash screen and on the main switchboard form. Set a custom application
title. Add your own quotes/jokes to the "Thought for the Day" displayed on
the main switchboard. (Every time the application opens a randomly chosen
quote/joke is presented; enter as many as you like!)



Requirements:



Access 2000 or greater.



Disclaimer:



Please be sure to read the "ReadMe.txt" file included in the download for
important information and various disclaimers I've stolen from other
applications that will tell you that I make no warranty of fitness or other
such thing. You use this software at your own risk!

 

[Dirk Goldgar]

Now Available!

Are you looking for an Access based application for managing your
small library or personal collection of books? Wishing you could find
a cost-free solution? If so, you might want to try "My Library" - an
Access based library management system now available for download.
This program offers library management and circulation modules, as
well as an online catalogue. Best of all. it's free! A link to
download the application ".zip" file (600k) and some screen shots are
available here:

http://www3.sympatico.ca/lornarourke/fred.html

I am offering this application free of charge as a way of
demonstrating my gratitude to all of the kind and helpful experts who
have aided me as I have learned to enjoy working with Microsoft
Access. I hope you find it useful!

Fred, that's a terrific gesture! And your description and screenshots
of the application look great. I salute you. <applause>

 

[Guest]

Alright Fred! Welcome to the club.

 

[Fred Boer]

Dear Dirk:

<blush>!
Thanks!

Cheers!
Fred

 

[Fred Boer]

Alright Fred! Welcome to the club.

Seems like a nice place! There aren't any dues, are there?

Cheers!
Fred

 

[Stephen Lebans]

No dues Fred...just a never ending stream of requests for tech support and
upgrades.<grin>

Fred have you looked at adding the capability to automate the scan/enter in
the UPC/ISBN and then go out to the public online Book databases to retreive
the mathcing info for the entered title? I've always wanted to do this for
my library at home. I've just never found the time to look into the
interfaces/API's avaialble to do this.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Jeff Conrad]

Looks great Fred, thanks for sharing with the Access community!
Love the Hyperlink ;-)

Do you mind if I post a link to this on my Resources page?:

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Jan Il]

Congratulations, Fred! I would also like to put a link to this on my new
website. I will have a section there for Access information for students
reference.

I'll be in contact off group. As Jeff said, thank you very much for sharing
this with the Access communities.

Very well done!

Jan
MS MVP - Windows IE/OE [DTS/AumHa]
Smiles are meant to be shared,
that's why they're so contagious.

 

[Fred Boer]

Hi Jeff:

I'd be happy if you posted a link! Thanks!

Cheers!
Fred

 

[Fred Boer]

Hi Jan:

Thank you! Please feel free to post a link... what's the url for your site?

Cheers!
Fred

Congratulations, Fred! I would also like to put a link to this on my new
website. I will have a section there for Access information for students
reference.

I'll be in contact off group. As Jeff said, thank you very much for
sharing this with the Access communities.

Very well done!

Jan
MS MVP - Windows IE/OE [DTS/AumHa]
Smiles are meant to be shared,
that's why they're so contagious.

Now Available!



Are you looking for an Access based application for managing your small
library or personal collection of books? Wishing you could find a
cost-free solution? If so, you might want to try "My Library" - an Access
based library management system now available for download. This program
offers library management and circulation modules, as well as an online
catalogue. Best of all. it's free! A link to download the application
".zip" file (600k) and some screen shots are available here:



http://www3.sympatico.ca/lornarourke/fred.html



I am offering this application free of charge as a way of demonstrating
my gratitude to all of the kind and helpful experts who have aided me as
I have learned to enjoy working with Microsoft Access. I hope you find it
useful!



Cheers,

Fred Boer





More information..



Features:



Circulation module: Check-Out; Check-In, Book Circulation history, Patron
Circulation history. Overdue report. Can be used with barcode scanner
(Wedge type, Code 3of9).



Library management module: Enter/edit patrons; Enter/edit book records;
allows for multiple authors and multiple subject headings per book.
Hyperlinks on the data edit form take you to public access points at the
Library of Congress and the National Library of Canada to search for
cataloguing information. Generate spine labels and barcode labels. Scan
book codes to generate book lists.



Online catalogue: Search for library materials using
Author/Title/Subject/Keyword or "Search by Form" search methods. Online
catalogue is linked to circulation system to show current availability of
book. Software is designed with network use in mind: put a copy of the
online catalogue on all workstations!



Customizable: Set your own loan period. Use your own image files as the
splash screen and on the main switchboard form. Set a custom application
title. Add your own quotes/jokes to the "Thought for the Day" displayed
on the main switchboard. (Every time the application opens a randomly
chosen quote/joke is presented; enter as many as you like!)



Requirements:



Access 2000 or greater.



Disclaimer:



Please be sure to read the "ReadMe.txt" file included in the download for
important information and various disclaimers I've stolen from other
applications that will tell you that I make no warranty of fitness or
other such thing. You use this software at your own risk!

 

[Fred Boer]

Dear Stephen:

No dues Fred...just a never ending stream of requests for tech support and
upgrades.<grin>

Fred have you looked at adding the capability to automate the scan/enter
in the UPC/ISBN and then go out to the public online Book databases to
retreive the mathcing info for the entered title? I've >always wanted to
do this for my library at home. I've just never found the time to look
into the interfaces/API's avaialble to do this.

That would certainly be a most desireable feature! Institutions like the
Library of Congress and the National Library of Canada provide web pages
that display the full MARC Cataloguing data for their materials. Doug Steele
has shown me how to use an OCX Web Browser control to "scrape" this
cataloguing data from the web page.

However, creating the process you describe is beyond my skill set! If I am
not mistaken, professional library software offers this type of feature, and
I believe that the Z93.50 standard provides a
protocol for this. But that's as far as my knowledge goes. This is, however,
something I am eager to learn more about, and I plan to take a shot at it as
time permits. I'll let you know if I make any progress!

Cheers!
Fred

 

[Stephen Lebans]

I'd be willing to work with you on this Fred.
I'll spend some time browsing to see what is out there already. Most
solutions already exist in one form or another.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Nancy Ward]

Thank you very much, Fred. I'm learning Access, but more than that, I have
an extensive library of books, both on writing and computers. This will be
quite helpful.

 

[Jeff Conrad]

It's listed in the Tutorial section now Fred:

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Tutorial

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Tony Toews]

I believe that the Z93.50 standard provides a
protocol for this

Correct. that is the protocol. However that is an ugly binary
protocol. Highly efficient in the number of bytes sent and fetched
mind you.

I looked at it once for an app I was thinking of building and almost
got a real simple query working in that protocol. I thought about it
a bit and decided I just didn't want to spend the effort right then
and there to get it running smoothly.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

I believe that the Z93.50 standard provides a
protocol for this. But that's as far as my knowledge goes.

BTW the capability I really wanted to add to my app was to be able to
select the authors in my collection which were my preferred authors.
Then have the app hit a few such servers and locate all books by that
author and download all those. Then I'd ignore the big print, audio
cassette and other such editions.

Finally I'd download an abbreviated version of the books I had and was
looking for so when I hit a used book store in my travels I could
easily see if I had a book in my collection or if I wanted it.

Do you know just how many duplicate books I have? And just how many
times I've said to myself "I'm sure I have that book." And left it
there on the shelf. <smile>

Tony (Why, yes, books are a big vice of mine. Why do you ask?)
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Jan Il]

Hi Jan:

Thank you! Please feel free to post a link... what's the url for your
site?

Thanks Fred! I'm just now getting it going, it is still in the propagation
stage, as I was finally able to get it fully activated with the new
nameservers just yesterday (a problem with the new webhost getting the new
nameservers activated properly), but, I am starting to put together my
layout and reference materials to start the 'construction' as we speak.

My website is http://datacomptech.com/ All that is there at the moment is
the default page, but, it's a start, and now that I have started my own
business again it will be a need for sure. Part of my MS Office training
programs is in Access, so I will have a section there dedicated to various
types of Access apps, with lots of links to various examples, tips and
tutorials. Your Library app will be a very good reference, and I would be
most happy to post links for other developers here who might like also to
share examples (demos) of their work, tips and expertise as well.

Jan
MS MVP - Windows IE/OE [DTS/AumHa]

Cheers!
Fred

Congratulations, Fred! I would also like to put a link to this on my new
website. I will have a section there for Access information for students
reference.

I'll be in contact off group. As Jeff said, thank you very much for
sharing this with the Access communities.

Very well done!

Jan
MS MVP - Windows IE/OE [DTS/AumHa]
Smiles are meant to be shared,
that's why they're so contagious.

Now Available!



Are you looking for an Access based application for managing your small
library or personal collection of books? Wishing you could find a
cost-free solution? If so, you might want to try "My Library" - an
Access based library management system now available for download. This
program offers library management and circulation modules, as well as an
online catalogue. Best of all. it's free! A link to download the
application ".zip" file (600k) and some screen shots are available here:



http://www3.sympatico.ca/lornarourke/fred.html



I am offering this application free of charge as a way of demonstrating
my gratitude to all of the kind and helpful experts who have aided me as
I have learned to enjoy working with Microsoft Access. I hope you find
it useful!



Cheers,

Fred Boer





More information..



Features:



Circulation module: Check-Out; Check-In, Book Circulation history,
Patron Circulation history. Overdue report. Can be used with barcode
scanner (Wedge type, Code 3of9).



Library management module: Enter/edit patrons; Enter/edit book records;
allows for multiple authors and multiple subject headings per book.
Hyperlinks on the data edit form take you to public access points at the
Library of Congress and the National Library of Canada to search for
cataloguing information. Generate spine labels and barcode labels. Scan
book codes to generate book lists.



Online catalogue: Search for library materials using
Author/Title/Subject/Keyword or "Search by Form" search methods. Online
catalogue is linked to circulation system to show current availability
of book. Software is designed with network use in mind: put a copy of
the online catalogue on all workstations!



Customizable: Set your own loan period. Use your own image files as the
splash screen and on the main switchboard form. Set a custom application
title. Add your own quotes/jokes to the "Thought for the Day" displayed
on the main switchboard. (Every time the application opens a randomly
chosen quote/joke is presented; enter as many as you like!)



Requirements:



Access 2000 or greater.



Disclaimer:



Please be sure to read the "ReadMe.txt" file included in the download
for important information and various disclaimers I've stolen from other
applications that will tell you that I make no warranty of fitness or
other such thing. You use this software at your own risk!

 

[Fred Boer]

Dear Stephen:

That is a very kind offer, thank you! I will also begin doing some
research...

Fred

 

[Fred Boer]

Dear Tony:

Why, yes, books are a big vice of mine. Why do you ask?)

Not a vice. A virtue!!

All the best!
Fred

 

[John Vinson]

Now Available!

Impressive, Fred! Just now got time to download it, I'll be looking it
over.

Thanks for the wonderful gesture of making this freely available! I've
bookmarked the site.

John W. Vinson[MVP]