Easy shelf reading and weeding lists in access
Download
1 / 29

Easy Shelf Reading and Weeding Lists in Access - PowerPoint PPT Presentation


  • 71 Views
  • Uploaded on

Easy Shelf Reading and Weeding Lists in Access. David Lowder Georgia Southern University GUGM 2007. What is it?. This is a menu-driven shelflist program that's easy to copy into your Voyager reports.mdb so that it is automatically customized for your library's locations.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Easy Shelf Reading and Weeding Lists in Access' - vera-turner


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Easy shelf reading and weeding lists in access

Easy Shelf Reading and Weeding Lists in Access

David Lowder

Georgia Southern University

GUGM 2007


What is it
What is it?

This is a menu-driven shelflist program that's easy to copy into your Voyager reports.mdb so that it is automatically customized for your library's locations.

You pick the location and LC Class range from drop-down lists.

You have the option to specify a specific item status from a drop-down list and/or specify a minimum or maximum number of historical charges.

This lets staff run a variety of reports without having to know Access or how to modify queries.




You can add your username and password to the form
You can add your Username and Password to the form password

  • Open the gasou_UP_table

  • Replace the existing Username and Password with the Username and Password for your location

  • Close the table and the form is updated automatically





If you don t pick an ending class the list includes only the starting class
If you don’t pick an ending class, be edited if desired.the list includes only the starting class.


The item status comes from your item status type table
The item status comes from your be edited if desired.ITEM_STATUS_TYPE table.


Values for historical charges or publication year are optionally entered into the text boxes
Values for historical charges or publication year are optionally entered into the text boxes.


Information on the report
Information on the report optionally entered into the text boxes.

First letter is for the Bib and the second letter is for the MFHD

“*” would appear to the left of the call number


If there are no items that match the criteria the report will look like this
If there are no items that match the criteria, optionally entered into the text boxes.the report will look like this.


No item status criteria selected example
No Item Status Criteria Selected Example optionally entered into the text boxes.


Lost system applied example
Lost-System Applied Example optionally entered into the text boxes.


If no status is selected items with multiple statuses appear multiple times
If no status is selected, optionally entered into the text boxes.items with multiple statuses appear multiple times.


Items with a temporary location
Items with a temporary location optionally entered into the text boxes.


Example of bound with items
Example of “Bound With” Items optionally entered into the text boxes.

One item with one MFHD but multiple bibs


Installation
Installation optionally entered into the text boxes.

http://personal.georgiasouthern.edu/~dlowder/Shelf_list.mdb


Open your reports mdb database
Open your reports.mdb database. optionally entered into the text boxes.


Find where you downloaded the shelf list mdb and select it
Find where you downloaded the Shelf_list.mdb and select it. optionally entered into the text boxes.


Select the items to import
Select the items to import. optionally entered into the text boxes.

  • Select only the “gasou_UP_table” table

  • Select all of the queries

  • Select only the “gasou_SLmenu” form

  • Select the one report

  • Then click “OK”


The objects should all appear in your reports mdb
The objects should all appear in your reports.mdb optionally entered into the text boxes.


Details to consider
Details to consider optionally entered into the text boxes.

  • You can modify the report if you wish.

  • I’ve included the author field in the queries in case you want to add that to the reports.

  • You should have the Unicode module already in your reports.mdb but I have included it in case you need to import it.

  • The Unicode module is used for proper display of Unicode characters in the Title or Author fields.


You can also use this with non lc call numbers
You can also use this with non-LC call numbers. optionally entered into the text boxes.


Non lc call numbers
Non-LC call numbers optionally entered into the text boxes.

  • Must use “through” call number even if it is the same

  • Case sensitive


There is some Visual Basic used to select which query to run but you don’t need to know that. Basically the name of the query comes from which criteria are selected.


Questions
Questions? but you don’t need to know that. Basically the name of the query comes from which criteria are selected.


ad