Access VBA Macro Programming

X = GetUserName(strUser, 256 ) strUser = RTrim(strUser) strUser = Left(strUser, Len(strUser) - 1 ) Set RecSet = CurrentDb.OpenRe ...

Populate your table with some data. Your table should now look like Figure 18-2. You now need to create a template graph to be i ...

If you only want certain users to be able to see some of the controls, you can easily hide and unhide individual controls accord ...

Finally, we get to the interesting bit of the VBA code to create a report, add a chart to it, and manipulate it with VBA. Insert ...

This page intentionally left blank ...

DoCmd.Close acReport, "rptTemplate" RepName = rep.Name rep.OLEUnbound0.RowSource = "tblChart" rep.OLEUnbound0.RowSourceType = "T ...

Appendix ASCII Character Codes Appendix ASCII Character Codes T his appendix is a listing of the 255 ASCII (American Standard Co ...

The report is saved and renamed to rptMyGraph and then opened in Design mode. The subsequent code will not work if the report is ...

360 Microsoft Access 2010 VBA Macro Programming ASCII Code Character 15 _ 16 _ 17 _ 18 _ 19 _ 20 _ 21 _ 22 _ 23 _ 24 _ 25 _ 26 _ ...

In terms of the Chart Type, Excel version 97 and later have built-in parameters to define the various types of charts. These all ...

Appendix: ASCII Character Codes 361 ASCII Code Character 89 Y 90 Z 91 [ 92 \ 93 ] 94 ^ 95 _ 96 ` 97 a 98 b 99 c 100 d 101 e 102 ...

The preceding code sets the label on each slice to display both the value and the category name, which is the name declared on t ...

362 Microsoft Access 2010 VBA Macro Programming ASCII Code Character 163 £ 164 ¤ 165 ¥ 166 ¦ 167 § 168 ̈ 169 © 170 ª 171 << ...

This page intentionally left blank ...

Appendix: ASCII Character Codes 363 ASCII Code Character 237 Í 238 Î 239 Ï 240 Ð 241 Ñ 242 Ò 243 Ó 244 Ô 245 Õ 246 Ö ASCII Code ...

Chapter 19 Working with External Databases Chapter 19 Working with External Databases O ne powerful feature of Access is that yo ...

This page intentionally left blank ...

Because of the flexibility of ODBC, you can use Access as a “junction box” to join up several different databases if required. I ...

Index. Index operator, 73 operator, 72 ^ operator, 74 +operator, 72–73 \ operator, 73 / operator, 73 A Abs function, 49 ACCD ...

If you do not have access to SQL Server, you can download SQL Server Express free of charge from http://www.microsoft.com/Sqlser ...