excellent summary, John! thanks
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Mon, 8/1/11, John Viescas wrote:
> Terence-
>
> There are a number of things that control the way a form
> looks when it opens.
> First, there are these Form properties:
>
> Pop Up -- If you set PopUp = Yes, the form window "floats"
> on top of all other
> windows, including the Access application window. The
> window opens to the size
> it was when you last saved its design unless you also have
> AutoResize set to
> Yes. If you don't have the Modal property set to Yes,
> you can move the focus to
> other windows "behind" the popup, but the popup window will
> still be on top and
> perhaps will cover other windows.
>
> Modal -- If you set Modal = Yes, the window opens as a
> Dialog, and you cannot
> move the focus to any other window until this windows
> closes. You would
> normally set both PopUp = Yes and Modal = Yes to open the
> form window as a
> dialog box.
>
> Default View -- Use this to define the "normal" view for
> the window - Single
> Form, Continuous Forms, Datasheet, Pivot Table, Pivot
> Chart, or Split Form.
> Setting Modal = Yes will keep you from changing the view of
> the form when it is
> open.
>
> Allow Form View -- Lets the user switch to Form View if
> that is not the "normal"
> view.
>
> Allow Datasheet View -- Lets the user switch to Datasheet
> View if that is not
> the "normal" view.
>
> Allow PivotTable View -- Lets the user switch to PivotTable
> View if that is not
> the "normal" view.
>
> Allow PivotChart View -- Lets the user switch to PivotChart
> View if that is not
> the "normal" view.
>
> Allow Layout View -- Lets the user switch into Layout
> design mode if that is not
> the "normal" view. Note that this property was called
> Allow Design Changes in
> versions prior to 2007.
>
> Auto Center -- Opens the form in the "center" of the Access
> workspace (if not a
> popup form) or the Access window (if a popup form)
>
> Auto Resize -- Effectively does a Window / Size to Fit when
> the form opens.
>
> Border Style -- Set to None to show no border, and no Close
> Button, Control
> menu, Maximize, and Minimize buttons. The form isn't
> resizable. Note that the
> ONLY way to close a form with a None border is to provide a
> command button to
> issue the DoCmd.Close command.
>
> Set to Thin to show a thin border
> with all buttons. The
> form isn't resizable.
>
> Set to Sizable to provide a
> "normal" border with all
> buttons. The form is resizable.
>
> Set to Dialog to provide a thick
> border with a Control menu
> and Close button. The form cannot be minimized,
> maximized or resized.
>
> Record Selectors, Navigation Buttons, Navigation Caption,
> Dividing Lines, Scroll
> Bars -- These properties turn the related design elements
> on and off, but are
> not affected by the settings of any of the other
> properties.
>
> Control Box -- When Yes, shows the "control box" in the
> upper left corner unless
> Border Style is set to None.
>
> Close Button -- When Yes, shows the "X" close button in the
> upper right corner
> unless Border Style is set to None.
>
> MinMax Buttons -- Determines which of the Minimize or
> Maximize buttons show up
> unless Border Style is set to None.
>
>
> Second, there are options in DoCmd.OpenForm:
>
> View -- You can ask for the form to be opened in Design,
> Datasheet, PivotChart,
> PivotTable, Layout, Normal (Form) views or Print
> Preview. Note that even if the
> form's Default View is something other than Form View,
> Continuous Forms, or
> Split Form, the form will open in "Form" view when you use
> the Normal default
> setting. For example, the only way to use OpenForm to
> open a form in Datasheet
> view is to specifically ask for Datasheet in the command.
>
> WindowMode -- You can ask for the form to be opened as a
> Dialog, Hidden, a
> minimized Icon, or "Normal". Specifying Dialog
> automatically sets the Popup and
> Modal properties to Yes. It also stops all code from
> running until the form is
> closed or hidden. Hidden opens the form with its
> Visible property set to No.
> (You cannot set Visible in Design view - only with OpenForm
> or in Code.) Icon
> opens the window minimized on the desktop unless Border
> Style prevents
> minimizing. Normal honors all the form design
> settings.
>
>
> Does that help?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> 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 Terence
> Sent: Tuesday, August 02, 2011 3:07 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: my popup sometime opens in
> that stupid black
> minimized rectangle
>
> Crystal, My default view is split view.
>
> But hold on a moment, "Dialog view: does not show up in the
> properties drop down
> box as an option for a Default View of a Form Format ...??
>
> I thought this thing would be more akin to minimized,
> maximized, and weird
> rectangle thingy ?
> Terence
>
> --- In MS_Access_Professionals@yahoogroups.com,
> Crystal <strive4peace2008@...>
> wrote:
> >
> > Hi Terence,
> >
> > check the Default View property of the form ;)
> >
> > Warm Regards,
> > Crystal
> >
> > *
> > (: have an awesome day :)
> > *
> >
> >
> > --- On Mon, 8/1/11, Terence wrote:
> >
> > > OK, I am out of the water, my popups
> > > seem to be holding, but I probably will put
> "Size" code in
> > > the forms to prevent any mishap. HOWEVER.... as
> Crystal
> > > stated "referring to dialog view", so I guess
> that is what
> > > the stupid rectangle is called. I have to now
> ask...What are
> > > the rules, Under what conditions, under what
> circumstances,
> > > does Windows/Office.... decide to present a
> window in that
> > > fashion ?
> > >
> > > Terence
> > >
> > >
> > >
> > >
> > >
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com,
> > > "Bill Mosca" <wrmosca@> wrote:
> > > >
> > > > You're welcome, Crystal.
> > > >
> > > >
> > > >
> > > > Looks like I fat-fingered another post.
> > > <g>
> > > >
> > > >
> > > >
> > > > #1 should have read "Access seems to know
> how to size
> > > a form PROPERLY when you
> > > > do that."
> > > >
> > > > #2 should have read "THEN save it."
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Regards,
> > > >
> > > > Bill
> > > >
> > > >
> > > >
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > > [mailto:MS_Access_Professionals@yahoogroups.com]
> > > On Behalf Of Crystal
> > > > Sent: Sunday, July 31, 2011 12:12 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: RE: [MS_AccessPros] Re: my popup
> sometime
> > > opens in that stupid black
> > > > minimized rectangle
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > hi Bill,
> > > >
> > > > thanks! ... definitely going into the
> archives ...
> > > >
> > > > Warm Regards,
> > > > Crystal
> > > >
> > > > *
> > > > (: have an awesome day :)
> > > > *
> > > >
> > > > --- On Sun, 7/31/11, Bill Mosca wrote:
> > > >
> > > > > Terence
> > > > >
> > > > >
> > > > >
> > > > > This is what I do to prevent a form
> from sizing
> > > itself
> > > > > weirdly:
> > > > >
> > > > > 1. I always design in
> > > maximized
> > > > > size. Access seems to know how to size
> a
> > > > > form property when you do that.
> > > > >
> > > > > 2. If a form opens with
> > > the wrong
> > > > > size I go to (Acc2003)
> menu>window>size to
> > > > > fit form;(Acc2010)
> Home>window>size to fit
> > > form. Ten
> > > > > save it.
> > > > >
> > > > > To make things even easier, I develop
> with a
> > > macro named
> > > > > AutoKeys. There is an
> > > > > old one in our files section. With it,
> all I do
> > > is press
> > > > > Ctrl+B. It does all the
> > > > > work in one motion.
> > > > >
> > > > >
> > > > >
> > > > > Regards,
> > > > > Bill Mosca,
> > > > > Founder, MS_Access_Professionals
> > > > > That'll do IT <http://thatlldoit.com> http://thatlldoit.com
> > > > > MS Access MVP
> > > > > <http://mvp.support.microsoft.com/profile/Bill.Mosca>
> > > > > http://mvp.support.microsoft.com/profile/Bill.Mosca
> > > > >
> > > > >
> > > > >
> > > > > From: Terence
> > > >
> > > > >
> > > > > Well I just went through opening them
> all up,
> > > there are 12
> > > > > I think, I re sized
> > > > > them all, and save them properly. Close
> the DB,
> > > then went
> > > > > for coffee. I came
> > > > > back and they all worked but one. So I
> re sized
> > > it. I will
> > > > > drink more coffee and
> > > > > try again. I think the pattern has
> something to
> > > do with the
> > > > > US Congress raising
> > > > > the debt ceiling.
> > > > >
> > > > > :)
> > > > >
> > > > > I just wished I had a bit more
> certainty and
> > > confidence
> > > > > that these windows will
> > > > > act as I want them to. This application
> is being
> > > used for a
> > > > > Geriatric Physical
> > > > > Therapy clicnic, and some of these
> forms will be
> > > used on
> > > > > Tablets. I prefer NOT
> > > > > having DOCS throw the tablets at
> patients :)
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com
> > > >
> > >
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > >
> > >
> <mailto:MS_Access_Professionals%40yahoogroups.com> ,
> > > > > "buffalome90210"
> > > > > <buffalome90210@> wrote:
> > > > > >
> > > > > > TY Crystal, my mehtod of open is
> the
> > > standard stuff, I
> > > > > am using a Macro
> > > > > > OpenForm History 3 Meter Walk Test
> Fast,
> > > Form, , , ,
> > > > > Normal
> > > > > >
> > > > > > as far as the properties for the
> form named
> > >
> > > > > > "History 3 Meter Walk Test Fast"
> > > > > > I have tried about everything,
> It's NOT
> > > MODAL, and it
> > > > > is popup.
> > > > > >
> > > > > > Default view is split with
> datasheet at
> > > bottom
> > > > > > Control Box - yes
> > > > > > Scroll bars Yes
> > > > > > MIN MAX - NONE
> > > > > > Close Button - Yes
> > > > > > No Navigation Buttons
> > > > > > Border style = Sizable
> > > > > > Auto center - No
> > > > > > Auto resize - yes
> > > > > > Fit to screen - yes
> > > > > >
> > > > > > These are my current
> settings......The odd
> > > thing is ,
> > > > > it does not always
> > > > > resort to that weird rectangle thingy.
> > > > > >
> > > > > > And I am unable to predict it, or
> determine
> > > a
> > > > > pattern.
> > > > > >
> > > > > > My pie in the sky solution wouold
> be to find
> > > the
> > > > > property that says:
> > > > > >
> > > > > > Weird Rectangle Thingy = NO
> > > > > >
> > > > > > Anything obvious ?
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --- Crystal <strive4peace>
> wrote:
> > > > > > >
> > > > > > > Terence... sorry I spelled
> your name
> > > wrong! I
> > > > > fixed it ... so no evidence
> > > > > but the original post ;) ~Crystal
> > > > > > >
> > > > > > > --- On Sat, 7/30/11, Crystal
> wrote:
> > > > > > >
> > > > > > > > hi Terence,
> > > > > > > >
> > > > > > > > sorry you are frustrated
> ... maybe
> > > it is
> > > > > time to take a
> > > > > > > > break -- sometime that
> is better
> > > than
> > > > > working so you can get
> > > > > > > > your mind fresh again.
> I
> > > need a break
> > > > > too ... maybe I
> > > > > > > > will go singing tonight
> ;)
> > > > > > > >
> > > > > > > > > "ridiculous
> rectangle"
> > > > > > > >
> > > > > > > > are you referring to
> dialog view
> > > which make
> > > > > a form appear
> > > > > > > > as a popup? Please
> post the
> > > procedure
> > > > > that opens your
> > > > > > > > form so we can see your
> parameters
> > > to
> > > > > DoCmd.OpenForm
> > > > > > > >
> > > > > > > > also, check the
> following FORM
> > > properties:
> > > > > > > >
> > > > > > > > Default View
> > > > > > > > Popup
> > > > > > > > Modal
> > > > > > > >
> > > > > > > > Warm Regards,
> > > > > > > > Crystal
> > > > > > > >
> > > > > > > > *
> > > > > > > > (: have an awesome
> > > day :)
> > > > > > > > *
> > > > > > > >
> > > > > > > >
> > > > > > > > --- On Sat, 7/30/11,
> Terence
> > > wrote:
> > > > > > > >
> > > > > > > > > Frustrated.
> > > > > > > > >
> > > > > > > > > I have a popup form
> with a
> > > button. The
> > > > > button uses a
> > > > > > > > macro
> > > > > > > > > to open another
> popup from.
> > > The macro
> > > > > uses "normal". I
> > > > > > > > have
> > > > > > > > > tried a plethora of
> options
> > > on the
> > > > > format of this
> > > > > > > > form,. yet
> > > > > > > > > time after time
> this stupid
> > > form open
> > > > > up in that ugly
> > > > > > > > > ridiculous
> rectangle, that
> > > confounds
> > > > > most people of
> > > > > > > > the
> > > > > > > > > world on what the
> hell to do
> > > with it.
> > > > > > > > >
> > > > > > > > >
> > > FRUSTRATED~!!!!!!!!!!!!!!!!!!!
> > > > > > > > >
> > > > > > > > > I want an option, a
> WAY, so
> > > this form
> > > > > can NEVER get to
> > > > > > > > that
> > > > > > > > > state !
> > > > > > > > >
> > > > > > > > > Terence
> > > > > > > > > sorry for my
> pontifical
> > > rhetoric.
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
Tidak ada komentar:
Posting Komentar