Access VBA Macro Programming

The report is saved and renamed to rptMyGraph and then opened in Design mode. The subsequent code will not work if the report is ...

You may want to use the After Insert event to create a child record in another table that is related to the new record being cre ...

In terms of the Chart Type, Excel version 97 and later have built-in parameters to define the various types of charts. These all ...

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

The preceding code sets the label on each slice to display both the value and the category name, which is the name declared on t ...

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

This page intentionally left blank ...

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

Chapter 19 Working with External Databases Chapter 19 Working with External Databases O ne powerful feature of Access is that yo ...

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

Because of the flexibility of ODBC, you can use Access as a “junction box” to join up several different databases if required. I ...

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

If you do not have access to SQL Server, you can download SQL Server Express free of charge from http://www.microsoft.com/Sqlser ...

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

Double-click the SQL Server Native Client 10.0 and you will be taken to the screen in Figure 19-3. Give your DSN a descriptive n ...

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

the owner of the database that your ID and password are set up correctly. If you can get the IP address of the server, try pingi ...

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

Select the radio button “Link to the data source by creating a linked table” and then click OK. In the next screen, click the ta ...

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