Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Access Other topics FAQ

VBA and Custom Functions

Windows Calculator by Hitting the F12 Key by Bullschmidt
Posted: 23 May 03 (Edited 23 Jun 03)

To let the user hit the F12 key to bring up the Windows Calculator anytime you can do this:

o Create or add to a macro with the exact name of AutoKeys

o In the AutoKeys macro add this new row:
MacroName of {F12}
Action of RunCode with FunctionName of tlbCalculator()
Comment of Calculator

o Then create or add to any module the following function:

Public Function tlbCalculator()
    ' Purpose:  Open Windows Calculator.
    ' Remarks:  Called by AutoKeys macro.
    '           Calculator has View | Standard which is the orig. default
    '           or View | Scientific which I like best.
    '           Windows "remembers" the last setting for this.
    On Error GoTo Err_tlbCalculator
    ' Open Windows Calculator (original size with focus).
    Call Shell("CALC.EXE", 1)

    Exit Function

    Exit Function
End Function

J. Paul Schmidt, Freelance Access and ASP Developer
http://www.Bullschmidt.com/Login.asp - Database on the Web Demo
http://www.Bullschmidt.com/Access - Sample Access Invoices Database

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close