Microsoft Access VBA Macro Programming

The idea of this is to allow users to design their own Excel reports using a few simple rules. By using the exclamation mark (!) ...

On Error Resume Next Kill "TestExcel.xlsx" On Error GoTo 0 MyBook.SaveAs ("TestExcel") MyBook.Close MyExcel.Quit Set RecSet = No ...

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

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

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

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

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

This page intentionally left blank ...

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

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

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

<tab id="customTab" label="MyMenu" > <group id="customGroup" label="My New Menu Structure"> <box id="box 1 " boxS ...

Notice how the menu separators have been used and how Group3 forms a submenu of Group2. Also, notice that a disabled button with ...

'Callback for id 3 onAction Sub Action 3 (control as IRibbonControl) End Sub 'Callback for id 4 onAction Sub Action 4 (control a ...

Chapter 39 Make Controls on Forms Interactive Chapter 39 Make Controls on Forms Interactive Y ou can use VBA very effectively to ...

Creating a Simple Table As an example, we will use a simple table of supplier names and sizes of supplier. Create a table by cli ...

Creating a Form for the Table Create a form based on the Suppliers table by clicking Create in the Access menu and clicking the ...

the SupplierSize drop-down is called Combo0), select the Change event in the drop-down in the top-right corner of the code windo ...

Me.Combo0.SetFocus End Sub This code assumes that the two drop-down boxes you created are called Combo0 and combo2, and the text ...