Access VBA Macro Programming

Change_Err: If Err = conPropNotFoundError Then Set prp = dbs.CreateProperty(strPropName, varPropType, varPropValue) dbs.Properti ...

As said previously, do not forget to set the warnings back again. If you do not, you will receive no warnings at any point withi ...

Display Form to select the form you created. This means that when the database is loaded it will automatically default to your n ...

If Asc(Mid(Target, n, 1 )) >= 97 Then CheckUpperCase = False Exit Function End If Next n CheckUpperCase = True End Function T ...

Notice that the File tab now has very limited options. The button for Access Settings is now missing and you cannot customize th ...

Chapter 13 Table Macros Chapter 13 Table Macros A new feature of Access 2010 is the ability to create table macros. These perfor ...

This page intentionally left blank ...

Save your table with the nametblTestTableMacro. Do not worry about defining a primary key. This is not required for this example ...

Chapter 25 Creating Audit Trails on Tables Chapter 25 Creating Audit Trails on Tables E ven the simplest database can end up hol ...

In the first “Add New Action” drop-down that appears, select SetField. Your design window will look like Figure 13-3. Chapter 13 ...

This sets up a link to the functionGetUserNamein the dynamic link library advapi32 (which is supplied as part of the Windows ope ...

After selecting Set Field, you will see a design window for your particular action to set a field value. Enter the name of the f ...

Temp = RecSet!AuditTrail Temp = Temp & "Edit" & "|" & ReturnUserName & "|" & Now() & "|" CurrentDb.Execu ...

If you need to edit your action, simply click the Set Field text in the action. This will bring you back to the design section. ...

What sort of uses could you put this to within your application? If you had a table that collected data to work out something li ...

Instead, you add another field of Boolean type (Yes/No) to the underlying table called Deleted. You then put your own Delete but ...

Use the Create Record In option to select your second table (tblTableMacroCopy). Click the Add New Action field within the gray ...

Chapter 26 Creating and Editing Queries in VBA Chapter 26 Creating and Editing Queries in VBA S QL queries in Access are an esse ...

This page intentionally left blank ...

Qds.Append Qd Application.RefreshDatabaseWindow Set Qd = Nothing Set Qds = Nothing End Sub This example assumes you do not alrea ...