Access VBA Macro Programming

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

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

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

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

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

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

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

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

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

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

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

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

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

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

This page intentionally left blank ...

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

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

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

The purpose of this chapter is to give you an idea of how you can use API calls within your code. The examples given are not com ...

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