Re: Kryterium w kwerendzie

Article View: pl.comp.bazy-danych.msaccess

Article #137272

Back to pl.comp.bazy-danych.msaccess Previous Next

#137272

From: PB
Date: Thu, 01 Sep 2016 22:30

27 lines
1439 bytes

Super, o to chodziło.

Dziękuję.


W dniu 2016-08-31 o 11:26, Zbigniew Bratko pisze:
>
> Spróbuj użyć w kwerendzie operatora LIKE:
>
> Like (FStatus())
>
> A funkcja FStatus dla parametru WSZYSTKIE niech zwraca "*"
>
> Coś w tym rodzaju:
>
> Public Function FStatus() As String
> Dim sStatus As String
>
>    sStatus = Nz(Forms("frmStatus").cboWybierzStatus)
>
>    If StrComp(sStatus, "Wszystkie", vbTextCompare) = 0 Then
>      FStatus = "*"
>    Else
>      FStatus = sStatus
>    End If
>
> End Function

Technical Details

Message-ID: <nqaa6d$s71$1@node2.news.atman.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mail

References: <nq3dsl$aq8$1@node2.news.atman.pl> <nq67s8$v8c$1@node2.news.atman.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mail
From: PB <pawelboguszewski@gazeta.pl>
Newsgroups: pl.comp.bazy-danych.msaccess
Subject: Re: Kryterium w kwerendzie
Date: Fri, 2 Sep 2016 00:30:34 +0200
Organization: ATMAN - ATM S.A.
Lines: 28
Message-ID: <nqaa6d$s71$1@node2.news.atman.pl>
References: <nq3dsl$aq8$1@node2.news.atman.pl> <nq67s8$v8c$1@node2.news.atman.pl>
NNTP-Posting-Host: 94.158.236.140
Mime-Version: 1.0
X-Trace: node2.news.atman.pl 1472769037 28897 94.158.236.140 (1 Sep 2016 22:30:37 GMT)
X-Complaints-To: usenet@atman.pl
NNTP-Posting-Date: Thu, 1 Sep 2016 22:30:37 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.7.2
In-Reply-To: <nq67s8$v8c$1@node2.news.atman.pl>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message