Forms - Eye Candy

S

SCHNYDES

Trying to make my forms more distinct, adding color, functionality etc. Are
there more design templates out there aside from MS Access default selections?

Anyone might have any tips/tricks for making this happen? Thanks for the
help...

BTW using Access 2000, I know there's better functionality in 03, but what
about 00? Thanks.
 
A

Allen Browne

Danny, an unrelated comment from an article you wrote a year ago:
http://www.databasejournal.com/features/msaccess/article.php/10895_3444891_2

In the discussion on "How to add an 'ALL' item to a list", you describe a
technique that ends up:
But if "--All Employees--" was selected then all records are returned
with this criteria:
WHERE Employees.EmplNo LIKE *

I often see people do that, but it does not return all records. Null is not
returned by LIKE "*". So if you have records where the EmplNo is blank (e.g.
some fields don't have a value, or the query uses an outer join), the
technique misses records.

Certainly, others use this technique also, but I don't think we should
promote it as a reliable solution.
 
Top