POPUP CALCULATOR for Microsoft Access
This utility is a COM add-in or add-in (.mdb) programmed in Microsoft® Visual Basic® for Application (VBA) that generates a classic popup calculator in Microsoft® Access® to capture values, operate, and insert results. See the pictures below.
It consists of only one file, the AccessCalculator.dll, which is about 270 kb in size and can be installed automatically using one of the installer package files available below to download. Except for the DLL, no other setting is saved in the Microsoft® Windows® Register. Its setting is saved in AccessCalculator.ini file that is created and maintained by the proper utility. You also can uninstall it automatically using the same installer file, leaving no mess on your Windows Register or disc.
- Pops up in small size
- Pops up close to the mouse cursor or optionally at the last saved position
- Can pop up in two formats: normal and with paper ribbon
- Addition, subtraction, multiplication and division operations
- Supports decimals floating, decimals limited in result, and decimals limited when entering values with independent settings memory for each option
- Decimals limited when entering values are also fixed as default while the value is entered, but they was temporarily released if the decimal separator is typed
- Supports to limit up to 9 decimals in the result
- Supports to limit up to 9 decimals when entering values. In this case, if positive, the result is limited in the same way without losing its settings
- Still supports negative decimals when entering values. In this case, the value is automatically multiplied by 10 for every decimal place in fixed way while being entered and the result is limited to that defined in its settings
- Square root
- Changes sign number on the display
- Operation with constant
- Paper ribbon
- Prints the paper ribbon
- Captures and inserts on the selection
- When capturing, if there is a selected text instead of a value, is a table column or a mix of numbers and text, and if there is more than one number, all are properly filtered with their signs, added up, and the result inserted in the display as initial value
- Inserts and closes immediately. Tip! Down Ctrl key to insert without closing
- Inserts without breaking the current thread of Access ‘Undo’ command and any insertion can be normally undone by itself
- Can be called by the mouse right button (Context menu), or by a button in an Access toolbar (2007, 2010, or 2013 Ribbon Add-ins tab)
- Supports multiple instances within a single instance of Access with independent controls, settings, and results. In practice quantities, there is no limit to the number of simultaneous instances
- Paper show controls in all open instances or some of them can be attached to set simultaneously
- The feature of multiple instances can be disabled
- The display size can be adjusted through the borders to increase the font size from 8pt to until 32pt or decrease to until 3pt
- Can copy the value on display to Windows Clipboard. Tip! When inserting with Shift key pressed, the result is sent to Windows Clipboard instead
- Can paste on display existent value on Windows Clipboard
- Accepts the following hotkeys that make it possible to pick values, make operators, and insert results only using the keyboard:
- The skin can be set up in: color and background picture, display and controls transparency, and hiding classic title bar
- The last opened setting or the last closed instance setting will be used as default in the next new instance
- Has menu commands to restore all default settings
- All instances running can be closed with a single click by selecting the Close All command in the menu
- Can be called directly from any VBA code through the fCalculator() function. See, soon below the pictures, a detail description of this function and examples of the VBA applications that use it
- Modal or Modeless
- Occupies less than 270 Kb when installed
Tested in Access 2000, 2002(XP), 2003, 2007, 2010 (32-bit), 2013 (32-bit), and 2016 (32-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.
The Calculator can be called directly from any VBA code through the fCalculator() function that has these 8 optional arguments:
1 - IniValue (Display initial value, Default=0)
2 - DecimalsInResult (Long 0 to 9, Default=2 but start floating)
3 - DecimalsEnterFix (Long 0 to 9 and -1 to -9, Default=2 but start floating or limited if DecimalsInResult set)
4 - WaitAndRetValue (Long 0 to 2, Default=2). Where:
0 - Not
return value, not asynchronous, and modeless
5 - FontDisplaySize (Long 3 to 32, Default=8)
6 - ShowPaper (Boolean, Default=False)
7 - LeftPos (String, Default="0")
8 - TopPos (String, Default="0"). Where LeftPos and TopPos are the distances in points (1/72 inches) from the center right side of the Calculator to the current mouse position. If the values are preceded by $ (dollar sign), LeftPos and TopPos turn to be the distances from left top corner of the Calculator to the left top fix corner of the screen. And yet, if there is only the $ without number, will be used the current default position.
1 - The code below calls the calculator in modal to return result as Double to a userform.
2 - The code below calls the calculator in modeless to return result like in the right click command.
3 - Idem to capture and return result to active selection.