Microsoft Access VBA Macro Programming

Timer The Timer event is useful if you want to run a procedure at a fixed time interval, such as re-querying the form so that th ...

On the opening screen of the wizard, select your new query on the drop-down. You should have four possible fields showing (Ship ...

Keeping Your Report Tidy The wizard has produced for you a pristine looking report, but users will often later make requests tha ...

Click the Arrange tab in the ribbon. In the Control Alignment group on the ribbon, you have icons to allow you to align all your ...

View the Orders report that you created in the previous section in Design mode. Right-click the horizontal gray bar for “Ship Na ...

This expression concatenates text and field names and functions to produce a single text statement for use on the report. For ex ...

ribbons for particular reports. Once you have your ribbon designed, you simply use the Ribbon Name property on the report to int ...

You can view the events by right-clicking the report in Design mode and then clicking Build Event in the pop-up. Click Code Buil ...

Timer The Timer is a useful event if you want to run a procedure at a fixed time interval, such as re-querying the report so the ...

Chapter 10 Common Dialog Control Chapter 10 Common Dialog Control U sing API calls (see Chapter 20 for more information), you ca ...

The Open File Dialog The first thing you need to do is enter the module for the form you have created by right-clicking the form ...

strFilter = "Text Files (.txt)" & Chr( 0 ) & ".TXT" & Chr( 0 ) MyFile.lpstrFilter = strFilter MyFile.nFilterIndex = ...

The Save File As Dialog The Save File As dialog works in almost exactly the same way as the preceding Open dialog example, but t ...

The first thing you need to do is enter the module for the form you have created by right-clicking the form, selecting Build Eve ...

The API call is made, returning a value into the variable x. If the return value is zero, then the user canceled the operation, ...

Chapter 11 Working with the Ribbon Chapter 11 Working with the Ribbon I n Office 2007, an important change happened with the use ...

the definition for many menus and ribbons so they can be used on different forms and reports and also as the default ribbon when ...

The URL used in the preceding code could possibly change in the future, but this is highly unlikely. It is a standard URL used i ...

Save your form and then click the Form view icon in the Views group of the ribbon. You will now see that your form opens with on ...

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