Calculator

[Gismo]

Hi all,

Is there an easy way to create a calculator on a form?

 

[bastanu]

Popup Calculator for Microsoft Access

Classic calculator to operate and insert results in Access.

cpap.com.br

Redirecting

http://www.mvps.org/access/downloads/calc.zip

 

[CJ_London]

you mean with 10 number buttons plus multiply/divide/add/subtract?

if so, what is wrong with using the built in windows calculator?

if you mean for user to type in a calculation, use the eval function

?eval("(23*2)+55")
101

 

[Ranman256]

click windows start,
type: calculator, enter.

 

[Pat Hartman]

@bastanu That calculator, like many other add-ins was never upgraded to support 64-bit Office

 

[bastanu]

I never needed one, just did a Google search and posted some of the results...

 

[Pat Hartman]

That's fine. Just pointing out that it sadly, has an expiration date unless the developer chooses to recompile it. I can't imagine that it takes much to convert from 32-bit to 64-bit. If the app is using API code the definitions need to change as they do with Access.

 

[MajP]

I think I have a few examples at home using just native Access controls (no API). I assume you do not want the built in calculator, since you want the value from the calculation to appear in the control that called the calculator. That is what these do.

 

[MajP]

Demo.

 

[Gismo]

I can use the built in windows calculator but some of the staff don't really have much computer literacy, so having the calculator on the same form where a few values needs to be added, will make it much easier for the user, instead of having to open up the windows calculator, just a preference

 

[arnelgp]

there is a Template here for simple calculator:
Microsoft Access Templates Calculator Form For Microsoft Access 2016 Access 2016 (access-templates.com)

 

[Gasman]

I can use the built in windows calculator but some of the staff don't really have much computer literacy, so having the calculator on the same form where a few values needs to be added, will make it much easier for the user, instead of having to open up the windows calculator, just a preference

Why not just have a button that opens the windows calculator? Seems like a lot of work, for such a simple task?

Open calc.exe from VBA

I use this to open Windows calculator but how can I modifiy it to NOT open another instance if calc.exe is already open? Sub StartCalculator() Dim Program As String Dim TaskID As Double On Error Resume Next Program = "calc.exe" TaskID = Shell(Program, 1) If Err 0 Then...

www.mrexcel.com

 

[MajP]

Sorry forgot the attachment. Demo again.

 

[Gismo]

Thank you all

 

[arnelgp]

you can also put the "calculation" directly to the textbox like in the demo.

 

[Basakran]

you can also put the "calculation" directly to the textbox like in the demo.

Thanks very much.

Very usefull

 

[Moosak]

Try this...

    Dim stAppName As String
    stAppName = "C:\WINDOWS\system32\calc.exe"
    Call Shell(stAppName, 1)

 

[isladogs]

Try this...

    Dim stAppName As String
    stAppName = "C:\WINDOWS\system32\calc.exe"
    Call Shell(stAppName, 1)

Taking this one step further, I have a free example app with a ribbon to run several external apps from Access including Calculator, Snipping Tool, Notepad, Paint etc

Run External Apps from Access

This article shows how you can run external Windows applications from Access using hot keys specified in an Autokeys macro or from a custom ribbon.

isladogs.co.uk

I selected apps I most often use whilst developing in Access:

Its very easy to do and the idea can be adapted to run any external app of your choice using Shell or similar.