Microsoft Access 2010 Bible

Chapter 20: Advanced Access Report Techniques 733 The Format event occurs as Access begins to format the controls within the Det ...

Part III: More-Advanced Access Techniques 734 FIGURE 20.27 txtPageNumber moves from the right edge of the paper to the left edge ...

Chapter 20: Advanced Access Report Techniques 735 FIGURE 20.28 txtPageNumber jumps from right to left. Using different formats i ...

Part III: More-Advanced Access Techniques 736 The Amount text box will be dynamically formatted according to the value contained ...

Chapter 20: Advanced Access Report Techniques 737 To micro-adjust a control’s position, hold down the Ctrl key as you press the ...

Part III: More-Advanced Access Techniques 738 The inset in the lower-right part of Figure 20.29 shows the information provided b ...

Chapter 20: Advanced Access Report Techniques 739 Trying More Techniques As you’ve probably discovered by now, reporting in Acce ...

Part III: More-Advanced Access Techniques 740 Because MSysObjects stores the names of all database objects, you can return the n ...

Chapter 20: Advanced Access Report Techniques 741 Hiding forms during Print Preview Very often, when you’re using the overlappin ...

Part III: More-Advanced Access Techniques 742 FIGURE 20.32 This query returns more detailed information than I’ve been using. Th ...

Chapter 20: Advanced Access Report Techniques 743 The same report in Print Preview mode is shown in Figure 20.34. Notice that th ...

Part III: More-Advanced Access Techniques 744 FIGURE 20.35 Only a few changes are needed to produce snaking columns. As long as ...

Chapter 20: Advanced Access Report Techniques 745 FIGURE 20.37 Snaking multiple columns conserve page space and provide more inf ...

Part III: More-Advanced Access Techniques 746 In addition to these properties, be sure to take note of the New Row or Col proper ...

Chapter 20: Advanced Access Report Techniques 747 Keep in mind that the measurement units you see in the Page Setup ribbon tab a ...

Part III: More-Advanced Access Techniques 748 The built-in Pages variable (which contains the total number of pages in the repor ...

Chapter 20: Advanced Access Report Techniques 749 The Count() and Sum() functions both require information that isn’t available ...

Part III: More-Advanced Access Techniques 750 Summary This chapter examines a number of advanced report design concepts and tech ...

751 CHAPTER Building Multiuser Applications IN THIS CHAPTER Setting up your multiuser applications on a network Determining how ...

Part III: More-Advanced Access Techniques 752 updates to records in a database. Access security, on the other hand, prevents una ...