Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book