Look 2 Consulting, LLC www.Look2Consulting.com Look2 Volunteer Software - Revision History This is just a brief listing of what's new in each version of the software. Please refer to the User Manual for further documentation on any new features. ================================================================================= Rev: 3.0.z Main Update Summary: 1 - Customizable text field for Volunteer Profile auto-added to database 2 - Tablets without keyboards better supported 3 - New Profile first prompts for phone number (checks for existing) ----------------------------- Miscellaneous, Minor Changes: 3.0.1 (6/25/24) - Profile screen layout changed - Report Screen combo auto-dropdown on gaining focus - Main Screen layout adjusted (stats, button spacing, misc. text) - Sign In/Out screen layouts adjusted - Contact List Excel Report has option to include Custom Field1 3.0.2 (10/29/24) - Allow for > 32,768 volunteers - Excel Contact List Per Task continues beyond blank tasks ================================================================================= Rev: 2.5.z Main Update Summary: 1 - Volunteer Search can also search within answers to the 3 Personal Questions 2 - 1920x1200 screen resolution also supported 3 - Runtime-Only Access environment supported (no app switch allowed) ----------------------------- Miscellaneous, Minor Changes: 2.5.1 (2/27/24) - Volunteer Search: - columns made wider, table taller - use first character as title if misconfigured as blank - initial prompt more descriptive (using space between criteria) ================================================================================= Rev: 2.4.z Main Update Summary: 1 - Admins can add hours in a Volunteer's History window 2 - Added option to allow Volunteers to print their own name badge ----------------------------- Miscellaneous, Minor Changes: 2.4.1 (12/1/22) - "Remember to sign out" dialog appears before sign-in window closes (work-around for Microsoft issue of bringing non-related window to the front and/or disabled entries) - Updated name badge mail-merge documents in Resources folder - Minor format changes to My History window - Changed tab-order of SignIn Window - Shortcuts point to C:\Look2Software\Volunteers (Win11 mapped-drive icons are blank) 2.4.2 (1/14/23) - Improved message if a mapped V drive is not connected - Adjusted report screen layout - Added "Press CTRL-P to print" to the header of the namebadge preview window 2.4.3 (5/8/23) - Switch to another Look2 app will restore that window if it was minimized - Checks if instance of program is already running on same machine 2.4.4 (10/12/23) - Built-in Report for Contacts List By Task added "Checkbox" to button - Contact List Generator Excel Report has option to base lists on hours, not task checkmarks ================================================================================= Rev: 2.3.z Main Update Summary: 1 - Name Badge print button available within Profile, enabled via Admin ----------------------------- Miscellaneous, Minor Changes: 2.3.1 (8/20/22) - Switch to other Look2 software button uses another method to activate window - Printing "My History" now opens a print dialog (instead of direct-to-printer) - Added batch file to launch multiple Look2 Software with 1 icon (Resources folder) - Added NameBadgeBackground.jpg to the Resources folder ================================================================================= Rev: 2.2.z Main Update Summary: - No major features added, just minor changes and version switching from letters to 3rd digit ----------------------------- Miscellaneous, Minor Changes: 2.2.1 (5/27/22) - changes to Main Screen and Report Screen layouts (logo, added organization name, position) - filenames and resources consistent with other products 2.2.2 (6/7/22) - Added section on Backup to the User Manual - Added link to EULA (in Resources directory) via the Settings screen ================================================================================= Rev: 2.1 F Date: 5/17/2022 Main Update Summary: 1 - Added a Backup Button to the Settings Screen 2 - Added DOB column next to Age in the Excel Contact List ----------------------------- Miscellaneous, Minor Changes: - No longer show message if user simply cancels out of Password entry - Pressing Create Account or Admin Login clears any partially entered number for sign-in - Keypad button borders turn grey when disabled ================================================================================= Rev: 2.1.E Date: 4/29/22 Main Summary Update: 1 - Main screen stats now update whenever the main screen is clicked, and added time of last update just below the date (helps when 2 or more workstations are networked) 2 - Added Delete button to Task Editor 3 - Added a Refresh button to the Admin screen (for multi-PC configurations) 4 - Changed Volunteer Report to show DOB instead of just Age, so birthday cards can be sent 5 - *** DB CHANGE: Changed tblZipCodes from Numeric to Text, to permit Canadian postal codes (also adjusted profile to allow for wider Canadian postal code, and updated validation rule: Like "#####" Or Like "#####-####" Or Like "[A-Z]#[A-Z] #[A-Z]#" Or Like "[A-Z]#[A-Z]#[A-Z]#" Or Like "[A-Z]#[A-Z]") 6 - Added a report to give you contact phone/email for everyone within a timeframe ----------------------------- Miscellaneous, Minor Changes: - Reformatted "still signed in" message (yellow text, transparent background) - No longer use description field for task control-tip - Minor e-signing the agreement message is now within the form, rather than a popup - E-sign button doesn't become enabled until the embedded form says its loaded ================================================================================= Rev: 2.1 D Date: 1/15/22 Main Summary Update: 1 - Button appears if Registration (was just Inventory) is running on the same machine, allowing to switch to that app. 2 - "Month to Date" quick-set button added to both Report Screen and Excel files. ----------------------------- Miscellaneous, Minor Changes: - Handle situation where someone edits backend table directly and inserts a null task description ================================================================================= Rev: 2.1 C Date: 10/15/21 Main Summary Update: 1 - Button appears if Inventory software is running on the same machine, allowing to switch to that app. ================================================================================= Rev 2.1.B Date: 9/27/2021 Main Summary Update: (no new features) ----------------------------- Miscellaneous, Minor Changes: - Keep Lane for " Lane Street" - Excel Contact List truncates tasks to 31 characters to match tab name limits ================================================================================= Rev 2.1 B Date: 5/18/2021 Main Summary Update: (no new features) ----------------------------- Miscellaneous, Minor Changes: - Made YTD default for MyHistory window - Make sure the TaskName is not blank after people edit their history - When signing in, SQL Query filters out blank records ================================================================================= Rev 2.1 A Date: 4/2/2021 Main Summary Update: 1 - Added option to enforce Agreement signing every X days (default is 365) 2 - Show agreement in program window with e-sign button, and record date of e-signature (NOTE: you must download/install Adobe Acrobat PDF Reader for the Agreement to be shown in the software) 3 - Added Admin function to clear the agreement date for all volunteers (for use when there's a new agreement that everyone must sign) 4 - Updated the PDF in the Resources directory to include TEFAP verbiage, health reporting, tolerance, photo release, etc. It is been renamed "VolunteerAgreement.PDF" 5 - If "Today" is an answer choice to the Questions, then when selected the software will auto-fill today's date 6 - Added the Task columns to the Filtering in the Excel Report ----------------------------- Miscellaneous, Minor Changes: - Added additional error trapping to profile screen ================================================================================= Rev 2.0 D2 - Excel Report Updates Only Date: 3/1/2021 Updates to the Excel report tools only: NewVolunteerContactReport_withDetails.xlsm: - Summary worksheet: added Avg hours/task column, added filtering to columns - Volunteers worksheet: since Created Date can be filtered it now includes all volunteers (not just new) with hours during timeframe, printout fits columns with headers repeated, removed state, formatted phone, added age and VolunteerID - ALL Volunteers Details worksheet: renamed to "Raw Data", added filtering to columns, headers on print pages - Top25 worksheet: changed to TopVolunteers, show all (not just top 25), added # of entries, filtering to columns ContactListsPerTask.xlsm - Added timeframe (so only volunteers with recorded hours in that timeframe get included) - If including hours, also include a column for the most recent volunteer date for that task - Accounted for leap-year in age calculation ================================================================================= Rev 2.0 D Date: 2/16/2021 Main Summary Update: 1 - Added an explanation help message in the Edit Questions dialog for VolunteerView options 2 - Application itself gets maximized at startup so pop-up windows are better centered ----------------------------- Miscellaneous, Minor Changes: - Added additional error trapping to main screen in case MS Office license prevents usage - Edit Task Move buttons once again detect end of lists - Added screen resolution and scaling check to startup (1920x1080 @ 100%) ================================================================================= Rev 2.0-C Date: 2/1/2021 Main Summary Update: 1 - When renaming a task, give choice if historical records are updated to match, and give choice of clearing checkmarks from profiles 2 - Added an Edit Selected Person button to Admin screen (for the "People Still Signed In" list) 3 - Use a new custom calendar form to select another date (no longer require Calendar Control to be installed) 4 - Compiled for both 32-bit and 64-bit Office 5 - Allow deletion of records in the My History window ----------------------------- Miscellaneous, Minor Changes: - Updated Settings Screen Layout - Made MyHistory window title font smaller to accommodate large organization names - Added message to Load Screen in case macros not enabled immediately after first install - Excel contact list can now support apostrophe in task names ================================================================================= Rev 2.0 B Date: 1/6/2021 Main Summary Update: 1 - Added check for the installation of the Calendar Control during splash screen ----------------------------- Miscellaneous, Minor Changes: - Added application name and ico file to the DB properties ================================================================================= Rev 2.0 A Date: 11/18/2020 Main Summary Update: 1 - Added 3 optional/configurable questions to the volunteer profile 2 - Updated ContactList Excel file to optionally include answers to those questions 3 - Volunteer Lookup screen shows optional answers to configured questions 4 - Added option to permit non-volunteer hours (and a built-in report to show those) 5 - Updated Excel Reports to not include NON_VOLUNTEER_HOURS in reports *** DB UPDATE REQUIRED: - table tblQuestions added to CONFIG - PQ1, PQ2, PQ3 text fields added to Volunteers - parameter 13 in Settings for allowing non-volunteer hours ----------------------------- Miscellaneous, Minor Changes: - Added note that you can use a ? as a wildcard in Volunteer Lookup search - Adjusted date range header width in a couple of the built-in reports - Made Admin Screen taller - Excel Contact List Generator can better handle all 20 tasks being defined - Built-in reports now have white as header background (save on color ink) - Adjusted custom logo size (so it matches Registration) ================================================================================= Rev 1.1G Date: 3/8/2020 Main Summary Update: 1 - Added Settings button to Admin Screen 2 - Added Edit Task Names to the Settings Screen 3 - Added Reset Task Marks to the Settings Screen (forces user checkmarks to match history) 4 - Added option for hours per task to Excel Contact List Generator (1.1S). Also changed printout default to be fit all columns on one page. ----------------------------- Miscellaneous, Minor Changes: - Moved Edit Messages button to the Settings Screen - Changed icon for exiting software and moved Close button in Admin Screen - Tasks with 0 duration still occupy those slots for signin/profile ================================================================================= Rev 1.1F Date: 2/7/2020 Main Summary Update: 1 - Added link to Admin Screen to go to website for documentation/tutorials ----------------------------- Miscellaneous, Minor Changes: - Paths to the database files are now shown in the Reports screen - During initial installation, software only prompts once for each local DB file (if not mapped to V) ================================================================================= Date: 12/16/2019 Excel Report Update (1.1Q): - Added Last Year and Yesterday quick-fill date buttons - Now shows progress bar during report generation process - Auto-clicks YTD when first opened ================================================================================= Rev 1.1E Date: 10/9/2019 Main Summary Update: 1 - Main Screen Stats header shows date instead of "Today's Stats" 2 - Allow editing in the My History for an individual (hours, taskname, date) 3 - Added a print button to the My History window when an Admin is viewing it 4 - My History printout now prints more than 1 page 5 - When entering all hours at once, limit to 2 digits (just like when doing it after timer) 6 - Add the count of the volunteers at the bottom of Contact Reports ----------------------------- Miscellaneous, Minor Changes: - Disabled numbers in keypad now also have border turn gray ================================================================================= Rev 1.1D Date: 7/31/2019 Main Summary Update: 1 - Logo can now be either a JPG file or a PNG file (allowing for transparency in logo) 2 - Added ability for Admin to edit messages without going into the Access tables directly 3 - Added Last Year button to program's Reports Screen ----------------------------- Miscellaneous, Minor Changes: - Don't close the Admin Screen when launching the Reports Screen - Password entry number feedback now gray and tiny - Disable any password that's been configured as non-numeric - Admins can search for a name with an apostrophe in it ================================================================================= Rev 1.1C Date: 3/16/2019 Main Summary Update: 1 - Added ability to show optional Sign In Note (configured via tblParameters item 10) 2 - Added ability to show optional Sign In Popup Message (configured via tblParameter 11). Stops showing message if user logged hours after optional end date (tblParameter 12). ----------------------------- Miscellaneous, Minor Changes: - Made width of total hours in Sign-in dialog a tad wider for > 1,000 hours - Show "Calendar not Installed" message in hours entry if the Windows OCX is not available - Adjust Admin screen wording when nobody's selected - Adjust Admin screen to be slightly narrower - Adjust width of D.O.B. field in profile to be a tad wider - Adjust splash screen for resolutions below 1920 (down to 1600) ================================================================================= Rev: 1.1B Date: 2/2/2019 Main Summary Update: 1 - Added YTD vs All Dates options in My History window 2 - ContactListsPerTask Excel spreadsheet checks for task names with invalid characters when generating worksheet tabs, replaces them with an underscore; invalid characters are / \ ? * : [ ] ----------------------------- Miscellaneous, Minor Changes: - Check DOB when saving profile for > 120 or < 0. Warn if current year. - Added some cleanup for hand-typed city names (proper case, trim, etc) - Use AutoExec for startup to match Inventory for consistency between products - Updated Splash screen to match Inventory for consistency between products ================================================================================= Rev: 1.1A Date: 1/24/2019 Main Update Summary: 1 - Added a Splash Screen that checks DATA and CONFIG links and prompts for relinking if missing (helps with installation) 2 - If a person changes their name (e.g., got married), the software updates any historical records for that ID ----------------------------- Miscellaneous, Minor Changes: - Added a "Set to Local" button in each of the Excel files ================================================================================= Rev: 1.0S Date: 11/2/2018 Miscellaneous, Minor Changes: - Show warning when recording hours all at once and greater than limit ================================================================================= Rev: 1.0R Date: 9/25/2018 Main Update Summary: 1 - Added a History button to the user's profile (handy for Admin lookup!) ----------------------------- Miscellaneous, Minor Changes: - Auto-update of new parameters for older databases ================================================================================= Rev: 1.0Q Date: 5/14/2018 Main Update Summary: 1 - Added parameter for "Default Task" in case none selected and no history 2 - Changed task presentation order so it's down-across instead of across-down order 3 - Added a couple of more date fill-in timeframes in Reports ----------------------------- Miscellaneous, Minor Changes: - Removed italics for non-checked sign-in tasks - Widened task fields just a tad - Made "Admin Only" in profile different color - Made lookup dialog larger ================================================================================= Rev: 1.0P Date: 5/12/2018 Main Update Summary: 1 - Added parameter #8 so Task checkboxes in Profile can be made for "Admin-Only" ----------------------------- Miscellaneous, Minor Changes: - Made borders around editable Profile fields blue - Task for other notes changed from "Various Other" to just "Other" - If calendar control not operational on a PC, it bypasses its use - Made 1st task be the default if no history and no tasks checked ================================================================================= Rev: 1.0N Date: 1/7/2018 Main Update Summary: 1 - Allow date designation when using Sign-in to log hours 2 - My History window now has a header and shows more entries. CTRL-P prints current view! 3 - Excel Report now has relative paths, added Hours/Task worksheet and a Top25 worksheet. Also swapped email/phone for import. ----------------------------- Miscellaneous, Minor Changes: - If user starts to sign out within a couple of minutes of starting timer, select Manual Entry as default - Sign-Out window: if hours > 12 but < 24, they are shown without subtracting 12 - Don't prompt if Close Form Password is set to nothing - Disable minimize button in report print-preview popups - History Timestamp uses 12:01:00 SignIN entering all at once and user selects another date hh:nn:00 SignIN entering all at once hh:nn:01 SignOUT using the timer hh:nn:02 SignOUT overriding timer and using manual hours hh:nn:03 SignOUT manual hours when user forgot to sign out for older date hh:nn:04 Admin Screen used to log out user NOTE: If MSCOMCT2.OCX is not in the Windows/SysWOW64 directory, need to copy MSCOMCT2.OCX and then right-click on Command Prompt and Run as Administrator to execute: %systemroot%\SysWoW64\regsvr32.exe %systemroot%\SysWoW64\MSCOMCT2.OCX ================================================================================= Rev: 1.0M Date: 12/20/2017 Main Update Summary: 1 - Added parameter to allow DOB to become a required field (if option is set) 2 - Added password prompt to Close Main Form (to make it more secure) 3 - Added Top Hours report (total hours per volunteer sorted by hours) ----------------------------- Miscellaneous, Minor Changes: - Made TaskName column in Admin Popup a bit wider for longer task names - Updated Report buttons and headers - Allow keyboard press of "." for number-pad popup - Cosmetic: "Status" label now bold when Admin is viewing profile - Updated tab order for Reports - Included additional address standardizations - Added logic for upgrading older parameter tables for new DOB and password feature - Hid non-essential forms, etc. in DB view pane DB Change: -software should automatically add fields for DOB required and close form password parameters ================================================================================= Rev: 1.0L Date: 12/8/2017 Main Update Summary: 1 - Added Excel Report launch button to reports screen ----------------------------- Miscellaneous, Minor Changes: - Handle phone numbers of all 0's - Missing profile fields use message form instead of MsgBox ================================================================================= Rev: 1.0K Date: 11/17/2017 Main Update Summary: 1 - Reports are now sizable popups 2 - Keyboard/Keypad can be used to enter numbers ----------------------------- Miscellaneous, Minor Changes: - Removed Window Header (for fuller screen) - Contact List logo set to zoom for wide images - Selected Task Report header change - Made City Name entry field wider - Task checkboxes are slightly wider and taller for longer text - Can adjust to smaller screen resolutions (but 1920x1080 is best) - ESC key can close pop-ups