Forms - Eye Candy

G

Guest

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

RobFMS

Allen

In some experiences I have had, users select "all" with the understanding
that non-null data is going to be returned. To go one step further, an
additional option (figuratively speacking) is usually put in place for the
user to select if they want to return records where "field has no value".


--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top