Having fun with Access - just chatty...

F

Fred Boer

So here I am, doing a long, long overdue weeding of the whole library
collection. I have a *huge* stack of books; I need to locate them in my
catalogue and mark each title as "Discarded". So, off I go, whistling while
I work (which got me a stern reprimand from a studying student...): use the
"Find" button, type in some of the title or the book ID, find the book,
click the mouse and make the change. Dull..and a bit too slow. And suddenly
a light went off! I thought, "Hey, I bet I could make a simple form with a
combobox, and put in some code to make the change for me. Boom! Create a
query, create a form, plop on a combobox, add a line of code, and SHAZAM!
I'm entering book ID numbers and Access is finding them, and marking them as
discarded, and the whole process of creating this query, form, and code took
about *4 minutes*. Ended up saving me hours of time...!

Just like that, a quick temporary form which allowed me to work so much
faster. Sometimes it is just so much fun working with Access, that I can't
believe it! Of course, that's when things go well! <g>

Anyway, that's all, just a little story I thought I'd share with other
Access users! Ok. Back to work!

Cheers!
Fred Boer
 
D

Dirk Goldgar

Fred Boer said:
So here I am, doing a long, long overdue weeding of the whole
library collection. I have a *huge* stack of books; I need to locate
them in my catalogue and mark each title as "Discarded". So, off I
go, whistling while I work (which got me a stern reprimand from a
studying student...): use the "Find" button, type in some of the
title or the book ID, find the book, click the mouse and make the
change. Dull..and a bit too slow. And suddenly a light went off! I
thought, "Hey, I bet I could make a simple form with a combobox, and
put in some code to make the change for me. Boom! Create a query,
create a form, plop on a combobox, add a line of code, and SHAZAM!
I'm entering book ID numbers and Access is finding them, and marking
them as discarded, and the whole process of creating this query,
form, and code took about *4 minutes*. Ended up saving me hours of
time...!

Just like that, a quick temporary form which allowed me to work so
much faster. Sometimes it is just so much fun working with Access,
that I can't believe it! Of course, that's when things go well! <g>

Anyway, that's all, just a little story I thought I'd share with other
Access users! Ok. Back to work!
Click to expand...

Thanks for sharing that, Fred. Isn't it great when you can really put
the power of Access to work for you?

Now, I hope you saved that "temporary" form and query so that you can
use it again, the next time you need to do a little pruning. Do they
call that "deaccessioning", or is that just a myth?
 
F

Fred Boer

Hi Dirk:
Do they call that "deaccessioning", or is that just a myth?
Click to expand...

Yes, that is true. However, as a professional librarian with a Master's
Degree in Library and Information Science I prefer to use the more technical
description: "Tossing the junk in a dumpster...".

Cheers and Happy Thanksgiving to you and yours!
Fred

P.S. Here's another professional librarian tip: Toss weeded materials in the
dumpster really early in the morning, 'cause nothing gets people riled up
faster than seeing books tossed out... (but true librarians know that is
absolutely necessary sometimes!)
 
A

Arvin Meyer [MVP]

P.S. Here's another professional librarian tip: Toss weeded materials in the
dumpster really early in the morning, 'cause nothing gets people riled up
faster than seeing books tossed out... (but true librarians know that is
absolutely necessary sometimes!)
Click to expand...

Grrrr!

But true collectors know there isn't any such thing as junk. My brother
is/was a librarian at a large public system which would have a 10¢ sale
several times a year before throwing out the "junk". My library includes
hundreds of them.

Where's your dumpster, I feel the need to do some diving. <g>
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
F

Fred Boer

See what I mean? ;)

Dear Arvin:

In the past I have done various things, including 10 cent book sales - even
"take them for free" - but in my experience it was a waste of time. The
books I am tossing can't even be *given* away! However, I suspect that there
is little chance of convincing a true book lover, such as yourself, so I
promise the next time I weed, I'll drop you a line and give you dibs on
whatever you might like!

Happy Thanksgiving!
Fred
 
T

Tony Toews

Fred Boer said:
Hi Dirk:


Yes, that is true. However, as a professional librarian with a Master's
Degree in Library and Information Science I prefer to use the more technical
description: "Tossing the junk in a dumpster...".
Click to expand...

Weeding is another term I've heard.
P.S. Here's another professional librarian tip: Toss weeded materials in the
dumpster really early in the morning, 'cause nothing gets people riled up
faster than seeing books tossed out... (but true librarians know that is
absolutely necessary sometimes!)
Click to expand...

Nah, you hold book sales twice a year. And tell everyone that
whatever doesn't get purchased gets recycled.

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
 
Top