Error Number No Records Found

[amywolfie]

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
===

[MGFoster]

-----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:

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
===

[PC Datasheet]

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
re******@pcdatasheet.com
www.pcdatasheet.com
"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om...

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
===

[Pieter Linden]

am*******@verizon.net (amywolfie) wrote in message news:<33**************************@posting.google. com>...

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
===

FileMaker... <shudder>

Use the NoData Event of the report to do this.

[amywolfie]

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
==
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

am*******@verizon.net (amywolfie) wrote in message news:<33**************************@posting.google. com>...

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
===

FileMaker... <shudder>

Use the NoData Event of the report to do this.