October 1997 Tips and Tricks:

1. VB and Access:  In a  query you can change the title alias but cannot change the title.

2. VB and Access:  Do not use # (pound sign) in the name of a field (at the end) because this makes it a declaration for a double precision number.

3. VB and Access: SQL-Query Builder:  Order in Sort Sequence is from left to right.

4. VB and Access:  Always base a sub form on a query, not on a table.

Copyright 1998, 1999, 2000, 2001 Diablo Valley PC Users Group. All rights reserved.