Re: Msg box when you get no records in a query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JeffW (bid_at_sk.de)
Date: 02/23/04

Next message: Kay Davies: "Automatic unbound text box value"
Previous message: Chris: "Msg box when you get no records in a query"
In reply to: Chris: "Msg box when you get no records in a query"
Next in thread: loadhigh: "Re: Msg box when you get no records in a query"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 23 Feb 2004 09:57:55 +0100

Chris

you can put your MsgBox in the NoData event of the report. Then on the next
line: Cancel = True.

HTH,
Jeff

"Chris" <1@2.de> wrote in message
news:uTPYehe#DHA.692@TK2MSFTNGP12.phx.gbl...
> From a command button of o form, i display a report based on a query wich
> returns the operations made in a period of time.
> If I have no records, I get a blank report.
> Is possible to get instead of it a MSG BOX with a text like "There are no
> operations in the period 'fromDate' - 'toDate' !" (where 'fromDate' &
> 'toDate' are the dates of the begining and the end of the period taken
from
> the form)
>
> I would apreciate any ...HEEEELP!!!!
>
>
>

Next message: Kay Davies: "Automatic unbound text box value"
Previous message: Chris: "Msg box when you get no records in a query"
In reply to: Chris: "Msg box when you get no records in a query"
Next in thread: loadhigh: "Re: Msg box when you get no records in a query"
Messages sorted by: [ date ] [ thread ]