Re: VBA Access Searching...
VB Code:
"SELECT Col1, Col2 FROM Table1 WHERE Col2 = '';"
DEpends on your Col2 field data type. If its text then that will work.
Re: VBA Access Searching...
Depends on how you are outputting it.
if straight from Sql (bound for example)
Code:
"SELECT Col1, iif(nz(len(Col2),0)=0,"-- Not Set --",Col2) FROM Table1"
If you are looping through code then put a check for isnull and for zero length. If its either of these then print up "--not set--" in that part, otherwise put in the fields contents
Re: VBA Access Searching...
Well I am getting a number from a form then I want to search column 1 to make sure its there, if its there I need to know if it has a description in column2. I would like to be able to have a msgbox pop up if the number not found or if the number is found and there is no description...