Microsoft Access VBA Macro Programming

DoCmd.Close acReport, "rptTemplate" RepName = rep.Name rep.OLEUnbound0.RowSource = "tblChart" rep.OLEUnbound0.RowSourceType = "T ...

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

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

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

This page intentionally left blank ...

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

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

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

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

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

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

within the table. Normally, you would be given read-only access since it is very dangerous to modify data in a relational databa ...

Set the check boxes for the tables that you need to re-link and then set the check box at the bottom for “Always prompt for new ...

Click the three-dot symbol on theODBC Connect Strproperty and you can then select a DSN to use. Click the Machine Data Source ta ...

It is often a very good idea to test the query out on the database itself using SQL Server Manager or TOAD (Tool for Oracle Appl ...

to version 2, depending on what version of Windows you are running, but they will still work in the same way. If you do not have ...

This code creates two recordset objects, one as an ADO recordset and the other as a standard Access DAO recordset. It also sets ...

Ccnt 2 = "Server=MyServer;Database=MyDatabase;Uid=MyId;Pwd=MyPassword;" Ccnt = Ccnt 1 & Ccnt 2 CurrentDb.Execute "insert int ...

This page intentionally left blank ...

Chapter 20 API Calls. Chapter 20 API Calls. A lthough the Access object model and VBA code are very comprehensive in providing y ...