b POPUP CALCULATOR for Microsoft Access

What's new   Download   Home  Ads

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.

Following items in this page:





- 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

- Memory

- 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:

- Popup Calculator: None
- Numbers and operators: corresponding keys on the keyboard
- Square root: @
- Equals sign: Enter or =
- OK (Equals sign, insert and close): O, arrow up, arrow down, or Tab (Tip! Down Ctrl key to insert without closing)
- Close: ESC
- C: C
- AC: A
- M+: P
- M-: S
- MR: R
- Paste from Windows Clipboard: Ctrl + V
- Copy to Windows Clipboard: Ctrl + C (Tip! When inserting with Shift key pressed, the result is sent to Windows Clipboard instead)

- 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

- Sound

- Occupies less than 270 Kb when installed


Tested in Access 2000, 2002(XP), 2003, 2007, 2010 (32-bit), 2013 (32-bit), 2016 (32-bit), and 2019 (32-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.


Download the English version now

You also can download from this mirror site

Last update: 12/23/2023 - 741.8kb

Freeware based in this License Agreement

Note: The above link downloads the installer and uninstaller package programmed in VBA in a MDB duly converted to EXE by the DBtoEXE to make the installation easier for macro and Microsoft® Windows® laymen; however, if you're an expert and for some reason prefer an installer and uninstaller package in open ZIP format, click here. With this zip package you can install it in three ways: (1) Simply initiate the Install.exe that loads the same MDB in Access without macro alert; (2) Extract the entire package to a folder and initiate the MDB, enabling the macros in Access and using 123 as password, or (3) Install the DLL manually.

See also for Microsoft Excel®, for Microsoft PowerPoint®, and for Microsoft Word.



fCalculator() Function:

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
1 - Return value, asynchronous, and modeless
2 - Return value, asynchronous, and modal

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.

Sub YourSub1()
    Dim ObjToVBA As Object
    Set ObjToVBA = Application.COMAddIns("AddInAcCalculator.AccessDesigner").Object
    fRet = ObjToVBA.fCalculator(IniValue)
End Sub

2 - The code below calls the calculator in modeless to return result like in the right click command.

Sub YourSub2()
    Dim ObjToVBA As Object
    Set ObjToVBA = Application.COMAddIns("AddInAcCalculator.AccessDesigner").Object
    Call ObjToVBA.fCalculator(IniValue, , , 0)
End Sub

3 - Idem to capture and return result to active selection.

Sub YourSub3()
    Dim ObjToVBA As Object
    Set ObjToVBA = Application.COMAddIns("AddInAcCalculator.AccessDesigner").Object
    Call ObjToVBA.fCalculator
End Sub

About Add-in (.mdb):

Temporarily unavailable.


More information







Visitas acumuladas em todas as páginas:
Visitas hoje só nesta página: