IIF STATEMENT

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred's - 19 Jun 2007 18:22 GMT

Hello folks,

I will like to create a IIF statement, because if there is no records
entered, between a starting date and a ending date, I will like that
my report show something like this: "No records for this period"

Hope that somebody can help me with this...

Thank you all in advance for your help and support.

Fred's

Reply to this Message

Wayne-I-M - 19 Jun 2007 19:37 GMT

Hi

You mention reports so I asume you are looking a way to cancel a report
after dsiplaying a message to a user ??

You can use the report's On No Data event (in the properties box)

MsgBox "No records for this period."
Cancel = True

Signature

Wayne
Manchester, England.

> Hello folks,
>
[quoted text clipped - 7 lines]
>
> Fred's

Reply to this Message

Fred's - 21 Jun 2007 23:50 GMT

Hi Wayne,

Thanks for the tips, but this is not exactly what I'm searching for.
I'm searching a way to see this sentance "No records for this period."
directly on my report, and not as a Msg box.

Thanking you in advance for your continuous help!

Fred's

On Jun 19, 2:37 pm, Wayne-I-M <Wayn...@discussions.microsoft.com>
wrote:

> Hi
>
[quoted text clipped - 23 lines]
>
> - Show quoted text -

Reply to this Message

Bob Quintal - 22 Jun 2007 00:32 GMT

> Hi Wayne,
>
[quoted text clipped - 6 lines]
>
> Fred's

So add a label on your report header that says that.
Set its visible property to MO. use the on no data event to
change the visible property to yes.

> On Jun 19, 2:37 pm, Wayne-I-M
> <Wayn...@discussions.microsoft.com> wrote:
[quoted text clipped - 27 lines]
>>
>> - Show quoted text -

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message