Re: Can I get rid off the blank item in drop down list?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Mon, 11 Apr 2005 01:49:04 -0700, Sam Kuo wrote:

> Hi Fred,
> Thanks for your help. But the Where clause causes a syntax error (missing
> operator) in query expression '[DWGNo] Where [DWGNo] is not null'
>
> How to fix this?
>
> Regards,
> Sam
>
> "fredg" wrote:
>
>> On Sun, 10 Apr 2005 03:27:03 -0700, Sam Kuo wrote:
>>
>>> Hi everyone,
>>>
>>> I have a combo box with its RowSource based on a query. Its RowSource
>>> property looks like this:
>>>
>>> SELECT DISTINCT [DWGNo] FROM qryReidProductDrawings ORDER BY [DWGNo];
>>>
>>> Because there are some blank records in the DWGNo field of
>>> qryReidProductDrawings, the drop down list also contains a blank item as a
>>> selection option. Can I somehow get rid off the blank item from the combo
>>> box's drop down list? Any suggestion is appreciated.
>>>
>>> Regards,
>>> Sam
>>
>> SELECT DISTINCT [DWGNo] FROM qryReidProductDrawings ORDER BY [DWGNo]
>> Where [DWGNo] is not null;
>>
>> --
>> Fred
>> Please only reply to this newsgroup.
>> I do not reply to personal email.
>>

Yeah, I just added the where clause at the end, but I should have
placed in before the Order By.
.... Where [DWGNo] is not null Order By [DWGNo];
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

Relevant Pages

  • Re: Can I get rid off the blank item in drop down list?
    ... Sam ... But the Where clause causes a syntax error (missing ... >> Regards, ... >>> I do not reply to personal email. ...
    (microsoft.public.access.forms)
  • How to erase a very old newsgroups post ?
    ... I was such a noob that I used my very personal email to ... Is there any way to erase this post from this newsgroup? ... Regards ...
    (comp.sys.hp.hpux)
  • Re: Yes/No
    ... > Regards. ... Please only reply to this newsgroup. ... I do not reply to personal email. ...
    (microsoft.public.access.gettingstarted)
  • Re: high cpu utilization with WINS running
    ... Best regards ... This newsgroup only focuses on SBS technical issues. ... When opening a new thread via the web interface, we recommend you check ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • Re: Text search fails
    ... > regards, Ger. ... >> Thank you for posting in the SBS newsgroup. ... >> Microsoft.public.sqlserver.fulltext newsgroup. ... >> Windows SharePoint Services on a Windows Small Business Server ...
    (microsoft.public.windows.server.sbs)