Access VBA Macro Programming

The next step is to put in code to call this function: Sub Test_Api() Dim x as Double Dim FreeBytesAvailableToCaller As Currency ...

Microsoft has very helpfully provided a sample ribbon customization for Excel in this application. To make this work, you must f ...

You can check the values by going into Windows Explorer (right-click the Windows Start button in the bottom-left corner of the s ...

When you open the form where you referenced the ribbon name property to this record, you will see that an extra entry now appear ...

x = GetPrivateProfileString("Parameters", "Path", "", s$, 256, "myini.ini") MsgBox s$ MsgBox x End Sub The first line writes the ...

Take some time to look through this sample piece of XML and see how it is constructed. The code is shown here: Chap ...

Reading Keyboard Activity Another useful purpose of API calls is to read the keyboard and find out if a certain key has been pre ...

<group idMso="GroupQuickFormatting" /> </tab> </tabs> </ribbon> </customUI> One of the most import ...

Chapter 20: API Calls 259 Symbolic Constant Name Value (Hexadecimal) Mouse or Keyboard Equivalent VK_LBUTTON 01 Left mouse butto ...

Copy the skeleton code from the Custom UI Editor window by selecting all of it and pressingCTRL+C. Select the module on the VBA ...

260 Microsoft Access 2010 VBA Macro Programming Symbolic Constant Name Value (Hexadecimal) Mouse or Keyboard Equivalent VK_DELET ...

The preceding example only provides code that will take a specific action when the ribbon button is clicked. You can also includ ...

Chapter 20: API Calls 261 Symbolic Constant Name Value (Hexadecimal) Mouse or Keyboard Equivalent VK_W 57 W VK_X 58 X VK_Y 59 Y ...

As you have already seen, you can add code to a control and you can change the title of a ribbon group, but this can only take p ...

262 Microsoft Access 2010 VBA Macro Programming Symbolic Constant Name Value (Hexadecimal) Mouse or Keyboard Equivalent VK_F12 7 ...

By selecting the drop-down Choose Commands From in the top-left corner of the form, you can select control lists in any of the m ...

Playing Multimedia Sounds You can also use an API call to play a sound within your code from a WAV file. The old macro programmi ...

More on the Ribbon Using the custom UI Editor, try adding the following code to the Ribbon XML that you constructed earlier. Thi ...

This page intentionally left blank ...

The purpose of this extra XML is to create a sample check box in a custom ribbon control on the Home tab of the user interface. ...