Access VBA Macro Programming

audit trails enhancing, 292 overview, 290 using events to create, 290–292 authorized users, 281–282 See alsologin IDs B Beep met ...

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

Null value, 19–20 numeric types, 20–21 overview, 18, 20 string types, 21–22 variants, 18–19 See alsouser-defined types databases ...

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

errors compile errors, 81–82 generating your own, 94–95 logic errors, 82 runtime errors, 82 Type Mismatch errors, 73 See alsodeb ...

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

GetScreentipMso method, 140 GetSupertipMso method, 140 GetUserName function, 290 GetVisibleMso method, 140 global variables, 15, ...

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

message boxes, 66–69 in debugging, 89–90 See alsoMsgBox statements methods, 176–178 calling, 180–184 Microsoft Graph 12.0 Object ...

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

Private keyword, 32 procedure stepping, 85 Project Explorer, 6–8 Project trees, 6 properties, 176–178 manipulating read/write pr ...

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

Select case statements, 39–40 See alsoconditional statements Select query, 154–156 See alsoSQL queries semaphore files, 340–341 ...

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

local variables, 15–16 module-level variables, 16 name conflicts, 17 overview, 13–14 scope and lifetime of, 15 shadowing, 17 str ...

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