P
Parker
When I use the applyfilter method how do I check to see if any records were
returned? I'm using Access 2002 sp3.
Thankyou
returned? I'm using Access 2002 sp3.
Thankyou
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John W. Vinson
When I use the applyfilter method how do I check to see if any records were
returned? I'm using Access 2002 sp3.
Thankyou
I presume this is on a Form? Check the form's recordsetclone:
If Me.RecordsetClone.RecordCount > 0 then
' records were returned
Else
' none were
End If
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
P
Parker
That worked. Thank you.From: John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
Newsgroups: microsoft.public.access.formscoding
Subject: Re: Applyfilter
Date: Sun, 16 Sep 2012 15:18:40 -0600
Organization: Wysard of Information
Reply-To: [email protected]
Message-ID: <[email protected]>
References: <[email protected]>
X-Newsreader: Forte Agent 6.00/32.1186
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: static-74-41-143-137.br1.mcl.id.frontiernet.net
X-Trace: news.bnb-lp.com 1347830323
static-74-41-143-137.br1.mcl.id.frontiernet.net (16 Sep 2012 17:18:43
-0400) Lines: 21
X-Authenticated-User: pa1113
X-DMCA-Complaints: Send abuse or DMCA complaints to [email protected]
X-DMCA-Complaints: The subject line should contain only the 4 letters
DMCA Path:
border1.nntp.dca.giganews.com!border4.nntp.dca.giganews.com! border2.nnt
p.dca.giganews.com!nntp.giganews.com!news.bnb-lp.com!not-for-mail