Access VBA Macro Programming

screen resolutions, and what looks good on your development screen can look terrible on a user’s screen. Using this when a form ...

If Err.Number = 71 Then MsgBox "The D drive is not ready" Else MsgBox "An error occurred" End If End Sub You saw from the first ...

Action queries (such as delete, insert, or append) can be run in this way, but you can also use: CurrentDb.Execute "MyQuery" Ope ...

If there is no disk in drive D, the code will still run perfectly because ofOn Error Resume Next—it skips over the line of code ...

The parameters are all optional:  PrintRange An acPrintRange constant specifying the range to print—the default is acPrintAll. ...

You can generate an error in your code with theErrorstatement: Sub Test_Error() Error 71 End Sub This simulates the “Drive not r ...

If you turn the warnings off, make sure you switch them back on when your code has finished. This method has an effect throughou ...

This page intentionally left blank ...

The syntax is: DoCmd.TransferText (TransferType,SpecificationName,TableName,FileName,HasFieldNames, HTMLTableName,CodePage) Th ...

Chapter 9 Forms and Reports Chapter 9 Forms and Reports F orms and reports are the means by which your application interfaces to ...

This page intentionally left blank ...

Creating a Simple Form To create a form, click the Create tab in the ribbon and then click the Form Design icon in the Forms gro ...

Chapter 17 Using Access to Interact with Other Office Programs Chapter 17 Using Access to Interact with Other Office Programs A ...

To display your form, click the Design tab in the ribbon and then click the Form View icon in the Views group of the ribbon. You ...

You can add a reference by selecting Tools | References from the menus. All available reference files will appear in a dialog. Y ...

soon as the user moves to another record or closes the form, that change is saved back to the underlying tables and there is no ...

oWdoc.SaveAs ("MyTest") oWdoc.Close oWd.Quit Set oWdoc = Nothing Set oWd = Nothing End Sub The first line declares the variables ...

In order to display the name of an employee instead of the ID number, you could make the record source of your form a query join ...

Recently, I had the task of writing a program to populate an SLA (Service Level Agreement) Report. The SLA Report was a Word doc ...

This is a standard SQL select statement. Notice that first name and last name are concatenated together using a space in the mid ...