Access VBA Macro Programming

This page intentionally left blank ...

This page intentionally left blank ...

Chapter 36 Use FTP in VBA Chapter 36 Use FTP in VBA A ccess applications are all about manipulating and presenting data to the u ...

Chapter 16 The DoCmd Object Chapter 16 The DoCmd Object T heDoCmdobject is a special object model in Access VBA. It is fairly si ...

Using VBA Code to Transfer Files You can see how easy it is to move files between the FTP server and your PC. Even if the FTP se ...

This provides a very easy way of making a sound, although it is very limited in what it can do. If you need more flexibility, se ...

Next, set up a subroutine to transfer a file from your chosen FTP server to your local PC: Sub GetFile() Dim MyConn, MyINet, Chk ...

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

A true or false value is placed in the variable Chk by this process. If Chk is true, then the file download was a success and th ...

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

If you use an automated process to transfer a large file onto an FTP server (possibly as an overnight job), there may be a proce ...

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

This page intentionally left blank ...

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

Chapter 37 What Happens When the 2-GB Limit Is Reached Chapter 37 What Happens When the 2-GB Limit Is Reached A ccess 2010 still ...

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

pane is showing. You also size the application window for your trashed database so only the Navigation pane is showing. Place th ...

This page intentionally left blank ...

Chapter 38 Creating Menu Structures with the Ribbon Chapter 38 Creating Menu Structures with the Ribbon B ack in Chapter 11 of t ...

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