ACCESS FEED: RE: [MS_AccessPros] Do not display a form if the control source (a query) return no rows

Rabu, 25 Juli 2012

RE: [MS_AccessPros] Do not display a form if the control source (a query) return no rows

I think this is pretty quick and easy

If Me.RecordSet.RecordCount = 0 Then
MsgBox "Sorry but there are no records to display!"
Cancel = True
End If

Bob Peterson

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Thomas
Sent: Wednesday, July 25, 2012 1:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Do not display a form if the control source (a query) return no rows

Hi Crystal,

So I still have to check if there is something to be displayed on the form and then do something.

There is no quick and easy way of checking if zero row is return or something like that.

Regards,
Thomas

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Thomas,
>
> the Form OPEN Event has Cancel
>
> Warm Regards,
> Crystal
>
> Learn Access on YouTube
> http://www.YouTube.com/LearnAccessByCrystal
>
>
> *
> (: have an awesome day :)
> *
>
>
>
> ________________________________
> From: Thomas <thomas_lam_us@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, July 24, 2012 5:40 PM
> Subject: [MS_AccessPros] Do not display a form if the control source (a query) return no rows
>
> What is the event which will be fired under this condition? Can I display a message box and then issue the CANCEL = TRUE to suppress the form from displaying?
>
> Regards,
> Thomas
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>

------------------------------------

Yahoo! Groups Links