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

O Kee Do Kee--it's harder than I thought :-). I am already passing one open arg to it (the number of record to look for) and now I want to also pass "Hide Buttons".

Can I pass several args and if so how?

Thanks!
Connie

--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> 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
> >
>