ACCESS FEED: Re: [MS_AccessPros] Re: my popup sometime opens in that stupid black minimized rectangle

Hi Terence,

> "a popup form will resort to its most recent sizing and placement"

a form will resort to its SAVED properties ... so important to NOT save form when users close it (that will overwrite how you saved it) -- and make sure whenever you save it, sizing and placement is as it should be

1. form properties: Close Button --> No

2. code to close form for user:

DoCmd.Close acForm, Me.Name, acSaveNo

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Tue, 8/2/11, Terence wrote:

> Ty John, that was an excellent
> summary.
>
> In my continuation of this issue, I have found some
> isolated reported incidents of the popups doing similar
> unpredictable behavior.
>
> I realize that trying to chase and trap this is more a moot
> point, and what I really want is a technique that will
> prevent my popups from going into that rectangle thingy.
>
> Once solution of course would be to place code in the "On
> Load event to force size".
>
> These particular forms may well be used on tablets which I
> have no control over resolution, orientation or dimension.
> It is therefore most desirable that I allow sizing to take
> place.
>
> This will probably be my last post on this particular
> issue, as Size code in the On Load should do the trick.
> However! I personally am convinced, that there is still
> something unknown, or odd, or perhaps not CERTAIN, that in
> access 2007 windows 7, that a popup form will resort to its
> most recent sizing and placement......Its just not something
> I would bet on.
>
> TY John, Crystal, and the others who have assisted me in
> this one....If I find more substantive info I will write
> again on this subject.
>
> Thanx
> terence
>
>
>
>
> --- "John Viescas" <john@...> 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.
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >