By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,499 Members | 829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,499 IT Pros & Developers. It's quick & easy.

Error Number No Records Found

P: n/a
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
===
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
-----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
===


Nov 12 '05 #2

P: n/a
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
===

Nov 12 '05 #3

P: n/a
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.
Nov 12 '05 #4

P: n/a
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.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.