• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: Overcoming Access Development Ob... > Conquering Big Problems that Come In...

Chapter 20. Conquering Big Problems that Come In Small Packages

In Chapter 19, you learned about parsing and concatenating data. This chapter deals with other potential pitfalls that a programmer might face that come in small packages. When you know what you are facing and how to face it ahead of time, you can’t help but be a better programmer. That’s the reason so much space has been devoted to overcoming obstacles. When problems come along, you instinctively know what tools need to be employed to work through the difficulty. Specifically, you learn the following:

  • how to master quotes and pounds

  • how to use the BuildCriteria function

  • how to test quotes and pounds

  • what must be done to control nulls

  • the difference between nulls and zero-length strings

  • how to work with nulls and zero-length strings in fields

  • the difference between the Nz and IsNull functions

  • how to format dates

  • how to calculate time spans between dates


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint