ACCESS FEED: Re: [MS_AccessPros] RE: HOW TO

Jumat, 24 Mei 2013

Re: [MS_AccessPros] RE: HOW TO - Hiding Form if NO Data

Actually, the "no attachments" thing is our rule. Yahoo gives me the choice to allow them or not. I chose not to to avoid viruses being spread through our emails.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Zjubias-
>
> It's not OUR rule, it's what Yahoo allows. If you want to share a file, you
> have to put it in Files / 2_AssistanceNeeded on the website, then point to
> it.
>
> Glad my solution worked for you.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ZJUbias
> Sent: Thursday, May 23, 2013 9:18 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] RE: HOW TO - Hiding Form if NO Data
>
> Hello John,
>
>
>
> First, please accept my apology if I violated the rules "I'm so sorry"
>
>
>
> Thank you for the solution, it works as intended.
>
>
>
> zjubias
>
>
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
> Sent: Friday, May 24, 2013 12:05 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] RE: HOW TO - Hiding Form if NO Data
>
>
>
>
>
> zjubias-
>
> You cannot include attachments or embedded images on this forum, but I get
> the idea. You could try this in the outer form's Current event:
>
> If Me.NameOfSubformControl.Form.Recordset.RecordCount = 0 Then
> Me.NameOfSubformControl.Visible = False Else Me.NameOfSubformControl.Visible
> = True End If
>
> Note that you will have to substitute the real name of your subform.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of ZJUbias
> Sent: Thursday, May 23, 2013 3:26 PM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] RE: HOW TO - Hiding Form if NO Data
>
> Dear All,
>
> I have a form that I put in another form to show record(s) if there is
> record in it. This form is a continuous form and recordsource is based on a
> query.
>
> I want to hide this form (see below image) if there is no record.
>
> Can someone please show me how to do it..
>
> Thank you in advance
>
> Zjubias
>
> Message Form.bmp
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>