Error Number No Records Found

Hi All:

In FileMaker Pro, the error number for "no records found" is 401.

What is the equivalent error number in Access (2003)? I want to
capture for the "On Open" Event of a report. If there are no records
found, then return to the Switchboard and close the report.

Thanks!

amy
===

re: Error Number No Records Found

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Access provides another method, the NoData event in the report object:

Open the report in design view.
Open the Properties dialog box for the Report.
Select the Events tab.
Double-click the ComboBox to the right of the On No Data event so the
item [Event Procedure] appears.
Click the "..." button to the right of [Event Procedure].
Enter something like the following in the OnNoData event procedure:

MsgBox "No data for this report", vbCritical
Cancel = True

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQA701YechKqOuFEgEQKvDACeLcqGuo/k7gOJVolVQwn/zS2884sAoOI1
RIsDGc8XzjuazUfBwx5ApLDY
=1RcO
-----END PGP SIGNATURE-----


amywolfie wrote:
[color=blue]
> Hi All:
>
> In FileMaker Pro, the error number for "no records found" is 401.
>
> What is the equivalent error number in Access (2003)? I want to
> capture for the "On Open" Event of a report. If there are no records
> found, then return to the Switchboard and close the report.
>
> Thanks!
>
> amy
> ===[/color]

re: Error Number No Records Found

Amy,

Use the NoData event of the report and you don't have to deal with it in the
Open event.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com


"amywolfie" <amywolfie@verizon.net> wrote in message
news:33651c5d.0401210951.27cb969a@posting.google.c om...[color=blue]
> Hi All:
>
> In FileMaker Pro, the error number for "no records found" is 401.
>
> What is the equivalent error number in Access (2003)? I want to
> capture for the "On Open" Event of a report. If there are no records
> found, then return to the Switchboard and close the report.
>
> Thanks!
>
> amy
> ===[/color]

re: Error Number No Records Found

amywolfie@verizon.net (amywolfie) wrote in message news:<33651c5d.0401210951.27cb969a@posting.google. com>...[color=blue]
> Hi All:
>
> In FileMaker Pro, the error number for "no records found" is 401.
>
> What is the equivalent error number in Access (2003)? I want to
> capture for the "On Open" Event of a report. If there are no records
> found, then return to the Switchboard and close the report.
>
> Thanks!
>
> amy
> ===[/color]

FileMaker... <shudder>

Use the NoData Event of the report to do this.

re: Error Number No Records Found

No need to shudder, Pieter! FileMaker has its uses too :>

Thanks everyone for the tip on the No Data function. That's even
easier than having to write code citing an error number!

Amy
==


pietlinden@hotmail.com (Pieter Linden) wrote in message news:<bf31e41b.0401211728.662eb51b@posting.google. com>...[color=blue]
> amywolfie@verizon.net (amywolfie) wrote in message news:<33651c5d.0401210951.27cb969a@posting.google. com>...[color=green]
> > Hi All:
> >
> > In FileMaker Pro, the error number for "no records found" is 401.
> >
> > What is the equivalent error number in Access (2003)? I want to
> > capture for the "On Open" Event of a report. If there are no records
> > found, then return to the Switchboard and close the report.
> >
> > Thanks!
> >
> > amy
> > ===[/color]
>
> FileMaker... <shudder>
>
> Use the NoData Event of the report to do this.[/color]