www.thenelson.name


CURRENT FILES LIST:

You are free to use these files in your database provided you do not change or remove any copywrite notices.

The use of these files are free but donations are welcome and will help support this web site and the further development of these files and more files like them. A donation will also provide you with support.  Once you have made a donation, you may ask questions via nelson <at> thenelson <dot> com.


Check For Updated Front End    Suggested donation $5     www.thenelson.name/#CheckForUpdatedFe
This database
  • Checks for a newer copy of the front end placed in one location,
  • downloads the front end if it is newer,
  • then runs the front end and closes itself.
  • By creating a shortcut to this database, this is all transparent to the user.
  • You can upload an update at any time -- no need for the users to get out of the database.
    • Save backup, decompile, compile batch file    Suggested donation $5     www.thenelson.name/#Decompile
    This batch file will do the following to your database (I frequently use this several times a day while programing):
  • Create a date/time stamped Zip backup (I have every version of mine I made for the last 4 months).
  • Decompile
  • Compact
  • Recompile
  • Compact
    • Change Link To the Backend Demo    Suggested donation $10     www.thenelson.name/#LinkBeDemo
    This sample database provides automatic and manual linking to the backend.
  • If the front end does not find the backend, it will relink to a location you specify.
  • It also has a form to browse or search for the backend and manually change it.
    • When I am doing coding or troubleshooting, I link to a different copy of the backend to reduce the chance that I accidentally change the real data.
    Log Errors Demo    Suggested donation $20     www.thenelson.name/#LogErrorsDemo
    A great (if I may strut a little here) set of error logging routines.
    The features:
  • Error logging to a table with date/time, number/description, module/procedure and additional debugging info.
  • Optionally display an error message with optional request for activity description from the user.
  • Optionally send an email.
  • Optionally close the database after the error.
  • A problem reporting form so users can report problems that do not cause errors.
  • A form to display errors sorted by most problematic which will jump to the error causing code with a double click
  • Debug mode which turns off logging and turns on the default Access debug dialog.
    • Imbedded Image Demo    Suggested donation $5     www.thenelson.name/#ImbededImageDemo
    This sample databases stores images within Access.
    It is ok to do this for very small images such as icons but it will rapidly bloat the database to unusable size if used for larger images.The database has two forms: a continuous form displaying small images and a single record form displaying large images that has code to insert an image stored on disk. The database also discusses the OLE memory bloat problem and ways to avoid it.
    Linked Images Demo    Suggested donation $5     www.thenelson.name/#LinkedImagesDemo
    This sample databases links to images stored outside of the database.
    This is the preferred method because Access is not good at storing images within it:
    Interface With the Internet Demo    Suggested donation $10     www.thenelson.name/#WebAccess
    This sample database will show you how to transfer information to and from the internet using: The Web Browser control, Internet Explorer Automation and FTP - File Transfer Protocol. It also contains many functions useful for interfacing with the internet.
    Simplified Login Demo    Suggested donation $10     www.thenelson.name/#Login
    A simple login/password routine with independent login and unlimited users.
    Easier to setup than User Level security (but also less secure).
    Report Form Tricks    Suggested donation $5     www.thenelson.name/#ReportFormTricks
    Contents of the database
  • Add "All" or "None" in a combobox
  • Sizable Checkboxes
  • Bulleted Paragraphs
  • Combining MS Word & Access
  • Right Align List Combo
  • Simulate Tabs with Page Breaks
  • Simulate Combobox with a Popup Subform
  • Form or report with Watermarks
  • More Than 4 Conditional Formats
  • Open Last Record
  • Changing Combobox
  • Select checkboxes using collection
  • Highlight the changes in a field
  • Check for required items
  • Fill a listbox rowsource using code
  • Lookup form, report names and descriptions
  • Even column lengths with Down then Across on a report
  • Report Footer at bottom of page
  • Highlight text
    • Customizable Report    Suggested donation $5     www.thenelson.name/#CustomizableReport
    This database contains two forms. They both will allow a user to control which fields are displayed in a report. One modifies your report to display the columns selected by the user. Your report will have to be formatted in specific ways as explained in the form. This form is easier to use than the second form. The second form builds a report using the structure of the continuous form in the form as a template. It shows you how to build a report using code and it also shows you how to use checkboxes for selecting records in a continuous form without storing the value of the checkbox in a table.
    Shift Bypass Functions    Suggested donation $5     www.thenelson.name/#ShiftBypassDemo
    Contents of the database
  • Links to utilities to enable/disable shift bypass
  • Enable/disable shift bypass
  • Request a password with shift bypass.
  • Delete the database if shift bypass is enabled.
  • Simulate the shift bypass in a shortcut.
    • Parse Names and other string routines    Suggested donation $5     www.thenelson.name/#ParseNames
    Contents of the database
  • Routine to automatically parse names into
    • Title (Dr, Ms, etc),
    First name,
    Middle name,
    Last name,
    Pedigree (Jr, II, etc) and
    Degree(s) (MD, PhD, etc)
    Routine will optionally open manual parse name form if it cannot figure out the parsing.
  • Form to manually parse names
  • Additional useful string routines:
    StringBetweenStrings
    RemoveMultipleSpaces
    RemoveSpecialCharacers
    GetWord
    GetFirstWord
    GetLastWord
    GetWordNumber
    ReplaceNotInQuotes

    • Enhanced Lebans Month Calendar    Suggested donation $5     www.thenelson.name/#EnhancedCalendar
    Additional Features Added to Stephen Lebans excellent calendar API
    (http://www.lebans.com/monthcalendar.htm):
  • Open the calendar with 1, 2, 3, 6, or 12 months showing
  • Show the months before or after the selected date
  • Open the calendar at several selectable locations
  • Hide the properties and/or close window menu items
  • Add up to three custom menu items





    • 968