ACCESS FEED: Re: [MS_AccessPros] DoCmd.OpenForm and then hide buttons on that form

Selasa, 06 November 2012

Re: [MS_AccessPros] DoCmd.OpenForm and then hide buttons on that form

Thanks John! What's interesting is that the Modal part is working. When I think about it using OpenArgs should be easy. Thanks once again!
Connie

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Connie-
>
> Won't work - at least not the Modal part. That has to be set before the
> form opens.
>
> Consider passing an OpenArgs to the form to tell it to hide all the
> buttons, then do the button.Visible = False in the Load event of
> Search_HomeInfo.
>
> 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: mrsgoudge <no_reply@yahoogroups.com>
> Reply-To: <MS_Access_Professionals@yahoogroups.com>
> Date: Tuesday, November 6, 2012 6:16 PM
> To: <MS_Access_Professionals@yahoogroups.com>
> Subject: [MS_AccessPros] DoCmd.OpenForm and then hide buttons on that form
>
> 'Open Search_HomeInfo form with current listings, hiding buttons and
> making modal
> DoCmd.OpenForm "Search_HomeInfo"
> Forms!Search_HomeInfo.btnChange.Visible = False
> Forms!Search_HomeInfo.btnTracking.Visible = False
> Forms!Search_HomeInfo.Command125.Visible = False
> Forms!Search_HomeInfo.cboAddress.Visible = False
> Forms!Search_HomeInfo.cboParcelN.Visible = False
> Forms!Search_HomeInfo.Refresh
> Forms!Search_HomeInfo.Modal = True
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>