Re: Msg box when you get no records in a query
From: Chris (1_at_2.de)
Date: 02/24/04
- Next message: BobRoyAce: "Copying a record"
- Previous message: Ken: "Access 2000 Validation Problem"
- In reply to: Chris: "Msg box when you get no records in a query"
- Next in thread: Chris: "Msg box when you get nOrecords in a query INSTEAD DISPLAYING IN A FORM"
- Reply: Chris: "Msg box when you get nOrecords in a query INSTEAD DISPLAYING IN A FORM"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Feb 2004 07:51:24 +0200
Thank you!
But, what if I need to display the results of the query in a form instead
of a report ? The request is now to display the results of the query in a
form and to put a cmd button in that form to open thr report when I have
records to display.
Thank tou, again,
Chris
"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: BobRoyAce: "Copying a record"
- Previous message: Ken: "Access 2000 Validation Problem"
- In reply to: Chris: "Msg box when you get no records in a query"
- Next in thread: Chris: "Msg box when you get nOrecords in a query INSTEAD DISPLAYING IN A FORM"
- Reply: Chris: "Msg box when you get nOrecords in a query INSTEAD DISPLAYING IN A FORM"
- Messages sorted by: [ date ] [ thread ]
