O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Quotes and Pounds

Using variables with quotes and pounds seems so simple at first glance. Yet it is amazing how much havoc and frustration these seemingly simple operations have brought to novice and advanced Access developers alike. Several ways to handle the difficulties that can arise are detailed here.

Quotes

It’s ironic that the small things in Access often can be the most difficult to master. Quotes are a prime example. In some situations, quotes don’t seem that challenging. For example, if you try to create a filter using a text field, you just use an expression like this:

[State] = "Oklahoma" 

At this point, there is nothing challenging in any way. You get into trouble when you try to embed a string variable inside another string. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required