Navigation

3/28/2014

Using Count in Access report

In a Microsoft Access report, want to have numbered list, list with count along side of the items:


& IIf([Count_var]=Count(*),"  ",", ")

Define a text box Count_var, with Control Source =1, and Running Sum "Over Group"
















3/21/2014

Encore Search Box

Directions for installing Encore search box:  (Innovative Interfaces OPAC)


<script type="text/javascript">
   function searchEncore(){
        var encoreBaseURLInput,encoreBaseURL, searchInput, scopeInput, searchString, scopeString, locationHref, charRegExString, base64Regex;
       /*base64_encoding_map includes special characters that need to be
        encoded using base64 - these chars are "=","/", "\", "?"
        character : base64 encoded */
        var base64_encoding_map = {"=":"PQ==", "/": "Lw==", "\\":"XA==", "?":"Pw=="};

        var escapeRegExp = function(string) {
            return string.replace(/([.*+?^=!:${}()|\[\]\/\\])/g, "\\$1");
        }
       encoreBaseURLInput = document.getElementById("encoreBase");
       searchInput = document.getElementById("encoreSearchInput");

        if (searchInput && encoreBaseURLInput) {
            encoreBaseURL = encoreBaseURLInput.value;
            searchString = searchInput.value;
            for(var specialChar in base64_encoding_map) {
                charRegExString = escapeRegExp(specialChar);
                base64Regex = new RegExp(charRegExString, "g");
                searchString = searchString.replace(base64Regex, base64_encoding_map[specialChar])
            }
            searchString = encodeURIComponent(searchString);

            scopeInput = document.getElementById('encoreSearchLocation');

            if (scopeInput) {
                scopeString = scopeInput.value;
            }

            if (scopeString) {
                scopeString = encodeURIComponent(scopeString);
                locationHref = encoreBaseURL + "C__S" + searchString + scopeString +  "__Orightresult__U";
            } else {
                locationHref = encoreBaseURL + "C__S" + searchString + "__Orightresult__U";
            }
   
   languageSetting = document.getElementById("encoreLanguage");
   
   if (languageSetting) {
    locationHref = locationHref + "?lang=" + languageSetting.value;
   }
   
            window.location.href = locationHref;
        }
        return false;
    }
</script>
 
 
 
 
 
For Classic WebPAC:
 
 
<form style="padding-top: 15px;" action="http://columbo.law.cua.edu/search/~" method="get" name="quicksearch2" target="_blank" id="quicksearch2">
<select name="searchtype" >
<option value="X">Keyword</option>
<option value="t">Title</option>
<option value="a">Author</option>
<option value="d">Subject</option>
         </select> 
 
<input type="text" name="searcharg" style="font-size: 10pt;" size="35" maxlength="250" id="searcharg1" /> 
<input type="hidden" value="A" name="SORT" />
<input type="submit" value="Find It!"  /> 

</form>

Kiosk PC, OPAC only

Using directions from IUG:



We lock down IE's Internet options with a simple reg hack:

-----------------------IE5Restr.reg--------------------
REGEDIT4

[HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Restrictions]
NoBrowserOptions"=dword:00000001

-------------------------------------------------------

You can also restrict other aspects of IE (NoBrowserClose, NoBrowserContextMenu,
NoBrowserSaveAs, NoFavorites, NoFileNew, NoFileOpen, NoFindFiles, NoTheaterMode,
NoSelectDownloadDir). The "1" in the entry above means it's enabled - use a "0" to disable it and
allow Browser Options.

It takes all of a couple of minutes.
Reg files for enabling and disabling various options are below.




-----------------------IE5Restr.reg--------------------

REGEDIT4

[HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Restrictions]
"NoBrowserClose"=dword:00000000
"NoBrowserContextMenu"=dword:00000001
"NoBrowserOptions"=dword:00000001
"NoBrowserSaveAs"=dword:00000000
"NoFavorites"=dword:00000000
"NoFileNew"=dword:00000001
"NoFileOpen"=dword:00000000
"NoFindFiles"=dword:00000001
"NoSelectDownloadDir"=dword:00000000
"NoTheaterMode"=dword:00000001


This file ENABLES the restrictions, the one below DISABLES them:


-----------------------IE5NoRestr.reg--------------------

REGEDIT4

[HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Restrictions]
"NoBrowserClose"=dword:00000000
"NoBrowserContextMenu"=dword:00000000
"NoBrowserOptions"=dword:00000000
"NoBrowserSaveAs"=dword:00000000
"NoFavorites"=dword:00000000
"NoFileNew"=dword:00000000
"NoFileOpen"=dword:00000000
"NoFindFiles"=dword:00000000
"NoSelectDownloadDir"=dword:00000000
"NoTheaterMode"=dword:00000000